Unanswered

Best way to get a choice with free text into a Sharepoint list from Forms

(0) Share

Report

Posted on by Flaredostrich

Hey

I have a form which gives for a few questions gives a choice field where one field is set and the second option is an "other" Field which the user can type. Using Power automate how do I get this into a Sharepoint list? I have tried setting the Sharepoint list field to a choice and matching the form settings to no success. I have also set the Sharepoint list to be a string and that still will not help. Any suggestions would be great

Categories:

Using flows

Screenshot 2024-0...

I have the same question (0)

All responses (7)

Answers (0)

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (1)

Report
Hi @Flaredostrich ,

Try the following:

In SharePoint:

Create a Choice column

Set the Choice value as "Fixed Option"

Select Allow 'Fill-in' choices

Check the Choice values:

Make sure that both the Microsoft Form choice value and the SharePoint choice value are exactly the same. If you don't do this, the Form submission will be treated as a Fill-In choice value.

In the Flow:

For the SharePoint Create Item action, select "Enter custom value" for the Fixed or User-Defined column value:

Then select the Forms dynamic content for this column

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
Flaredostrich 14 on at

Like (1)

Report

Hi

I think I had pretty much copied your settings already but I have not had any luck. My layout seems to be slightly different to yours

In Sharepoint my list column looks like this

My Form looks like this, The Fixed option text matches the fixed field from the Sharepoint column. I copied and pasted to make sure.
And finally my flow looks like this. I'm not sure why the names of the fields are changing to some sort of GUID but all the other fields seem to work fine.

This is the error the flow gives.

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Flaredostrich ,

It seems like the SharePoint list has been updated or changed but the flow is not aware of the changes.

Can you remove (i.e. clear) the value in the column highlighted below, then save and close the flow. The open the flow for editing again.

Then retest the flow.

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
Flaredostrich 14 on at

Like (0)

Report

Hi

I've tried the steps you suggested above. It looks like it's updated the field name but unfortunately the error still remains as above about input parameters

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Flaredostrich ,

Please also remove (i.e. clear) the value for the column item/Age highlighted below, then save and close the flow. The open the flow for editing again.

Then check this column and ensure that the forms response sent to this field is a date.

Please share more of the Create Item action if possible.

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
Flaredostrich 14 on at

Like (0)

Report

Hi

I have no filed that is called item/age. If I remove the input for this choice/user input field the error disappears and the flow runs as expected

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Flaredostrich ,

Please try the following: Switch to the Classic (old editor):

Then edit and save your flow using the classic editor. I've include extracts of my Form that may help workout what's causing the error. You should be able to follow along using your flow.

This is my Form. Question 7 is a choice field that allows users to enter a fill-in choice of their own:

This is my SharePoint choice column called "Fixed or User-Defined" that also allows users to fill-in their own values. Forms question 7 will be saved here:

Looking at the run-time output of the flow I can see that the Forms response contains a fill-in choice value of "ABC-Option":

This is the Create Item Action of the flow. Note that you can clearly see the names of the Forms column. The new editor (new designer) doesn't show this.

This is the runtime output of the Create Item action:

This is the SharePoint list where the forms responses are stored:

If this still does not help: For ease and speed of debugging I suggest creating a simple form with just one choice question. Write a flow to save the forms response to a SharePoint list. This method may be much quicker to figure out what's going wrong and how to fix your flow.

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No