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

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the February Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates