Answered

Max Lookup Columns

(0) Share

Report

Posted on by JillH

Hi there. I have a large SharePoint list, and in order to simplify entry across my company, I'm customizing the form. Great. However - I'm getting the issue below:

"The requested operation is invalid. Server Response: The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator"

As I understand it, the limit is 12. Interesting, the root sharepoint list has 14 lookup columns (both Lookups and People/Groups included). But, two of those are Created by and Modified by, and since those don't show up on the Default SharePoint form, the form works. Similarly, all of the SharePoint views we use don't reference all 14 so those work too.

But - here we get to PowerApps. My custom for is only using about 6 of those 14. I could delete some of the other ones, but that would remove those entries in past records. Not ideal.

Is there a work-around? Any ideas? I'm | | this close with the form but I'm stuck...

Thank you!

Jill

Categories:

General Questions

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

RezaDorrani 12,141 on at

Like (2)

Report

Re: Max Lookup Columns

Hi @JillH

PowerApps loads all the columns from the data source (no View based loading)

The limit is 12 lookups
This includes all person or group fields and date fields
Created By, Modified By, Created, Modified and 4 basic fields in every list/library

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
JillH 78 on at

Like (0)

Report

Re: Max Lookup Columns

Ok! Thanks for confirming that limit...

Was this reply helpful? Yes No
vish3027 434 on at

Like (0)

Report

Re: Max Lookup Columns

Hi @RezaDorrani How to handle this in PowerApps?

In my requirement I cannot delete any column and facing same issue?
In sharepoint view i removed the column but in PowerApps gallery how to control that?

Thanks Vishal

Was this reply helpful? Yes No
OlegK 47 on at

Like (0)

Report

Max Lookup Columns

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.

With in the SharePoint list - NO issues, working fine having ALL the fields in any Views.

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

=================
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.
==================

SO, 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