as I am currently designing a tool for one of our customers, we want to use multivalued lookup columns. As there is no real limititation set for the amount of source data we fear it could reach for a boundary of SharePoint.

I've also searched the widewidewide internet to no avail, so I hope anyone is able to give me a hint on that. :-)

1 Answer 1


The answer is "it depends". Eventually you'll run into the 2100 parameter SQL Server limit. You'll have to simply test your particular list as each column (for which many are hidden) also count against this parameter limit.

  • Thanks for the hint. This limit I have seen, but didn't connected it to this question. Which columns do you mean? The ones of the source? So if the source did not have that many columns we could optimize it a bit? Sep 27, 2017 at 18:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.