Power Platform Archives

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

1 Comment / Automation, Email Attachment, Power Automate, Power Platform, SharePoint / By Graciela Martinez

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 »

Update column value based on Business process flow stage

Business process flow, Power Platform / By Graciela Martinez

Business Process flows (BPF) in Power Platform are an amazing tool to guide end-users on the stages they should follow to complete a process, but sometimes it may become difficult to track which records in Dataverse are in which stage of the process and see all these records in a single view, for example. To …

Update column value based on Business process flow stage Read More »

Use MySQL views from Power Automate and Power Apps

Leave a Comment / Automation, MySQL Views, Power Apps, Power Automate, Power Automate App Services, Power Automate Desktop App / By Graciela Martínez

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

Leave a Comment / Excel macro, Power Platform / By Graciela Martínez

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 »

Update connection references in a Managed solution – Power Platform

1 Comment / Automation, Power Apps, Power Automate, Power Query, SharePoint / By Graciela Martínez

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 »