You’re offline. This is a read only version of the page.
Announcements
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.
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.
Share
Report
All responses (
Answers (
522
