cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Forms to Sharepoint List

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

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:

Capture.PNG 

The Text mode select as below:

Capture.PNG

 

 

Please let me know if your problem could be solved.

 

Best regards,

Alice

 

 

 

View solution in original post

4 REPLIES 4
Community Support
Community Support

Hi @geraldclerc,

 

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

 

I have created a form as below:

Capture.PNG

 

I have created a flow as below:

Capture.PNG

Capture.PNG

 

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:
Capture.PNG
 
 
Please let me know if your problem could be solved.
 
 
Best regards,
Alice
 

Hi Alice

 

Thanks for your response.

This is waht I did:

Bild 3.png

And this is the result:

Bild 4.png

 

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

 

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:

Capture.PNG 

The Text mode select as below:

Capture.PNG

 

 

Please let me know if your problem could be solved.

 

Best regards,

Alice

 

 

 

View solution in original post

Hi Alice

 

That was the point 🙂

 

It's working now.

 

Thanks a lot.

 

Gerald

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (5,432)