cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jeanxyz
Super User
Super User

send out email notification to a particular person based on row values

Hi, 

I have a timesheet report showing timesheet completion% by person. I would like to send out email notification on a monthly basis to the person when his/hertimesheet completion rate is <100%. 

 

I understand I need to create a Power Automate flow to read the table below line by line and send out email notification to the particular person. Has anyone done this before?

 

send out email from power bi.png 

1 ACCEPTED SOLUTION
lukaszEltwin1
Helper V
Helper V

If its a monthly basis i would create flow under buttom trigger and create condition. my example below 

 

lukaszEltwin1_0-1667821974279.png

 

Try video with Patrick

 

https://www.youtube.com/watch?v=T0dsCUeCFjg

View solution in original post

3 REPLIES 3
lukaszEltwin1
Helper V
Helper V

If its a monthly basis i would create flow under buttom trigger and create condition. my example below 

 

lukaszEltwin1_0-1667821974279.png

 

Try video with Patrick

 

https://www.youtube.com/watch?v=T0dsCUeCFjg

Thanks for sharing the video. This is exactly what I looked for. 

 

SwayamSinha
Microsoft
Microsoft

This is not straightforward (and I have not tried this myself) , but I believe thsi should be possible by extracting the data (in the snapshot) into .csv then parse the csv to get row elements ( emailid in this case )and iterate through them to trigger a send email action. all through Power Automate. 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors