Building dynamic power automate flow

(0) Share

Report

Posted on by SKLahiri

Hello,

I would appreciate it if anyone could advise me on my existing flow. Let me describe what my current flow does:

It's a manually triggered flow
It calculates the sum of unpaid invoices and the information in onedrive.
Once the calculation is done, it sends the email to the vendor listed in another Excel document.
Right now it is calculating one vendor and sending emails to only that vendor's email address. For the next vendor, I need to get another unpaid invoice details and update the email list.

What I want to do further

The flow will dynamically get another file from onedrive, calculate the sum and send email to those email addresses listed in the existing Excel file (which has all the email addresses of all the vendors).
For example, Vendor ABC has a sum of unpaid invoices of $100 due. Then an email will send out to abc@abc.com then the flow will loop back to update the sum of CBA which has unpaid invoices of $200 due and send the email to cba@cba.com

I hope I demonstrated what I have achieved so far and what I need to do. Any help/advice would be highly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Can you provide a screenshot of the existing flow?

Was this reply helpful? Yes No
SKLahiri 8 on at

Like (0)

Report

Here is my current workflow,

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Please break that screenshot up into multiple pieces. The resolution is so low its unreadable.

Was this reply helpful? Yes No
SKLahiri 8 on at

Like (0)

Report

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

The problem will be that the Excel connector you are using to get the rows points to a specific file. What you need to do is create a new Excel file that is the list of filenames for the individual Excel files that you want to sum and send out emails about. Then basically after the trigger you read that file and create a loop that loops through all the rest of your flow for each file. Try putting the name of each file inside a EncodeURIComponent() property. If that doesn't work you may have to put all the files in a folder and do a list files in a folder to get the files to loop through.

Was this reply helpful? Yes No
SKLahiri 8 on at

Like (0)

Report

I am not sure if I am doing it right or not to create a loop that will dynamically get the file from one drive. Please advise.

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Are the invoices being summed up all in one Excel Table? Or is each client in a different xlsx file?

Was this reply helpful? Yes No
SKLahiri 8 on at

Like (0)

Report

Each client has a different xlsx file which must be updated every time when an email is sent to that specific client.

Was this reply helpful? Yes No