web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Get/Update item from M...

Power Automate

Answered

Get/Update item from Ms Form into SharePoint List based on YesNo

(0) Share

Report

Report

Posted on by KC-17100708-0

4

Hi, I am currently creating a flow to get input from Ms Form into SharePoint list.

There are special questions in Ms Form, whereby once users select 'Yes' for first question (let call it 'A'), then next question (call it 'B') will appear to ask for values. These 'AB' type of questions have 10 sets of them.

I managed to create the flow to keep all inputs using 'Create Item', and keep condition values ('B') based on ('A') using 'Update item'. (as attached). However, it would be too repetitive if I make 10 condition steps.

May I know if anyone have same experience and ways to enhance it?

Any help is much appreciated. Thank you.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Gopala_Krishna 1,495 on at

Like
a
(1)

Report
Copy link

Link copied!
Instead of using Update item each time, you can use expressions in Power Automate to create if condition statement and update the columns in the create item action itself instead of putting a condition and doing it in update item.
if(equals(<<Insert value to evaluate by selecting from dynamic content>>,'Yes'),<<Select output to update if the condition is true>>,<<Select output to update if the condition is false>>)

Condition would look similar to the above shared code, you can use the expression and replace the values as indicated.

To insert expressions in Power Automate action hit slash "/" on the column where you want to enter the expression and select insert expression.

For more information on the Power Automate expressions kindly check the video

Was this reply helpful? Yes No
KC-17100708-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried the formula suggested by Gopala_Krishna. It works! Thanks a lot.

Was this reply helpful? Yes No

Join the conversation