Table of Contents We were recently working on an automation that syncs on demand 2 different systems, end users use a button in a Power Apps app to execute this synchronization any time of the day, this automation takes around 15 minutes to run. It may happen that two users in two different departments request …
How to cancel a flow run if there is another execution running? Read More »
Either because we created too many rows when we were testing or because requests are no longer applicable, the approvals module in Power Automate can end up with plenty of requests that do not require action: In this blog we will show you how we can use Power Automate and Dataverse to cancel old requests. …
Cancel old approval requests sent from Power Automate | Dataverse approvals Read More »
A couple of weeks back, we posted this article on how to extract the content of a .eml file using Power Automate, but we recently discovered that there are some instances where the approach we explain in the previous blog will not work. The first approach we presented relies on the Power Automate Outlook trigger to …
How to recognize .eml files with Power Automate? | Hidden attachments Read More »
Power Automate has some cool out-of-the-box features to read data from Excel files. But if you want to read this data using these actions, the data needs to be formatted as an actual table in the file and not a flat range – but don’t you worry, Office Scripts got you covered! With Office scripts …
Quite recently we were working with the Accounts Payable team to automatically grab invoices received from suppliers and save them in a SharePoint site, we were using the regular “For each attachment”, “Attachment content” and then “Create file” actions in Power Automate for most vendors, until we found one vendor who did not attached their …
Get content of a file attached in an email’s .eml attachment (nested attachments) Read More »
Let’s suppose you are a legal company that receives hundreds of emails daily that relate to contracts for both Companies (legal entities) and Individuals. You need to separate those two different types of emails in different folders because they are processed differently. Your mailbox looks something like this: Your contacts always send you the name …
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 …
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 …
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 …
