Answered

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

(0) Share

Report

Posted on by KC-17100708-0

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:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Gopala_Krishna 1,495 on at

Like (1)

Report
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 (0)

Report

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

Was this reply helpful? Yes No