How to count the number of rows of SQL query result set?
Here’s how you can get the number of rows returned by SQL statement in Power Automate Desktop: %QueryResult.RowsCount%
Here’s how you can get the number of rows returned by SQL statement in Power Automate Desktop: %QueryResult.RowsCount%
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?
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?
Today, I learned you could right-click on the bottom left corner arrows on Power BI to show a list of all the tabs: This is… Read More »Quickly navigate on a report with multiple tabs
Today, I was trying to figure out how to edit the Power Automate Desktop flows’ source code directly, because I had to do some changes… Read More »Power Automate Desktop script “source code”
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)
NOTE: This approach only works when you have SQL authentication enabled on your Azure SQL server, which is not the recommended practice. However, I don’t… Read More »How to connect to Azure SQL with Power Automate Desktop?
Here’s a list of use cases for using ChatGTP with Power Platform. I’m updating this list whenever I find something interesting/useful. Feel free to share… Read More »Power Platform and ChatGPT