Power Automate Word Template and text formatting
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
Power Automate
Trigger error when running a flow from a Model Driven App
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
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?
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.’
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?
A quick way to update multiple records from an Excel list to Dataverse with Power Automate
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
LEFT & RIGHT functions 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
How to split a string into an array by line breaks in 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?