Forms to Sharepoint List

[geraldclerc]

Hi there

Is there a way to store answers from Forms to Sharepoint List?

I have trouble storing an answer from a multiple selection to a SP textfield.

It stores ["value3","Value2"]. I would like value1, value2 in the SP text field.

Any help appreciated.

[v-yuazh-msft]

Hi @geraldclerc,

I have made a test on my side and I would offer you a workaround.

I have created a form as below:

I have created a flow as below:

Note:

1.Choose the "Question" dynamic content of the "Get response details" action in the "Content" field of "Parse JSON" action.

2.Enter the expression below in the "Schema" field of "Parse JSON" action.

{

"type": "array",

"items": {

"type": "string"

}

}

When a response is submited, the flow would run successfully as below:

Please let me know if your problem could be solved.

Best regards,

Alice

[geraldclerc]

Hi Alice

Thanks for your response.

This is waht I did:

And this is the result:

Still not working as expected. I have another view in the select action as the one you posted.

Or am I missing something there?

Thanks for your help

Gerald

[v-yuazh-msft · Accepted solution]

Hi @geraldclerc,

There is something wrong on your "Select" action.

Please click the "T" to Switch the key value mode select to Text mode select.

The key value mode select as below:

 

The Text mode select as below:

Please let me know if your problem could be solved.

Best regards,

Alice

[geraldclerc]

Hi Alice

That was the point 🙂

It's working now.

Thanks a lot.

Gerald