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 »
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 »
When we are using Power Automate Desktop to download files from the web, it’s a very common use case to want to upload them to a SharePoint site. There are two ways to achieve this, depending on if you have a Power Automate Premium account or if you don’t. Content Option 1. You have a …
How to upload files to SharePoint from Power Automate Desktop? Read More »
Date pickers can behave differently from page to page, and populating this control type from Power Automate Desktop can get tricky. Did you know most date pickers also have an text input control that is easier to use compared to year/month/day selectors? – We gathered 3 examples from different web pages and we show you how to automate them …
You have an MS Excel template that needs to be filled out every time a new record in SharePoint is created: this means when a new item is added in SharePoint, a copy of the template needs to be created and our automation has to insert rows into it. In our example, we have a …
Write to dynamic Excel files using Power Automate Read More »
Our use case: A word file needs to be generated everytime a new application is submitted – with some fields that come from the application form such applicant’s first name and last name. Someone reviews the request, performs manual updates to the file and sends it for approval. When the file is submitted for approval, …
Fill out dynamic MS Word templates with Power Automate Read More »
Table of Contents Sometime ago, we wrote about downloading PDF files from the web and overcoming Power Automate’s limitations when doing do. Since then, lots have happened and evolved within the tool, and several features have been added. The main change is that Power Automate used to have 2 recorders, one for web actions and …
Everything about downloading files from the web using Power Automate 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 …
