How do I send a custom email to each email in a column?

[canes2001]

So I have a table that looks like this:

Name	Email	Week 1	Week 2	Week 3
Bob B	bob@blah.com	Missed	Missed
Suzie Q	suzie@blah.com	Missed	Missed	Missed
Steve M	steve@blah.com	Missed
	etc

And I want to send an email to each person if a button within my report is clicked. That looks like this:

Hi [name],

You are currently delinquent on the following weeks:

Week 1	Week 2	Week 3
[insert value if not null]	[insert value if not null]	[insert value if not null]

I've tried Power Automate but this is like nothing else I've done before so I don't even know where to start or if Power Automate is the right tool for the job. Any idea how I can make this happen?

[jaideepnema · Accepted solution]

Hi @canes2001 ,
Here are the steps you can follow:

1. Create a New Power Automate Visual and Drag all the 5 columns in the data section for the same as shown below:
   
2. Now click on the Edit option by selecting the three dots on the top right of this visual
3. In the next step select instant cloud flow
   
4. Create a flow as shown below:
   You can toggle to the HTML Code View(highlighted in yellow) and enter the required HTML Code to create a table 
   
5. Publish this report and then you can click on run flow to get an email shown below:
   Hope that helps !!

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

Regards,

Jaideep Nema

Connect with me on LinkedIn: https://www.linkedin.com/in/jaideepnema/

[parry2k]

@canes2001 Power Automate is the way to achieve this, you can dynamically compose the email in the automate, and based on the click it will send the email. check this Export and email a report with Power Automate - Power BI | Microsoft Docs

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[canes2001]

I don't see anything in there on using a column to populate the "To:" field