how to fetch the file from ADLS once we receive a email from client with that file name?

Question

Hi Everyone,
I have a task in which we receive a file name and pivot counts of some fields inside that file in form of excel through email from third party?
(NOTE- we are not receiving file data in email only filename and counts)

We have that file data already in our system in Azure storage. I need to create a flow in which everytime I receive a mail from them with file name my system automatically picks the same file(with data) from storage and go for transformations and in the end i want to compare the counts of data with the original file count sent by third party?

Thank you
devender

Answer 1

Hi @Devender ,

Thanks for reaching out to Q&A.

You can set the Office 365 mail trigger to start the flow, whenever a mail arrives to a shared mailbox, the flow will be kicked off. The body of the mail can be passed in any of the actions. So you can extract the filename from the mail body. I am assuming that the Azure storage is a file storage. You can use the get file content action and use XML transform step. Final validation can be done in a variable step using inbuilt math/count function.

Here is a sample flow:

Hope this helps! Feel free to reach out to me if you have any queries or concerns.