
Dear community,
Simply I would like to send email notification to sales rep from dataverse (Dynamics 365) to their customers that have not been visited for a while.
So, from dataverse I get list of customers with their related sales rep :
Customer 1 ; Sales rep 1
Customer 2 ; Sales rep 1
Customer 3 ; Sales rep 2
Customer 4 ; Sales rep 2
Customer 5 ; Sales rep 3
Of course I could send one email for each customer but the best would be to send ONE email for each sales rep with their customers.
I started building this flow using HTML table which looks great into an email :
Of course this won't work since now I have to find a way to "loop" into each sales rep, and send the email with their customers only.
I've spend a lot of time looking at others posts or blogs but those info I could find seems either very old (like 2018/19) with non existing funtion from Power Automate or very complex.
Any guess on how to proceed with this?
thanks a lot