Answered

The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold

(1) Share

Report

Posted on by mambiger

Hi,

I am creating Power app form in one of the SharePoint lists. When I try to run it, I get this error "The requested operation is invalid. Server Response: NSR Test failed: The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold. clientRequestId: d261735b-d54f-466a-8889-e7db8fd8f4 serviceRequestId: d261735b-d54f-466a-8889-e7db8fd8f4".

Can you please let me know any solution for this issue?

I have the same question (2)

All responses (6)

Answers (1)

RandyHayes 76,291 Super User 2024 Season 1 on at

Like (1)

Report

Re: The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold

@mambiger

You can only have a max of 8 lookup columns in your list. This includes people columns.

I hope this is helpful for you.

Was this reply helpful? Yes No
mambiger 13 on at

Like (0)

Report

Re: The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold

Thanks for the reply @RandyHayes . I am creating custom form for adding a new record to a SharePoint list. It is working when adding new record with the default form. So, does that mean, if Power app has limitation of 8 lookups? I read in other posts that 12 is the limit.

Thanks,
Mahantesh

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,291 Super User 2024 Season 1 on at

Like (0)

Report

Re: The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold

@mambiger

I think they up'ed the limit to 12 some time ago, but it has never been an issue for me as we rarely use any lookup columns in a list.

Yes, the default form in SharePoint will handle it fine, but a customized PowerApp form will only handle the 8 (or 12 as I believe you are correct) lookup columns in it.

Was this reply helpful? Yes No
mambiger 13 on at

Like (2)

Report

Re: The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold

@RandyHayes
Any way to incorporate 12+ lookups in custom forms power apps?

Thanks,
Mahantesh

Was this reply helpful? Yes No
OlegK 47 on at

Like (0)

Report

The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold

If I have 10 lookup / person fields - NO issues.

After adding the 11th lookup / person field - there are issues with getting data in Power Apps.

NOTE (as I understood): The limit is 12 like lookup / person fields (10 + 2 system ones - "Created by", "Modified by")

Was this reply helpful? Yes No
OlegK 47 on at

Like (0)

Report

The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold

Found - "Another option is to use indexed columns and filtering to keep the view size for the list to 5,000 items or less."
If you have MORE then 12 like lookup / person fields (10 + 2 system ones - "Created by", "Modified by"), INDEXING doesn't help ! - verified.
The only way to avoid errors in Power platform - to have LESS than 12 like lookup / person fields (10 + 2 system ones - "Created by", "Modified by").

Was this reply helpful? Yes No