web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

Calculating coulmns

(0) ShareShare
ReportReport
Posted on by

Dear Experts,

 

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

Good=3

Average=2

poor=1

QuestionImpactRiskRatings (Impact X Risk)
sample question 1GoodAverage6
sample question 2PoorAverage2
sample question 3GoodGood9

 

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

 

Please help.

Categories:
I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    Hi @rizwanmgm 

     

    we can try an easy approach for this 🙂

     

    see the demo list which i have created

    Nived_Nambiar_0-1711273888557.png

     

    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

    Nived_Nambiar_2-1711273964558.png

     

     

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

    Nived_Nambiar_3-1711274001546.png

     

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

    Nived_Nambiar_4-1711274049295.png

     

    inside the loop use update item action

    Nived_Nambiar_5-1711274090334.png

     

    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)

    Nived_Nambiar_6-1711274146963.png

    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
    Nived_Nambiar_7-1711274200545.png

     

     

    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! 🙌

     
     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 58

#2
David_MA Profile Picture

David_MA 53 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 36 Most Valuable Professional

Last 30 days Overall leaderboard