Unanswered

Convert multiple text fields to number value with conditional nested if in Power Automate before inserting item in SharePoint list

(0) Share

Report

Posted on by janathan

I have a form that gets responses as text - always, mostly, etc. I want to leverage Power Automate expression to check and change the value to a number - Always = 5, mostly = 4 etc. before creating item in a SharePoint list

Categories:

General topics

All responses (3)

Answers (0)

Sort by

eric-cheng 5,171 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @janathan ,

Pass the field into a switch statement and set a variable to 1,2,3 etc.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn
janathan 11 on at

Like
a
(0)

Report
Copy link

Link copied!

I have 25 fields that this needs to happen. 25 questions in the form that get answers in text like always, mostly, etc and in power automate it needs to change to numbers where always = 5, mostly = 4 etc. I was hoping to use an expression in power automate to say if (field = "always", 5, if field = "mostly", 4 etc but not able to figure out the syntax. your idea is good but it will make the flow so long.

Thanks
janathan 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Also, here is how my flow looks.