I need to send a weekly reminder for my salesperson that they have X leads open.
Now, I've created a flow in powerAutomate that:
1. Gets all the open leads
2. For every Lead open, I retrieve the owner
3. From the owner I get the primary email from the users table.
4. Then I want to send a personal email (/Hello John, you have 5 leads open. Please qualify them ASAP./)
The main problem is that I can't figure out how to send just ONE email to every Owner with this information. Right now is sending the same email to everyone who has open leads.
I've tried every solution I could find online but nothing seems to work...