When Submitting a Form to SharePoint, receive Error (npokhrel123 npokhrel123 Helper I Helper I The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by administrator)but form still submits to SharePoint List

[MattMolkoski]

Hi,

I'm trying to submit a form with a number of LookUp columns, likely exceeding the threshold set by the administrator.

When I submit the form from PowerApps, the submitform function executes, the back() function executes and I end up back where I was supposed to, but I get the "The Requested Operation is invalid. Server Response: <SharePoint List> failed: The query cannot be completed because the number of lookup columns it contains exceed the lookup column threshold enforced by the administrator.

However, when I look at the list in SharePoint, the form has successfully submitted and my new item is showing. What's going on?

[jlindstrom · Accepted solution]

The limit is 12 and that includes fields like lookups, person fields, and the standard fields like created by.

chances are some of the fields may not be getting updated when you patch 

https://natechamberlain.com/2018/09/04/how-to-increase-lookup-column-limit-in-sharepoint-lists/

you may want to replace some

of your lookups with text fields or split this to multiple lists

you can still simulate a lookup field by storing the id or name of a record in a text field, especially if the list is only used in your app