How to submit more responses than Microsoft Forms allows

%3CLINGO-SUB%20id%3D%22lingo-sub-177964%22%20slang%3D%22en-US%22%3EHow%20to%20submit%20more%20responses%20than%20Microsoft%20Forms%20allows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-177964%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you're%20using%20Microsoft%20Forms%20today%20and%20collect%20a%20large%20number%20of%20response%2C%20you%20may%20have%20reached%20the%205%2C000%20response%20limit.%26nbsp%3B%20So%20what%20do%20you%20do%20if%20you%20need%20to%20collect%20more%20feedback%3F%26nbsp%3B%20If%20you're%20working%20in%20an%20environment%20where%20you%20know%20how%20many%20respondents%20you%20have%2C%20then%20you%20can%20use%20an%20approach%20of%20multiple%20forms%20that%20feed%20a%20single%20SharePoint%20list.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F31275i4F9DDBE846EEBE46%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Multi-Forms.png%22%20title%3D%22Multi-Forms.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ECreating%20the%20Form%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EStart%20by%20creating%20the%20form%20that%20you%20want%20users%20to%20fill-in.%26nbsp%3B%20Once%20you've%20finished%20creating%20it%2C%20you%20can%20easily%20copy%20it%20from%20the%20Forms%20home%20page.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20273px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F31272i9DABD26C3C057C13%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22copy.PNG%22%20title%3D%22copy.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ECreating%20a%20SharePoint%20List%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3ENext%2C%20create%20a%20SharePoint%20list%20where%20you%20plan%20to%20store%20all%20the%20combined%20responses.%26nbsp%3B%20Make%20sure%20to%20add%20fields%20for%20all%20the%20Forms%20questions.%26nbsp%3B%20To%20understand%20how%20best%20to%20map%20Forms%20questions%20to%20SharePoint%20fields%2C%20have%20a%20look%20at%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Forms%2FMicrosoft-Forms-and-Flow-Leveraging-Real-Time-Survey-Results-in%2Fm-p%2F81028%22%20target%3D%22_blank%22%3EMicrosoft%20Forms%20and%20Flow%20-%20Leveraging%20Real-Time%20Survey%20Results%20in%20the%20Cloud%3C%2FA%3E.%20%26nbsp%3BThe%20SharePoint%20list%20limit%20is%2030%20million%20items%2C%20which%20is%20sufficient%20in%20most%20cases.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EConnecting%20the%20Forms%20to%20SharePoint%20using%20Flow%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EWhen%20you%20create%20a%20Flow%20to%20a%20Survey%20(as%20described%20in%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-Forms%2FMicrosoft-Forms-and-Flow-Leveraging-Real-Time-Survey-Results-in%2Fm-p%2F81028%22%20target%3D%22_blank%22%3EMicrosoft%20Forms%20and%20Flow%20-%20Leveraging%20Real-Time%20Survey%20Results%20in%20the%20Cloud)%3C%2FA%3E%2C%20you%20need%20to%20identify%20the%20source%20Form.%26nbsp%3B%20So%2C%20for%20each%20copy%20of%20the%20Form%2C%20you%20will%20need%20to%20create%20a%20copy%20of%20the%20Flow.%26nbsp%3B%20However%2C%20all%20of%20them%20can%20write%20to%20the%20same%20SharePoint%20list%2C%20thereby%20combining%20all%20the%20results.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-177964%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-178482%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20submit%20more%20responses%20than%20Microsoft%20Forms%20allows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-178482%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20a%20big%20fan%20and%20advocate%20of%20using%20SharePoint%20lists%20to%20%22stabilize%22%20Forms%20and%20make%20responses%20easier%20for%20team%20members%20to%20access%20using%20this%20same%20Form-%26gt%3BFlow-%26gt%3BList%20process%2C%20so%20thanks%20for%20presenting%20it%20in%20such%20a%20way%20that's%20easier%20to%20understand!%3C%2FP%3E%3C%2FLINGO-BODY%3E
MVP

If you're using Microsoft Forms today and collect a large number of response, you may have reached the 5,000 response limit.  So what do you do if you need to collect more feedback?  If you're working in an environment where you know how many respondents you have, then you can use an approach of multiple forms that feed a single SharePoint list.

 

Multi-Forms.png

 

 

 

Creating the Form

Start by creating the form that you want users to fill-in.  Once you've finished creating it, you can easily copy it from the Forms home page.

copy.PNG

Creating a SharePoint List

Next, create a SharePoint list where you plan to store all the combined responses.  Make sure to add fields for all the Forms questions.  To understand how best to map Forms questions to SharePoint fields, have a look at Microsoft Forms and Flow - Leveraging Real-Time Survey Results in the Cloud.  The SharePoint list limit is 30 million items, which is sufficient in most cases.

 

Connecting the Forms to SharePoint using Flow

When you create a Flow to a Survey (as described in Microsoft Forms and Flow - Leveraging Real-Time Survey Results in the Cloud), you need to identify the source Form.  So, for each copy of the Form, you will need to create a copy of the Flow.  However, all of them can write to the same SharePoint list, thereby combining all the results.

 

 

1 Reply

I'm a big fan and advocate of using SharePoint lists to "stabilize" Forms and make responses easier for team members to access using this same Form->Flow->List process, so thanks for presenting it in such a way that's easier to understand!