Forum Discussion
Automated E-Mail triggered by certain value in Column / different Receivers
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 ! 😃
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
5 Replies
- goncalogeraldes
Super User
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- goncalogeraldes
Hello Daniel, Im happy I could help you!
Best regards,
Gonçalo Geraldes