Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
RYU209
Helper III
Helper III

Show more than one data element with Data Alerts (Data Activator)

I currently have a table that shows Material Name and available stock. I also have an alert that is emailed out anytime a Product reaches a certain stock threshold. Is there a way to include additional information such as an average stock usage or Material Description? Currently the email only shows the Material Name.

RYU209_0-1708525184384.png

I would ideally like it to show:

Trigger Time:
Material Name:
Material Description:
and other metrics

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Currently you can only add one more field to the email template.

 

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

View solution in original post

12 REPLIES 12
lbendlin
Super User
Super User

Currently you can only add one more field to the email template.

 

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

Thank you @lbendlin, how would I add the second field? 

OOOh, they changed it !!!!

 

lbendlin_0-1708610549335.pnglbendlin_1-1708610569708.png

 

@lbendlin My "Addition Information" drop down is greyed out and unselectable - any idea why that's the case?

RYU209_0-1708612554597.png

 

What did you specify under Properties?

lbendlin_0-1708612721353.png

 

I have nothing set under Properties. Is that required to add additional information fields? 

yes

Currently my alert is set on a table visual with two measures: Qty Available and Safety Stock Check. My alert is triggered anytime Safety Stock Check becomes a 1. How can I include Qty Available as one of the selections when I create a new property? I think I don't understand what Properties are for.

RYU209_0-1708613606287.png


RYU209_1-1708613655614.png

 

Only Material and Safety Stock Check are options for creating a new property. 

Yeah, that sucks.  You could create the property against Safety Stock Check quantity but your alert is already triggered by it being 1, so this adds no value.

 

What additional information were you planning to include?

Well I would like the alert to trigger only based off of Safety Stock Check, but I would like the email sent by the alert to show the Material and Available Qty and potentially other measures like Averages involving the available qty. 

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

So it's not possible then? Thank you for your help! 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.