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?
Solved! Go to Solution.
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.
Flow in details:
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.
Then save Flow and can test it.
When a form is submitted as below:
New item will be created as below:
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.
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.
Flow in details:
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.
Then save Flow and can test it.
When a form is submitted as below:
New item will be created as below:
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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
28 | |
28 | |
26 | |
26 | |
23 |
User | Count |
---|---|
63 | |
51 | |
44 | |
32 | |
30 |