Forum Discussion
Post ProdigySent dynamic email alert if condition met in Power Bi
I have a report with atable visual similar to the one below. Information will only appear on this table is column 'condition' outputs '1'
I would like a solution , probably with power automate that sends the email recipiant (Field 'Email') an email or Teams notification if a row appears on the table with there email adress.
| UPRN | Address | Post Code | Job # | Repair Description | Repair Status | Appt Date | Appt Slot | Operative Name | Name | Condition | |
| 232 | 7 DAX WAY | HPX 44U | 9213729 | *Toilet repair/replace* | Job Scheduled | 06/03/2024 00:00 | AM (08:00-12:00) | Alberto Ferrari | [email protected] | Richard C | 1 |
| 232 | 7 DAX WAY | HPX 44U | 9213703 | Routine Scope - Internal Works | Job Scheduled | 12/04/2024 00:00 | AM (08:00-12:00) | Adam Sax | [email protected] | Richard C | 1 |
| 232 | 7 DAX WAY | HPX 44U | 9213745 | Routine Scope - Internal Works | Job Scheduled | 12/04/2024 00:00 | AM (08:00-12:00) | Adam Sax | [email protected] | Richard C | 1 |
| 445 | 100 MCODE STREET | CL4 64K | 7653465 | Repair Lift | Job Scheduled | 22/04/2024 00:00 | PM (12:00-17:00) | Greg Deckler | [email protected] | Barry P | 1 |
thank you
Richard
4 Replies
- lbendlin
Super User
Create a dashboard and set an alert on one of the tiles. Ideally to be derived from a KPI or card visual.
Look into Data Activator reflexes if you are on Fabric
Or - if you know when your semantic model refreshes, trigger a Power Automate flow that checks the condition and sends the email as needed.
cottreraHi Ibendlin, thank you for yor response. I was also think a similar appoach . However I am not clear on how I send the table via power automate and only sent the rows of the table that relate to the email recipient.
Regards RIchard- lbendlin
If the email address is part of the DAX query payload then you can use that in Power Automate to send each row to their intended recipient.
