Pattern based trigger that will enable group matches into single Alert

[ultimateabd87]

Hello,

Am trying to create a pattern based trigger, so that whenever trigger conditions are met, it should send group matches into a single alert email instead of sending single row individual to the recipient which overwhelm the recipient mailbox, after selecting action type as Email, i could not find any toogle button to turn. below is the screenshot. Can you provide help on this?

Thanks

[burakkaragoz · Accepted solution]

Hi @ultimateabd87 ,

I see what you mean, it can be really overwhelming for the mailbox if each matching row triggers a separate email. As far as I know, right now in Fabric’s alerting system, there isn’t a built-in way to group multiple matches into a single alert email for pattern-based triggers – at least not via the UI or a toggle as you mentioned in your screenshot.

What some folks do is use some kind of aggregation or batching logic before the alert action. For example, if you can set up your trigger query to summarize or batch the results, the alert will include only the grouped info. But if you want to collect several distinct matches and send them together, that’s a bit tricky without extra automation or using Logic Apps/Power Automate to catch and batch alerts before sending them as one email.

I’d recommend checking if your use case fits with a summary query, or looking into automating the email part with external tools if grouping is really needed.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

[v-lgarikapat · Accepted solution]

Hi @ultimateabd87 ,

Thanks for reaching out to the Microsoft fabric community forum.

@burakkaragoz , 

Thanks for your prompt response

@ultimateabd87 ,

In addition to @burakkaragoz , I’m adding learning documents here. They may help you, @ultimateabd87 , understand and resolve the issue.

Batch process messages as a group - Azure Logic Apps | Microsoft Learn

Scheduled analytics rules in Microsoft Sentinel | Microsoft Learn

Create Activator alerts from a Real-Time Dashboard - Microsoft Fabric | Microsoft Learn

Create Power BI alerts and refine them in Fabric Activator - Microsoft Fabric | Microsoft Learn

If this post helped resolve your issue, please consider the Accepted Solution. This not only acknowledges the support provided but also helps other community members find relevant solutions more easily.

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
LakshmiNarayana.

[v-lgarikapat]

Hi @ultimateabd87 ,

If this post helped resolve your issue, please consider the Accepted Solution. This not only acknowledges the support provided but also helps other community members find relevant solutions more easily.

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
LakshmiNarayana.

[v-lgarikapat]

Hi @ultimateabd87 ,

If your question has been answered, kindly mark the appropriate response as the Accepted Solution. This small step goes a long way in helping others with similar issues.

We appreciate your collaboration and support!

Best regards,
LakshmiNarayana

[v-lgarikapat]

Hi @ultimateabd87 ,

As we haven't heard back from you, we are closing this thread. If you are still experiencing the issue, please feel free to create a new thread we’ll be happy to assist you further.

Thank you for your patience and support.

If you found our response helpful, please mark it as Accepted Solution so others with similar queries can find it easily.

Best Regards,

Lakshmi Narayana

[burakkaragoz · Accepted solution]

Hi @ultimateabd87 ,

I see what you mean, it can be really overwhelming for the mailbox if each matching row triggers a separate email. As far as I know, right now in Fabric’s alerting system, there isn’t a built-in way to group multiple matches into a single alert email for pattern-based triggers – at least not via the UI or a toggle as you mentioned in your screenshot.

What some folks do is use some kind of aggregation or batching logic before the alert action. For example, if you can set up your trigger query to summarize or batch the results, the alert will include only the grouped info. But if you want to collect several distinct matches and send them together, that’s a bit tricky without extra automation or using Logic Apps/Power Automate to catch and batch alerts before sending them as one email.

I’d recommend checking if your use case fits with a summary query, or looking into automating the email part with external tools if grouping is really needed.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.