Triggering Alert when Data is added

[amarcucio]

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.  I can't seem to find an easy way based on a new record.

Using Data Activator I can sort of make this work with a calculated column subtracting the date added to today's date and triggering the alert to send on anything less than 1 (triggering at least once in 24 hours.), but it tends to trigger 2 days in a row, which I have not figured how to reduce it to 1 day.

Any thoughts on this?  Thanks in advance.

[amarcucio · Accepted solution]

@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.

[christinepayton]

What is your data source? It's usually better to build the notifications onto the source rather than on the reporting end, they usually have a literal trigger for "row added" that you can use instead of checking the latest date on a schedule.

If you want to stick with what you're currently doing, I would try adding hours to the datetime you're using for today's date to convert it to your timezone (and make sure your source timezone matches whatever you're using). What normally happens with these things is they default to UTC, so they will overlap what you think of as "days" if you're far from UTC zone - might be what's causing it to trigger twice. 

[SaiTejaTalasila]

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 

[foodd]

Hello @amarcucio , and thank you for starting a conversation in the Power Bi Community Forum.
 
I'm chiming in with another option if available.    Why not leverage the Service Desk Ticketing Platform workflow notifications for these activities and send appropriate notifications along the workflow chain?   It seems to me to cover the activity lifecycle from Approval triggers through Task Completion notifications.  This would not take away the desire or benefit of the logic addition you are interested in. However, it would seem to harmonize several business groups' network and directory activity.