Graciela Martínez

Cancel old approval requests sent from Power Automate | Dataverse approvals

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 »

.eml files with Power Automate

How to recognize .eml files with Power Automate? | Hidden attachments

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 »

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 »

Query Filter

Ultimate guide to OData query filters for SharePoint in Power Automate

When working with Power Automate and SharePoint lists we usually are in need of extracting specific rows of data from lists, to do so, we need to use the “Query filter” field available in the SharePoint “Get Items” action. OData queries are usually written in the following format:  {InternalColumnName} operator {value}  For example, if we …

Ultimate guide to OData query filters for SharePoint in Power Automate Read More »

Use Dataflows to bring your Dynamics Finance & Operations data entities to Dataverse.

Table of Contents Dataflows are an amazing tool to bring data from external systems into your Dataverse environment, and today we will show you how you can use them to bring data from your data entities in Dynamics F&O and push it to a Dataverse table. You can also read this post in our Linkedin page. …

Use Dataflows to bring your Dynamics Finance & Operations data entities to Dataverse. Read More »

Power Automate licensing explained (Updated 2024)

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 »

Use MySQL views from Power Automate and Power Apps

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 »

Excel VBA macro to split sheet contents into multiple files

We usually talk about Power Platform here, but this time we bring you some awesome VBA piece of code that you use to split the content of an Excel worksheet into multiple files, based on N number of rows – created by our colleague Jeymi Membreño. Say goodbye to manual splitting and hello to automation …

Excel VBA macro to split sheet contents into multiple files Read More »