How to include multiple columns in Activator

[rabbisht]

Previously, the activator message supported composite keys, allowing multiple column values to be included. The current implementation targets only a single column. Is there still a way to include values from multiple columns in the activator message?

[tayloramy · Accepted solution]

Hi @rabbisht, 

As far as I know Activator currently only supports conditions on single columns. 

You can include additional columns in email/teams notifications as contex however. 

Activator tutorial using sample data - Microsoft Fabric | Microsoft Learn

[v-priyankata]

Hi @rabbisht 

Thank you for reaching out to the Microsoft Fabric Forum Community.

@kustortininja @tayloramy Thanks for the inputs.

I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.

[v-priyankata]

Hi @rabbisht 

Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.

[kustortininja · Accepted solution]

You can combine streams together to do this type of composite rule detection: Combine Multiple eventstreams in Activator Rule - Microsoft Fabric | Microsoft Learn

Alternatively, you can combine the composites in the source and evaluate the rule on the combined column

[tayloramy · Accepted solution]

Hi @rabbisht, 

As far as I know Activator currently only supports conditions on single columns. 

You can include additional columns in email/teams notifications as contex however. 

Activator tutorial using sample data - Microsoft Fabric | Microsoft Learn