The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold. clientRequestId: #serviceRequestId: #

Question

Hello ,

Can anyone help me to resolve the error while trying to retrieve data from the network: The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold.

clientRequestId: 56ad0d19-c577-45ba-9aec-68d174a46c78

serviceRequestId: 56ad0d19-c577-45ba-9aec-68d174a46c78

I counted the look up column and person group columns in one of my document library which is 12 and I guess look up columns limit is 12 as well. I also removed some columns from view as well. the whole system was working before and suddenly the error comes up. the perticular document library is connected with Power App and Power Automate where I get above error and could not find the solution as it was working fine before.

one more thing , few days ago I updated the Sharepoint online site url and and I guess it was working fine there was couple of error in Power App database connectivity and I fix all of them. My question is because of this reason I am getting this error or it is actually a look up column issue.

your response will be much appreciated.

Thank you in advance