Read table/CSV/excel from Azure blob/table storage and send email in flow

(0) Share

Report

Posted on by Flint

Hi, my project flow is

1. read excel from sharepoint -> 2. send the data to Azure Functions written in python for processing -> 3. get the processed data back to flow -> 4. send customized email (email address is to be extracted from the processed data).

Now I have my Azure function (written in Python running) and I implement step 2 using Azure blob storage. See attached flow for example. Basically, in my Flow, it will create a blob (write the data to Azure blob) and send a http request to trigger my Azure Funtion which reads the Azure blob and do the processing there.

Now I am stuck on how should I load the data back to flow? Some connectors I tried:

- get file content from Azure Blob: I am able to get the file content. However, it is in binary format. How should I parse this binary format and select certain columns (e.g., emails column in my processed data)

- get worksheets from Azure Blob: it seems only to return the meta data.

Categories:

Business Process Flows

All responses (1)

Answers (0)

PrasadAthalye on at

Like (0)

Report

Re: Read table/CSV/excel from Azure blob/table storage and send email in flow

I would recommend to write another Azure function that accepts BLOB as parameter and returns required fields like email address. Then from Power Automate Flow, you can call this function and use the fields. This will be relatively simpler option than exploring ways to convert Blob to file and then read data from Power Automate.