Forum Discussion
BarryAnderson
Oct 12, 2020Brass Contributor
Submission Limits in MS Forms
Hi. We have a number of long-life MS Forms which we expect to receive a large number of responses over the next few months.
Are there any limits on the number of submissions allowed for a single form? I can't find any MS documentation for this.
Thanks.
Actually, how do you get the table that excludes blanks? I see Q5 just says '=LET(', but what does this mean and how does this know to reference Table 1?
If you increase the size of the formula bar you'll see that in Q5 the formula is (I updated it - feel free to re-download the sample I earlier shared):
=LET( n, F5, FilterCol, LAMBDA(col, LET(values, CHOOSECOLS(Table1,col), FILTER(values,ISNUMBER(values),FALSE))), StackCol, LAMBDA(init,col, HSTACK(init, TAKE(FilterCol(col),-n))), Array, IFNA(DROP(REDUCE("",SEQUENCE(COLUMNS(Table1)), StackCol),,1),FALSE), Array )
where you can see the 2 references to Table1
If you want to make it more obvious or for easier maintenance you can use:
=LET( myTable, Table1, n, F5, FilterCol, LAMBDA(col, LET(values, CHOOSECOLS(myTable,col), FILTER(values,ISNUMBER(values),FALSE))), StackCol, LAMBDA(init,col, HSTACK(init, TAKE(FilterCol(col),-n))), Array, IFNA(DROP(REDUCE("",SEQUENCE(COLUMNS(myTable)), StackCol),,1),FALSE), Array )
2 Replies
Sort By
- nowa2020Copper Contributor
my microsoft form online broke, previously it has 1000 max limit, now it goes lower to 200.
this is even though I am on 365 family subscription.
- BarryAndersonBrass Contributor
In typical fashion I found the following information minutes after posting this question!
Currently the limit is 50K responses per form.