lookup columns it contains exceeds the lookup column threshold.

%3CLINGO-SUB%20id%3D%22lingo-sub-2102287%22%20slang%3D%22en-US%22%3Elookup%20columns%20it%20contains%20exceeds%20the%20lookup%20column%20threshold.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2102287%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20power%20apps%20integrated%20in%20SharePoint%20and%20it%20gives%20me%20this%20error%20%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%3CSPAN%3EThe%20requested%20operation%20is%20not%20valid.%20Server%20Response%3A%20Requests%20Failed%3A%20The%20query%20cannot%20be%20executed%20because%20the%20number%20of%20lookup%20columns%20it%20contains%20exceeds%20the%20lookup%20column%20threshold.%20clientRequestId%3A%205b798bbb-d5a5-4d04-a5a4-daf7af8caca9%20serviceRequestId%3A%205b798bbb-d5a5-4d04-a5a4-daf7af8caca9%3C%2FSPAN%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3BDoes%20anyone%20how%20to%20fix%20it%20%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2102287%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello,

 

I have a power apps integrated in SharePoint and it gives me this error : 

 

The requested operation is not valid. Server Response: Requests Failed: The query cannot be executed because the number of lookup columns it contains exceeds the lookup column threshold. clientRequestId: 5b798bbb-d5a5-4d04-a5a4-daf7af8caca9 serviceRequestId: 5b798bbb-d5a5-4d04-a5a4-daf7af8caca9

 Does anyone how to fix it ? 

Thanks

1 Reply
No way to fix that problem apart of reducing the number of lookup columns you have in the underlying list