Unanswered

PowerAutomate group by user name when all items are updated to approve, calculate average send an email

(0) Share

Report

Posted on by Community Power Pla...

I have a SharePoint list where it is stored for users evaluations, a single user can have multiple evaluations. Initially all the evaluations are in pending stage. Evaluator have a powerapps form where they can take the evaluation and give the score for each evaluation once he submit the response it it will go to approve status. Now I need to trigger an email, Once all the evaluations are approved belongs to single user along with the average score.

First I need to group by user name

Second check if those items are in approve status

Then calculate the average score

Then send an email to user

How do I achieve this using power automate.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report
@Anonymous

I would approach your requirement as follows:

Use a When an item or file is modified trigger

Initialize a variable to store the accumulate scores

Immediately after the trigger, check to see (condition) it the status is approve

If the status is not approve, use a control terminate action (with success) to stop the Flow

Alternatively, you could use a trigger filter instead of the condition

Use a Get items action with a Filter query so that only items for that use are returned

Loop through the items returned

If any are not approved, exit the Flow with a control terminate action

Add the score to the variable

Divide the sum of the scores stored in the variable by he number of items returned

Use this expression to find the number of items returned by Get items:
length(outputs('Get_items')?['body/value'])

Send an email

Give this a try and let me know if you need additional help.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@ScottShearer Thanks for the inputs. It worked but with slight changes I believe.
It took very long time for me to figure out how to terminate loop if any of the status is pending but any way
Thanks for your support!

Was this reply helpful? Yes No