Microsoft List : formula to calculate the number of X in a column, per user

Copper Contributor

Hi Community ☺

 

Thank you in advance for your help ! I'm a beginer with Microsoft List so I'm not even sure that my request/question is doable... 

 

So I have a List and in the column A, I have the user's name, in column B their ticket # and in column C I have a list of choices (yes, no, pending, etc.). 

 

Is it possible to get an email when the same user gets 10 yes in column C ? With Power Automate, I know how to get an email depending on a value in MS List. However, I don't know how to ensure that we receive an email only when the user X (in column A) reaches 10 value « yes »in column C. 

Thank you for your responses ☺

And sorry if my english is rusty, I'm francophone ;)

 

 

Kindly, 

Audrey

0 Replies