Mapping choice fields on a form to the SharePoint list using Power automate

(0) Share

Report

Posted on by KL-14040751-0

I have created an MS form and a corresponding MS list to capture the responses from the form when it is submitted. I have a number of choice fields in the form with a corresponding column in the list with the same values in the same order. They match.

I created an automated cloud flow and mapped all fields but the choice fields as it does not give me an option to map them using the lightning bolt. The lightning bolt does not appear. When I test and submit the form the list column say Required info and not the choice item I selected. How do I fix this please?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Vish WR 3,259 on at

Like (0)

Report
Copy link

Link copied!

@KL-14040751-0

The issue is happening because Forms sends choice answers as plain text, cue be due to the column type mismatch

If it’s a single-choice column, just pass the value directly from Forms. No formatting needed.

outputs('Get_response_details')?['body/YourQuestion']

If it’s a multi-choice column, Lists expects an array, but Forms sends a comma-separated string. So you need to convert it using:

split(outputs(‘Get_response_details’)?[‘body/YourQuestion’], ‘,’)

Also double-check that the option values in Forms and Lists match exactly.

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No
KL-14040751-0 2 on at

Like (0)

Report
Copy link

Link copied!

Thank you for this information. The fields were initially multiple choice answers but when I submittted the form all options went to the list option and not the one I selected. I change the fields on the form and list to single choice only, this is when I got the required information error message.

As I understand what you are saying, I need to add this bit of code to the code view split(outputs(‘Get_response_details’)?[‘body/YourQuestion’], ‘,’). Do I put this on the get response details or create item action in the flow and then where in the code

In the create item code view I can see this These are the fields I need to have the choices for. Or do I add in each option n the above code seperated by a comms?

Was this reply helpful? Yes No