Hello!
I'm a novice with power automate and was tasked with creating a daily routine of e-mails to suppliers with the payments they've recieved.
My first attempt was importing the dataset with the information about the payments to power BI, filter by each supplier name and a formula to acquire the current date, create a hmtl table and send the e-mail with the adresses i was provided.
This however is less than optimal, since i have dozens of flows, each doing the same thing but for a different supplier, making any changes a tiresome task.
I would like to know if theres a way I can create a single flow that filter the table for each supplier, then send a e-mail for each one with the table filtered by it's name and the date( pay date) that i want.
I have:
- A table with all the suppliers and all the payments during the year i.e.:
| Document Nr | Supplier | Due date | Due Pay | Pay date | Effective pay |
| 3847QO4 | A | 30/10/2023 | 2.850 | 27/10/2023 | 2.850 |
| 3847QO5 | A | 30/10/2023 | 2.850 | 27/10/2023 | 2.850 |
| 3847QO6 | A | 30/10/2023 | 2.850 | 28/10/2023 | 2.850 |
| 3847QO7 | A | 30/10/2023 | 2.850 | 28/10/2023 | 2.850 |
| 3847QO8 | B | 30/10/2023 | 34.511 | 27/10/2023 | 34.511 |
| 3847QO9 | B | 31/10/2023 | 3.444 | 27/10/2023 | 3.444 |
| 3847QO10 | B | 30/11/2023 | 3.444 | 27/11/2023 | 3.444 |
| 3847QO11 | B | 30/11/2023 | 3.444 | 27/11/2023 | 3.444 |
| 3847QO12 | C | 30/10/2023 | 780 | 30/10/2023 | 780 |
- A table with the specific suppliers, their e-mail adress( some have more than one e-mail)
Is there a way to do this?
Thanks in advance, the information in this forum has helped me many times.
