Automated E-Mail triggered by certain value in Column / different Receivers

[Anonymous]

Hello People! 

Hope you are all doing great.

My current problem in shortversion is this:
Table 1:
Column1(Name);   Column2(Contact-E-Mail);   Column3(Additional-Info);   Column4(Additional-Info2);   Column4(CalendarCurrentDayOffset)

Since Column4(CalendarCurrentDayOffset) is counting backwards i want this as a trigger so if it hits 14 i want an automatically sent E-Mail to the receiver in Column2(Contact-E-Mail) with the daily refresh.

The Mail should have standard text filled with the info of Columns 1, 3 and 4.

(Words words words (Name) words (Additional-Info)....you get the point i think.

I tried to use the dashboard alert but i am quite confused how to set it up since i cannot make 1 card for 3000+ Datasets counting backwards.

I also tried to find something in the flows but i am quite confused how to archieve this with the powerbi combination.

Is there a good and easy solution to this?

Thank you in advance and have a nice day ! 😃

[goncalogeraldes · Accepted solution]

Hello there @Anonymous ! You can achieve this with Power Automate. You can either set it to trigger automatically or through a button on your report. Check the following links for help on flows in Power BI:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-flow-integration

https://flow.microsoft.com/en-us/blog/trigger-flows-from-power-bi-reports/

If you need additional help try posting your questions in the Power Automate Community.

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes

[Anonymous]

Hi Goncalo!

Yes this is it!

I just needed to download the new version for it to work due to company policy. I thought it is not allowed 🙂

I got a working version already and just looking for it to be automated not by a daily push at the button !
Thank you very much 😃

[goncalogeraldes]

Hello Daniel, Im happy I could help you!

Best regards,

Gonçalo Geraldes

[Anonymous]

Hey Goncalo,

i am quite confused right now.

If i use the data driven alert i cannot, in the following step to send a mail, add my values from my table.

What am i missing?
I do not want to click a button, with the button method i can add the information of my tables tho.... 

[goncalogeraldes]

@Anonymous Are you using this data-driven alert inside a for each loop? If yes, you can't send an email inside a for each because it will create a spam. You have to use the Select action and insert the data you want to send via email and afterwards you use the Create HTML table and insert it into the output email. The following print may provide some insight into what you need. Sorry for it being in portuguese!

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes