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
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
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
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
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.
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,