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:

Application Lifecycle Management (ALM)

All responses (4)

Answers (0)

WarrenBelz 148,546 Most Valuable Professional on at

Like (0)

Report

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

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.
SH-02121228-0 6 on at

Like (0)

Report

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

"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.....
WarrenBelz 148,546 Most Valuable Professional on at

Like (0)

Report

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

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 Buy me a coffee
ronaldwalcott 3,820 on at

Like (0)

Report

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

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