Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 | Richard.C@housing.co.uk | 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 | Richard.C@housing.co.uk | 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 | Richard.C@housing.co.uk | 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 | Barry.P@housing.co.uk | Barry P | 1 |
thank you
Richard
Hi 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
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.
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.
Thanks, can you please explain step by step process, it will be helpfull for everyone