You’re offline. This is a read only version of the page.
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:
| 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 |
Is there a way to do this?
Thanks in advance, the information in this forum has helped me many times.
Sorry mr. Sudeep.
It seems the problem was at my end. My original table is quite large (over 200000 rows) and some of the values I was filtering only start showing at the middle/end of the table thus not appering at all in my flow, my challenge now will be reducing the number of rows by filtering during the list rows action (maybe by date) but that's going to be another topic, I suppose.
Thank you for your solution
Please post a screenshot of your Filter action
Hi @SudeepGhatakNZ although your solution does allow me send multiple e-mails to multiple users, the filter action can't capture the main table, returning a blank table in the process. I'm also struggling to add a date filter in the process, as simply chossing the "Pay Date" collumn and writing a date doesn't seem to work.
#1
Pstork1
20
Most Valuable Professional
#2
Gprior
19
#3
stampcoin
16
Share
Report
All responses (
Answers (
