One notification for multiple records

[Dominik9]

Hi experts

We have a table in which a record is assigned to a user when it is created. The records are created automatically. When a new record is created, the user who is assigned to the record should be notified. This can be easily done with a flow.

Problem: It is possible that several records are created at the same time with the same assigned user. In such a case, the user should still only receive one notification and not for each record. How do I achieve this? Does anyone have a suggestion?

Thanks

Dominik

[Gunjan Kiratkar]

Hi @Dominik9 ,

Notification works only when event is fired or record is inserted/updated.

So in your case if you want to send only one notification then create one scheduled job which can run 2 or 3 times a day and fire event from there for that assigned to user. 

[Dominik9]

Hi Gunjan

Thanks for your response. Thats what I did. I just thought there is a way to do that easily in a flow. 

Regards

Dominik

[Dominik9 · Accepted solution]

I found a solution to do it in a flow. I created an action which does the GlideAggregate group by and returns the sysIDs array of the grouped by as a string. In the flow I make a GlideRecord where I query the table where sysID is one of the group by sysIDs and then notify those users.