Dynamic threshold value for alerts for different users

[KaranBatra]

Hi,
I'm trying to create an alert for a visual. Initially if I click on 'Manage alerts' on the visual, it gives me an option to enter a static threshold value. What I want is I've multiple users and I want the threshold value to be dynamic for each specific user. For instance, 

Users            Threshold Value

Person A                  60

Person B                  70

Person C                  65

Person D                  90

Is this possible to do with Power Automate ?

[KvB1 · Accepted solution]

You could grab the user email from the trigger.

If you keep a list of each person and their respective Threshold Value, you can use a filter query to grab the Threshold Value from the list using the automate user email. Iterate through all the returns in a for all, and store the Threshold Value in a variable.