It took me some time to grasp the correct syntax for utilizing an XML format file in a BULK INSERT operation from Azure Blob Storage,… Read More »How to use XML Format File with BULK INSERT from Azure Blob Storage
If you encounter the following screen when triggering a run from a Model Driven App, you likely need to rebuild the whole flow (the trigger… Read More »Trigger error when running a flow from a Model Driven App
You can monitor the Power Automate Desktop runs from the maker portal by navigating to the Monitor -> Desktop flow runs -> Current runs. … Read More »How to delete stuck jobs from the Power Automate Desktop queue?
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
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)
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?
Regarding my previous post: https://powerplatform.fi/how-to-read-a-csv-file-from-sharepoint-to-azure-sql-with-power-automate/ I got a question about how to read a JSON (not csv!) from Azure Blob Storage to Azure SQL. And yes, this… Read More »How to read JSON file from Blob Storage to Azure SQL?
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.’
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?