cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kbostwick
New Member

MS Form to SharePoint using Automate

I am trying to get one of our MS Forms piped into SharePoint using Automate and I am having one heck of a time. I do have a few questions to start off with:

 

My question on the MS Form is a multiple choice, multiple answer question (check box)

My SharePoint List Column is setup as Choice and within settings I have provided the same choices that the form offers, and allowed checkboxes on the column. Is this correct in terms of setup? Or should this be a single line of text? I see conflicting answers on various guides I have tried to follow.

 

Either way, single line of text or choice, the only response that ever shows up (whether it is checked or not, is the first choice available). There is no default set on SharePoint.

 

MS Form:

Question: Please check all that apply

 

Choice 1

Choice 2 

Choice 3

Choice 4

 

 

SharePoint only ever displays ["Choice 1"] no matter the selection. Choice 1 can be unchecked and that is still what is displayed. What am I doing wrong?

 

Kbostwick_0-1643136180385.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-LilyW-msft
Community Support
Community Support

Hi @Kbostwick 

According to your description, You want to create the multiple-choice answers submitted in the Form into a column which type is multiple-choice in sharepoint list. If any misunderstanding, please kindly let me know.
I set up a simple Flow, you can refer to as below:
This is my list:

'Please check all that apply' column is a choice column and allow multiple selections.

vLilyWmsft_2-1643333844664.png

Flow in details:

vLilyWmsft_3-1643333943205.png

vLilyWmsft_4-1643333962174.png

vLilyWmsft_7-1643334049227.png

 

vLilyWmsft_6-1643334025579.png

Please note that change the details inputs for array item to input entire array, then fill in the output of the select action in the filed.

vLilyWmsft_8-1643334098804.png

vLilyWmsft_9-1643334126020.png

Then save Flow and can test it.

When a form is submitted as below:

vLilyWmsft_0-1643333782352.png

New item will be created as below:

vLilyWmsft_1-1643333804439.png

Hope the content above may help you.

Best Regards

If my answer helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-LilyW-msft
Community Support
Community Support

Hi @Kbostwick 

According to your description, You want to create the multiple-choice answers submitted in the Form into a column which type is multiple-choice in sharepoint list. If any misunderstanding, please kindly let me know.
I set up a simple Flow, you can refer to as below:
This is my list:

'Please check all that apply' column is a choice column and allow multiple selections.

vLilyWmsft_2-1643333844664.png

Flow in details:

vLilyWmsft_3-1643333943205.png

vLilyWmsft_4-1643333962174.png

vLilyWmsft_7-1643334049227.png

 

vLilyWmsft_6-1643334025579.png

Please note that change the details inputs for array item to input entire array, then fill in the output of the select action in the filed.

vLilyWmsft_8-1643334098804.png

vLilyWmsft_9-1643334126020.png

Then save Flow and can test it.

When a form is submitted as below:

vLilyWmsft_0-1643333782352.png

New item will be created as below:

vLilyWmsft_1-1643333804439.png

Hope the content above may help you.

Best Regards

If my answer helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (2,721)