We will create an Azure Function that will merge PDF documents stored in a container of our storage account in Azure, this function will receive the file names to be merged/combined in the parameters of the URL and they will be separated by commas. Below is an example of the POST request that the code […]
Azure Function to combine PDF files Read More »
Client secret credential type is straight forward in Power Automate, you only need to grab the secret value, paste it in the right field and you are good to go! For Certificate credentials, you need an additional step for the Pfx field value – it is simple to complete though. Let’s see how we can
Active Directory OAuth in Power Automate Read More »
In the last days Microsoft announced that Power Automate Desktop is now available for all Windows 10 users at no cost, regardless if the user has an Office365 subscription or not. In their efforts of “democratizing” automation they have opened the doors for pretty much anybody: you just need download the latest version of Power
Power Automate Desktop: now available at no additional cost. Read More »
NOTE! You can take a look at our most recent post on this topic, that is updated with the most recent features: https://powergi.net/2022/07/11/everything-about-downloading-files-from-the-web-using-power-automate/ Power Automate has evolved a lot in the recent months, and with their Desktop application they have expanded the possibilities of automation. However, it has limitations when it comes to download files
Power Automate Desktop Read More »
Use an excel table to modify your SQL query If you regularly run queries to any database in your workplace, chances are you have encountered a user request like this: We can use Excel to query the database and get the information requested, but you will have to manually write the WHERE conditions that include
Dynamic SQL queries with Excel’s Power Query Read More »
When we connect to a folder to combine all the files, Power Query creates a “Query” called Sample File, which is used as example to process each file, the results will depend on the columns that exist in this file. But what happens when any of the files have missing columns? In the below example,
Combine Files With Slightly Different Columns Read More »
When we connect to a folder to combine all the files, Power Query creates a “Query” called “Sample File”, which is used as example to process each file, the results will depend on the columns that exist in this file. But what happens when any of the files have less columns than others? In the
Power Query Files from Folder: Read More »
Combining files with Power Query is great but what happens when some unformatted files have less columns?
Learn How to Combine Tables With Slightly Different Columns Read More »
