When crafting a new security role for your model-driven app, let’s consider using the “App Opener” role as a foundation. This choice offers good functionality… Read More »Security role for enabling Excel export
I’m sorry that this guide is super limited, but it will give you an overall idea of what to do if you get stuck with… Read More »Power Automate Word Template and text formatting
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%