Excel Online just blank error – how to fix
In June 2023, I started to notice that opening the list views on a model-driven app does not work in some environments. Just a blank… Read More »Excel Online just blank error – how to fix
Power Platform
How to overcome the 20 MB file size limit with File System action? (Error RequestEntityTooLarge)
Creating integrations with Logic Apps (or Power Automate) and using the File System action through a gateway to your own server can get really tricky… Read More »How to overcome the 20 MB file size limit with File System action? (Error RequestEntityTooLarge)
How to update lookup fields based on an alternate key with Power Automate?
Let’s say that you are importing Contacts to Dataverse and you would like to set the parent account lookup field based on a Company’s Business… Read More »How to update lookup fields based on an alternate key with Power Automate?
How to count the number of rows of SQL query result set?
Here’s how you can get the number of rows returned by SQL statement in Power Automate Desktop: %QueryResult.RowsCount%
XML error – XML value cannot be parsed: ‘There is no Unicode byte order mark. Cannot switch to Unicode.’
Today, I tried to convert an XML document to JSON, and found a new error that I don’t have seen earlier: XML value cannot… Read More »XML error – XML value cannot be parsed: ‘There is no Unicode byte order mark. Cannot switch to Unicode.’
Search option missing in the dropdown slicer?
I’m constantly struggling to find the correct places for editing slicer settings as the updates last autumn changed the behavior. Today, I found out that… Read More »Search option missing in the dropdown slicer?
How to read a CSV file from SharePoint to Azure SQL with Power Automate?
CSV files are a common source of data for reporting purposes, and are usually delivered as email attachments or appearing in SharePoint, etc. Power Automate… Read More »How to read a CSV file from SharePoint to Azure SQL with Power Automate?
How to insert JSON from Power Automate to Azure SQL?
In Power Automate, you are handling quite often data in a JSON format which data can come from various sources, Dataverse, APIs etc. Instead of… Read More »How to insert JSON from Power Automate to Azure SQL?
Quickly navigate on a report with multiple tabs
Today, I learned you could right-click on the bottom left corner arrows on Power BI to show a list of all the tabs: This is… Read More »Quickly navigate on a report with multiple tabs
Power Automate Desktop script “source code”
Today, I was trying to figure out how to edit the Power Automate Desktop flows’ source code directly, because I had to do some changes… Read More »Power Automate Desktop script “source code”
- « Previous
- 1
- 2
- 3
- 4
- Next »