Forum Discussion
Alert or email triggered by table value
I am affraid this is not possible.
There might be an workaround, but it's bit advanced:
1. You might create Power Automate flow, which queries the data and basically "replicate" the table you have above.
2. You set up a condition in your flow. Something like IF Albania >5, THEN xxx
3. You set up action, which would be notification.
I think the basic idea can be understood from the following video:
https://www.youtube.com/watch?v=WUSo5GLV6uk&t=1s&ab_channel=Curbal
Thanks for you response Migasuke . I'm surprised some sort of alert or notification can't be generated from a table value.
Alternativly - is it possible to highlight a linked slicer based on a change in cell value?
Thank you
Hi,
how should it work? I am not sure if I get it.
Hopefully the screenshot below explains it a little better. So as an example:
If the value in the AvgDespatch column is greater than 5, highlight the associated country in the slicer.
I am affraid this is not possible.
There might be an workaround, but it's bit advanced:
1. You might create Power Automate flow, which queries the data and basically "replicate" the table you have above.
2. You set up a condition in your flow. Something like IF Albania >5, THEN xxx
3. You set up action, which would be notification.
I think the basic idea can be understood from the following video:
https://www.youtube.com/watch?v=WUSo5GLV6uk&t=1s&ab_channel=Curbal