cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
haripowers
Frequent Visitor

Power Apps - SharePoint Look up list column threshold exceeds - Lookup columns only 4including person/group

Hi,

I am getting the SharePoint Lookup list column threshold that exceeds error when I try to create a custom form using PowerApps. SharePoint default form works without error. The strange thing is my list contains only 4 lookup columns including person/group columns. Even if I count choice columns, the total is 8. 

I tried creating another list with the same schema and power apps form works there. But I have to create a power apps form in this list only as it contains a lot of data already. Not sure why power apps throwing threshold error even if there are fewer lookup columns.

Appreciate any help on this. Many thanks

Error screenshot from power apps studio attached

1 ACCEPTED SOLUTION

Accepted Solutions

Thanks a lot @RezaDorrani 

Finally figured out the issue. There were many SharePoint 2010 workflows associated with the list. Which internally has 'workflowstatus' column which is a lookup. PowerApps is throwing the error due to this. Got rid of all these workflows and the form starts working!

View solution in original post

10 REPLIES 10
RezaDorrani
Dual Super User II
Dual Super User II

Hi @haripowers 

 

The threshold limit of 12 lookup columns includes lookups, person and managed metadata columns.

Even includes the Modified By and Created By columns by design.

 

Check this video:

https://www.youtube.com/watch?v=AkyW8cWDVoc

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

Hi @RezaDorrani ,

Thanks. But I have only 4 lookup columns which include lookups, person, and managed metadata columns.

Remaining are single line, multi line, 4 choice, 2 hyperlinks

Hi @haripowers 

 

Can you please share a screenshot of your list/library with all columns.

Screenshot of columns in List settings page would be preferred.

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

Hi @RezaDorrani 

 

Please find the attached document with a screenshot of the full list of columns. ( two pages as the columns list is bit long)

Thank you!

I tried deleting the custom power app and recreating, but didn't help

@haripowers 

 

Definitely looks like something is not right with this list.

 

You mentioned this list has a lot of data. How much data?

Also, did this list have a different schema earlier?

Are you using content types? Are there any orphaned columns in list?

 

Same schema works in a different list which definitely points to some schema updated in this list.

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

Hi,

Yes, using content types, and there are no orphaned columns. 500 items are in the list. To give more details,

The list was using a power apps form of the older version ( version 3.19 ) which is published in Feb 2019

When I opened the form in power apps and republished it to a new version, this stopped working with the threshold error.

Even if I delete the form and recreate new custom forms, still the error exists.

SharePoint OOB form works without any issues.

Hi @haripowers 

 

Raise a support ticket with MSFT. There must be some discrepancy with how Power Apps is interacting with this SP list.

 

Regards,

Reza

Thanks a lot @RezaDorrani 

Finally figured out the issue. There were many SharePoint 2010 workflows associated with the list. Which internally has 'workflowstatus' column which is a lookup. PowerApps is throwing the error due to this. Got rid of all these workflows and the form starts working!

thanks

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,238)