cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
geraldclerc
Level: Powered On

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

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

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
 
geraldclerc
Level: Powered On

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

 

Community Support Team
Community Support Team

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

geraldclerc
Level: Powered On

Re: Forms to Sharepoint List

Hi Alice

 

That was the point 🙂

 

It's working now.

 

Thanks a lot.

 

Gerald

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 317 members 6,531 guests
Please welcome our newest community members: