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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors