
Announcements
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.
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)
Hope it helps !
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! 🙌