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 »
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 »
One of the most read articles on our Power GI website is on Power Automate licensing structure. But a lot has changed since we first wrote it, so we decided to write a new blog with the most recent updates. If you’re here, most likely you have already come across Power Automate either Cloud or Desktop …
Power Automate licensing explained (Updated 2024) Read More »
If you have worked on a Power Platform project that needs connections to MySQL, then you might have noticed views are not listed when browsing the catalogue of a MySQL database. In this blog post we bring you a quick trick on how to successfully retrieve data from MySQL views from both Power Automate and …
Use MySQL views from Power Automate and Power Apps Read More »
A connection reference, a key component in a solution, contains vital information about credentials used to connect to a Power Platform connector. During the import of a managed solution into an environment, users face a choice: selecting an existing connection or creating a new one. It’s crucial to note that, once a managed solution is …
Update connection references in a Managed solution – Power Platform 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 …
What is Copilot? Microsoft 365 Copilot is an Artificial Intelligence assistant that can be used for Microsoft 365 apps and services, the Power Platform included! Creating a new Power Apps with Copilot Visit the Power Apps portal: make.powerapps.com. You will notice this section in the home screen. Just start typing a simple description of the …
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 »
