Power Automate – Dustin Miner

Extract CSV data in Power Automate

Dustin Miner
posted on April 19, 2021October 17, 2021
Comments Off on Extract CSV data in Power Automate

This post describes how to read a CSV file from Azure storage and parse it into an array using Power Automate. Azure File Share Consider a CSV file that has been FTP’d to an Azure file share

Posted in Dynamics 365 CE, JavaScript, Power Automate

Handling time zone in Power Automate

Dustin Miner
posted on March 20, 2021October 6, 2021
Comments Off on Handling time zone in Power Automate

The example described in this post shows how a date field selected in Dynamics 365 (where the timezone is GMT+11hrs) can be incorrectly displayed in Power Automate. Specifically, a date of 15/03/2021

Posted in Power Automate

Extracting QR Code data in Power Automate

Dustin Miner
posted on March 13, 2021October 6, 2021
Comments Off on Extracting QR Code data in Power Automate

Consider a PDF with a cover page which contains the following QR code (containing the data “123456789, John Smith”). This pdf triggers a Power Automate flow. The Power Automate steps

Posted in Power Automate

Implementing an OCR process in Power Automate

Dustin Miner
posted on February 15, 2021April 27, 2022
Comments Off on Implementing an OCR process in Power Automate

Consider a scenario where a customer document (containing a cover page) has been scanned into a PDF and emailed to a company for processing. When the email is received, the cover page in the PDF is

Posted in Power Automate

Retrieving a query parameter in Power Automate

Dustin Miner
posted on December 23, 2020March 15, 2022
Comments Off on Retrieving a query parameter in Power Automate

This simple post describes how a Power Automate flow, being triggered by a HTTP request, can extract a query parameter. Firstly, the Power Automate flow is configured to extract a query parameter.

Posted in Dynamics 365 CE, Power Automate

Setting a lookup field in Power Automate

Dustin Miner
posted on December 11, 2020April 25, 2022
Comments Off on Setting a lookup field in Power Automate

In this post, a Transaction Log record will be assigned to a Receipt record’s Transaction Log lookup field. Note: the scope of the post is for the CDS (current environment) connector. Firstly,