PowerApps do not show the data from SharePoint List if it has more columns

[Pawala]

I don't know how to put this, but I will try to be precise, so the issue is addressed properly

My SharePoint List has a total of 29 columns when I created a PowerApps from the SP List the data is not showing in all the three screens (Browse, Detail, Edit)

Out of 29 columns, 12 columns are People columns.

When I delete last 2 columns (2 People columns) then data is coming properly in PowerApps (27 columns now).

When I add 2 new Text Input fields then data is coming properly (29 columns again)

So, at this point my understanding is that PowerApps only show data when SP List has no more than 10 people columns (I could be wrong too).

I was not able to fix this.

[VishalJhaveri]

This is a prompt response:

It sounds like you're encountering a limitation or issue with PowerApps when working with SharePoint lists that have a high number of People columns. While I don't have specific insight into every nuance of PowerApps and SharePoint integration, I can suggest a few troubleshooting steps and potential workarounds:

1. Check PowerApps documentation: The PowerApps documentation or community forums might have insights into any limitations or best practices regarding the number of People columns in SharePoint lists and how they interact with PowerApps.

2. Review SharePoint list settings: Ensure that the SharePoint list settings, especially related to permissions and column types, are configured correctly. Sometimes issues with data not displaying can be due to permissions or data type mismatches.

3. Test with a smaller subset of columns: If possible, try creating a test SharePoint list with a smaller number of columns, including People columns, and see if the issue persists. This could help isolate whether the problem is specifically related to the number of People columns or if there are other factors at play.

4. Consider alternative approaches: Depending on your requirements, you might explore alternative approaches such as using calculated fields in SharePoint to consolidate data or redesigning your app layout to work with a smaller number of People columns at a time.

5. Reach out to Microsoft support or community: If you're still unable to resolve the issue, reaching out to Microsoft support or posting your question on the PowerApps community forums might provide additional assistance and insights from other users who have encountered similar challenges.

It's possible that there could be a limitation or bug in PowerApps related to the number of People columns, but further investigation and testing will help determine the cause and potential solutions.

[timl · Accepted solution]

Hi @Pawala 

>>So, at this point my understanding is that PowerApps only show data when SP List has no more than 10 people columns (I could be wrong too).

This is correct. The Sharepoint documentation below clarifies this - 12 or more people, lookup, or metadata columns will result in threshold errors and this is the reason why the data doesn't appear. A SharePoint list includes the 2 built-in created/modified columns so that explains the 10 column limit that you're seeing.

As this is a SharePoint limitation, there unfortunately isn't a fix for this.

https://support.microsoft.com/en-us/office/manage-large-lists-and-libraries-b8588dae-9387-48c2-9248-...