Power Platform Community Forum Thread Details

Dear Experts,

I have a questionnaire that collect the response from users for example.

Good=3

Average=2

poor=1

Question	Impact	Risk	Ratings (Impact X Risk)
sample question 1	Good	Average	6
sample question 2	Poor	Average	2
sample question 3	Good	Good	9

How can i calculate Ratings? i want to update sharepoint list column with ratings.

Please help.

Categories:

General topics

Hi @rizwanmgm

we can try an easy approach for this 🙂

see the demo list which i have created

see the demo flow designed for this

I am desiging a instant cloud flow for demo

step 1- use get items to get all items in the rating list

Step 2- Create an object which map the rating type with their values like below

Step 3- use apply to each action to loop through items present in list

inside the loop use update item action

For Ratings field in Update item > use below expression that maps the Rating type from object variable and gets the value and do calculation (multplication)

mul(variables('Values')?[items('Apply_to_each')?['Impact']],variables('Values')?[items('Apply_to_each')?['Risk']])

After running the flow> see below result in sharepoint list

Hope it helps !

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Community site session details

Calculating coulmns

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the December Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates