Unanswered

Mapping MS Form choice field to Sharepoint list choice field

(0) Share

Report

Posted on by AnnetteM

I have an MS form that has a choice question where there is only one answer. I have a SharePoint list where the choice column can have only one answer. BUT, the options in the FORM are different than the options in the SharePoint list.

How can I get the option selected in the FORM and map/translate to a different name to use when creating the item in the list?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@AnnetteM You can use a Variable and a Switch action. Insert the form selection into the On field of the Switch action.

Ensure that the text you enter into the Equals field matches the Form selection exactly.

Then, set the variable to match your SP choices.
Hope this helps!
If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No
Verified answer

Caspar_Rubin 831 on at

Like (0)

Report

Hey

I hope I understood correctly... you could do it using a variable and a "switch" action.

Initialize a new variable called "SharePointValue" and set it to String. Leave the value empty for now.

Add a "Switch" action and as the "On" value you select your Forms Value from the Choice Field from the "Get response details" action.

Inside the switch, write the Form value in the "Equals" field and below it add a "Set variable" action. In that "Set variable" action you simple select the variable you created at the start (SharePointValue), and set its Value to the SharePoint Choice you want to add to SharePoint, if that Form Value has been selected. You can add multiple Switch "Cases" if you have multiple values you want to cross-reference.

Then in your "Create item" action, simply select the variable (SharePointValue) you filled in the Switch action. It's going to hold the value you want, not the one that's coming from the Form.

In my example, the Form has a choice value of "FormValueXYZ" and if the user selects that, in SharePoint the value would then be "SharePointValueABC".

Cheers

Was this reply helpful? Yes No
AnnetteM on at

Like (0)

Report

I was thinking of a switch but thought I could do it with an if/then statement. When I base the switch upon the Forms field, I have to enter the text as ["ABC"] as that is what is returned by the form response. Is there a way to strip the [ and " from the value or is it just as much work to do that, than to make the On value match?

Was this reply helpful? Yes No
Caspar_Rubin 831 on at

Like (0)

Report
Hey,

if you want to do it light-weight, you can of course skip all the switch and variable stuff and go with an expression. It's not that scalable but if you only every have 1 value to change, why not...

For example, the following would turn ABC value (coming from forms) into XYZ in SharePoint and would return nothing if nothing or something else than ABC comes from the Form...

if(equals(outputs('Get_response_details')?['body/YOURQUESTION'], 'ABC'), 'XYZ', null)

Cheers

Was this reply helpful? Yes No
AnnetteM on at

Like (0)

Report

Thanks for the reply. You are right. The switch statement is more scalable and easier for someone to follow! Since the value coming from the form response was encased in [ and " I created a compose action that stripped that out and just gave me text. Then I was able to use that text in the EQUALS part of the switch case and it worked beautifully. Thank you!!!

Was this reply helpful? Yes No