Forum Discussion
lucystevens
Feb 22, 2024Copper Contributor
Lookup column threshold
Hi,
This error is appearing when I open the custom form on the SharePoint list but I do not have more than 12 lookup columns. Does anyone know why this error might be occurring? Any help would be really appreciated.
Thanks,
Lucy
Hello lucystevens
Looukp, People Picker and Managed Metadata are counting also as complex columns...
Best, Dave
lucystevens If you are using Power Apps customized list form, check below threads and see if those helps you:
- The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold
- Error: The query cannot be completed because the number of lookup columns it contains exceeds
- The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.