Hi. Newbie here.
I would like to ask if it is possible to automate sending of an email to each vendor and attach in the body of the email respective reference and amount.
ID | Vendor | Reference | Amount | |
1 | john@flowtest.com | John | 1234 | 100 |
1 | john@flowtest.com | John | 1122 | 150 |
2 | james@flowtest.com | James | 5648 | 200 |
2 | james@flowtest.com | James | 5555 | 300 |
Example: On this table I must able to send John an email with following details in the body of the email
Vendor | Reference | Amount |
John | 1234 | 100 |
John | 1122 | 150 |
and also send an email to James with these details
Vendor | Reference | Amount |
James | 5648 | 200 |
James | 5555 | 300 |
Thank you so much.
Hi, ED
Thank you so much!
-Den
Hi there, here are a couple of articles that might help get you started:
Group a List for a Summary Using Power Automate
Group By and Sum in Power Automate / Flow
Good luck, and keep us posted!
-Ed
If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
WarrenBelz
146,660
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,999
Most Valuable Professional