Power Automate

Excel

Read Raw Excel Data (unformatted xlsx) using Power Automate | Excel File to SharePoint List

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 …

Read Raw Excel Data (unformatted xlsx) using Power Automate | Excel File to SharePoint List Read More »

Get content of a file attached in an email’s .eml attachment (nested attachments)

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 »

Create long-running approval requests in Power Automate (override 28-days timeout)

Sending approval requests is one of the most common use cases for which Power Automate is used for. After all, the out-of-the-box connector for approvals has a limitation: if the approval request is not approved or rejected within 28 days, the action will time out and this will cause your flow to fail. In this …

Create long-running approval requests in Power Automate (override 28-days timeout) Read More »

Classify your emails based on Subject using AI

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 …

Classify your emails based on Subject using AI Read More »

Power Automate Desktop: now available at no additional cost.

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 »

Power Automate Desktop

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 »