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 Platform Community / Forums / Power Automate / Converting MS Form Con...
Power Automate
Unanswered

Converting MS Form Content String to Integer

(0) ShareShare
ReportReport
Posted on by

I have a flow that feeds from a Microsoft Form and adds the user inputs into a Sharepoint List. The form has 14 questions, and for each question, the user can select the following: No Impact, Low Impact, Medium Impact, and High Impact). Example of the String in the List 

rherstad_0-1716241223667.png

I'd like to convert all of the responses to integer values 

 No Impact = 0

Low Impact = 20

Medium Impact = 60 

High Impact = 100 

 

 

 

I was thinking of using 14 Compose If statements for each of the columns, but I was unsure if there was an easier way to compose this? 

 

 

Categories:
I have the same question (0)
  • SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    You can achieve this with an expression inside the Create item action

    if(equals(Trigger Field, 'No Impact'), 0, if(equals(Trigger Field, 'Low Impact'), 20, if(equals(Trigger Field, 'Medium Impact'), 60, if(equals(Trigger Field, 'High Impact'), 100, 0))))

     

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
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard