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.’
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?
Here’s a tip that I guess no one will ever use, but I find it interesting. I have never used the display custom form action… Read More »Use your own Adaptive Cards in Display Custom Form action (Power Automate Desktop)
Here’s an example of comparing multiple variable values in one IF statement on Power Automate Desktop. In this example, I check if the first number of… Read More »Compare multiple variables at once in an IF statement (Power Automate Desktop)
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
I’m quite often getting a request to check the data quality on CRM environments. You can use SQL Server Management Studio to write select statements to… Read More »How to find duplicate accounts with SQL?
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