Forum Discussion

amarcucio's avatar
amarcucio
Frequent Visitor
2 years ago
Solved

Triggering Alert when Data is added

Hi all,   I am trying to set of an automated email notification when a new row is added to a dataset.  For example, a new office is added and an email is sent to the team that handles that location...
Need Help
  • amarcucio's avatar
    amarcucio
    2 years ago

    foodd Thank you for this.  While this is not an available option yet, hopefully soon the data will be synced with our ticketing system.  This may be the route I end up going.

    SaiTejaTalasila  Thank you, I will explore this.

    christinepayton I actually started at the source and the workflow to set this up is not easy to set up.  We got about 1/2 way there, but due to an unforseen circumastance, we had to pivot to get notifications up quicker.

    I was thinking the UTC conversion may be the issue.  I made an adjustment to the timing of refreshes and such and this may have fixed it to give us a workable solution, even if it is temporary.

     

    Thanks all for the responses.

SaiTejaTalasila's avatar
SaiTejaTalasila
Super User
2 years ago

Hi amarcucio ,

 

You can use power automate.In your report create a table and apply filters to show new facilities name and corresponding email id .Use performance analyser and capture dax query for that table.On.power automate use when a dataset refresh is completed,if successful use run a query against a dataset and pull that table using the copied dax.Use parse json to pull columns out and you can use for each loop and send email to individual facilities.

 

I hope it will be helpful.

 

Thanks,

Sai Teja