web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / PowerApps do not show ...
Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by Pawala 16

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.

Categories:
Building Power Apps
  • VishalJhaveri Profile Picture
    VishalJhaveri 1,169 Moderator on at

    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.

  • Verified answer
    timl Profile Picture
    timl 37,287 Super User 2026 Season 2 on at

    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-c24122f07c59

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 393 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 278 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans