How do i show 14 lookups from a sharepoint list in a canvas app form?

(0) Share

Report

Posted on by SH-02121228-0

Hi,

SharePoint has a 12 lookup limit for views but not lists.

I want to show the data in all 14 lookups from my sharepoint list in one canvas app form.

When I try to get the data i get an error:

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

What is the workaround for this issue?

All I want to do is show the data that is in 1 sharepoint list in a canvas app....

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (4)

Answers (0)

Sort by

ronaldwalcott 3,906 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Separate your data into logical groups, use SharePoint views with more than one form and manage the updates.

Was this reply helpful? Yes No
WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SH-02121228-0,

You can only have a total of 12 columns in a SharePoint List of the types Person and Lookup. This is a built-in limitation with no workaround. As a piece of advice that may assist, SharePoint Lookup columns are mostly unnecessary with Power Apps and have the potential to cause you unwanted and unneeded complexity and restrictions - I have never used them. It is generally a better idea to get the required field items directly from the second list with Power Apps and write back to a Text column.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
SH-02121228-0 6 on at

Like
a
(0)

Report
Copy link

Link copied!

"You can only have a total of 12 columns in a SharePoint List of the types Person and Lookup. "

Is incorrect.

You can only have 12 lookup types in a VIEW. In a list you can have many more.....

Was this reply helpful? Yes No
WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

But Power Apps will not handle any more than that (all complex field types combined - Person, Lookup, Calculated) in a query which is what the issue is here. Also the Form is effectively a "view", so the same rules apply.

Was this reply helpful? Yes No