question

Lorena-9821 avatar image
0 Votes"
Lorena-9821 asked CaseyYangMSFT-4714 commented

PowerApps & SP Content Types

Happy Friday!

I have a SP Library in M365 which I am receiving the following error when I try to edit the document properties in Power Apps. The requested operation is invalid. Server Response: (lib name) failed: The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold.

This library has old content types that I want to remove which I feel are causing the excess in the threshold limit. If I remove the fields in PowerApps, it still does not get rid of the error. I've removed the content types in the library & template, but they still exist in PowerApps. Is there any way to remove these old connections?

Thank you!

office-sharepoint-online
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

CaseyYangMSFT-4714 avatar image
0 Votes"
CaseyYangMSFT-4714 answered CaseyYangMSFT-4714 commented

Hi @Lorena-9821,

This issue occurs since the library contains lookup columns more than the Lookup Threshold limit. In SharePoint Online the Lookup column Threshold default limit is 12. And other than standard lookup columns some column types such as Managed metadata columns, Person or group columns, Workflow Status, Created by, Modified by are also classified as lookup columns.

To avoid this issue, you must limit the number of lookups to maximum limit.

For Reference: Lookup column threshold affecting power app


If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Lorena-9821,

I'm checking how the things are going on about this issue. Is there any progress on this issue?

0 Votes 0 ·