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

[haripowers]

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

[RezaDorrani]

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

[haripowers]

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

[RezaDorrani]

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

[haripowers]

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

[RezaDorrani]

@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

[haripowers]

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.

[RezaDorrani]

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

[haripowers · Accepted solution]

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!

[haripowers]

thanks