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
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?
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.’
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?
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?
Updating data to Dataverse based on Excel files is a task that should be routine for all Power Platform consultants and there are plenty of… Read More »A quick way to update multiple records from an Excel list to Dataverse with Power Automate
Power Automate does not have left and right functions available as expressions. Here’s a workaround that I used to check if an email’s attachment file… Read More »LEFT & RIGHT functions with Power Automate
Create a new variable that contains just a linebreak (it’s invisible in the pic): Use Compose to split the array by the linebreak variable. Expression: … Read More »How to split a string into an array by line breaks in Power Automate?
It is quite simple, just use the Filter Array -action and leave the condition empty: