cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Community Support
Community Support

Re: Forms to Sharepoint List

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
Highlighted
Community Support
Community Support

Re: Forms to Sharepoint List

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
 
Highlighted
Frequent Visitor

Re: Forms to Sharepoint List

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

 

Highlighted
Community Support
Community Support

Re: Forms to Sharepoint List

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

Highlighted
Frequent Visitor

Re: Forms to Sharepoint List

Hi Alice

 

That was the point 🙂

 

It's working now.

 

Thanks a lot.

 

Gerald

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (9,622)