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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (5,317)