SOLVED

Single form to multiple lists in sharepoint

%3CLINGO-SUB%20id%3D%22lingo-sub-357573%22%20slang%3D%22en-US%22%3ESingle%20form%20to%20multiple%20lists%20in%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357573%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20several%20Sharepoints%20lists%20to%20be%20filled%20in%20from%20one%20form%2C%20depending%20on%20the%20answer%20in%20a%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20recently%20used%20Microsoft%20Forms%20for%20the%20first%20time.%20It%20is%20a%20fairly%20extensive%20questionnaire%20with%2090%20questions.%20At%20the%20beginning%20of%20the%20questionnaire%20there%20is%20a%20list%20of%20choices%20to%20which%20the%20other%20questions%20depend.%20The%20choice%20made%20there%20ensures%20that%20many%20questions%20are%20skipped%20and%20only%20the%20relevant%20questions%20for%20that%20choice%20can%20be%20filled%20in.%20There%20are%2C%20on%20average%2C%2010%20questions%20per%20choice%2C%20so%20it%20skip%20around%2080%20questions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CP%3E-Question%201%20(list%20of%20choices)%3C%2FP%3E%3CUL%3E%3CLI%3E-%20Option%201%3C%2FLI%3E%3CLI%3E%3CSTRONG%3E%3CU%3E-%20Option%202%3C%2FU%3E%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3E-%20Option%203%3C%2FLI%3E%3CLI%3E-%20etc.%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSTRIKE%3E%3CFONT%20face%3D%22Calibri%22%3E-Question%202%3C%2FFONT%3E%3C%2FSTRIKE%3E%3C%2FP%3E%3CP%3E%3CSTRIKE%3E%3CFONT%20face%3D%22Calibri%22%3E-Question%203%3C%2FFONT%3E%3C%2FSTRIKE%3E%3C%2FP%3E%3CP%3E-Question%204%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-Question%201%20(list%20of%20choices)%3C%2FP%3E%3CUL%3E%3CLI%3E%3CSTRONG%3E%3CU%3E-%20Option%201%3C%2FU%3E%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3E-%20Option%202%3C%2FLI%3E%3CLI%3E-%20Option%203%3C%2FLI%3E%3C%2FUL%3E%3CP%3E-Question%202%3C%2FP%3E%3CP%3E-Question%203%3C%2FP%3E%3CP%3E%3CSTRIKE%3E%3CFONT%20face%3D%22Calibri%22%3E-Question%204%3C%2FFONT%3E%3C%2FSTRIKE%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20I%20have%20the%20problem%20that%20when%20I%20send%20the%20results%20with%20a%20flow%20to%20a%20SharePoint%20list%2C%20I%20get%20a%20unclear%20list%20with%20all%20results%20with%20a%20lot%20of%20white%20fields%20since%20these%20questions%20have%20been%20skipped%20when%20filling%20in.%3C%2FP%3E%3CP%3EMy%20wish%20is%20that%20several%20Sharepoint%20lists%20are%20filled%20in%20using%20microsoft%20flow%2C%20depending%20on%20the%20choice%20made%20in%20the%20first%20question.%3C%2FP%3E%3CP%3ESo%20separate%20Sharepoint%20lists%20of%20option%201%2C%20option%202%2C%20option%203%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-357573%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-360040%22%20slang%3D%22en-US%22%3ERe%3A%20Single%20form%20to%20multiple%20lists%20in%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360040%22%20slang%3D%22en-US%22%3E%3CP%3EGreat%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F292135%22%20target%3D%22_blank%22%3E%40Jeldro%3C%2FA%3E%20-%20I'm%20happy%20to%20hear%20it!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESandy%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359628%22%20slang%3D%22en-US%22%3ERe%3A%20Single%20form%20to%20multiple%20lists%20in%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359628%22%20slang%3D%22en-US%22%3EIt%20works%20perfect%2C%20thanks%20a%20lot.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-358114%22%20slang%3D%22en-US%22%3ERe%3A%20Single%20form%20to%20multiple%20lists%20in%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358114%22%20slang%3D%22en-US%22%3E%3CBR%20%2F%3EThanks%20for%20the%20tip%2C%20I%20am%20not%20familiar%20with%20this%2C%20but%20after%20a%20quick%20research%20I%20think%20this%20can%20help%20me.%3CBR%20%2F%3EI%20will%20take%20a%20try%20and%20let%20you%20know%20if%20it%20succeeded.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-358030%22%20slang%3D%22en-US%22%3ERe%3A%20Single%20form%20to%20multiple%20lists%20in%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358030%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F292135%22%20target%3D%22_blank%22%3E%40Jeldro%3C%2FA%3E%20%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20try%20using%20a%20Switch%20Case%20for%20this.%20That%20is%2C%20after%20getting%20the%20Forms%20responses%20in%20Flow%2C%20use%20the%20value%20in%20Question%201%20to%20determine%20each%20of%20the%20Switch%20Case%20nodes%2C%20and%20then%20each%20Case%20can%20update%20items%20in%20a%20different%20SharePoint%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20that%20help%20you...%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

 

I want several Sharepoints lists to be filled in from one form, depending on the answer in a question.

 

I recently used Microsoft Forms for the first time. It is a fairly extensive questionnaire with 90 questions. At the beginning of the questionnaire there is a list of choices to which the other questions depend. The choice made there ensures that many questions are skipped and only the relevant questions for that choice can be filled in. There are, on average, 10 questions per choice, so it skip around 80 questions.

 

Example:

-Question 1 (list of choices)

  • - Option 1
  • - Option 2
  • - Option 3
  • - etc.

-Question 2

-Question 3

-Question 4

 

-Question 1 (list of choices)

  • - Option 1
  • - Option 2
  • - Option 3

-Question 2

-Question 3

-Question 4

 

Now I have the problem that when I send the results with a flow to a SharePoint list, I get a unclear list with all results with a lot of white fields since these questions have been skipped when filling in.

My wish is that several Sharepoint lists are filled in using microsoft flow, depending on the choice made in the first question.

So separate Sharepoint lists of option 1, option 2, option 3 etc.

 

Is this possible?

 

Thanks in advance

4 Replies
best response confirmed by Jeldro (New Contributor)
Solution

Hi @Jeldro ,

 

I would try using a Switch Case for this. That is, after getting the Forms responses in Flow, use the value in Question 1 to determine each of the Switch Case nodes, and then each Case can update items in a different SharePoint list.

 

Does that help you...?


Thanks for the tip, I am not familiar with this, but after a quick research I think this can help me.
I will take a try and let you know if it succeeded.
It works perfect, thanks a lot.

Great, @Jeldro - I'm happy to hear it!

 

Sandy