Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Power Apps SharePoint Column Datatype Threshold

Hi all,


I have recently run into a SharePoint look up column threshold when developing my app. I understand that the threshold is set to 12 to maintain performance. That being said, I am trying to find some sort of documentation that lists the threshold for each SharePoint column data type for when integrating with the Power Platform.


For example, is there a limit to the number of single line of text fields?

Dual Super User
Dual Super User

This documentation is for SharePoint Server on-premises.  But the limits should be the same.

Software boundaries and limits for SharePoint Servers 2016 and 2019 - SharePoint Server | Microsoft ...

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Thank you for the link! For the Person or group column type, I am confused as to why the Maximum # columns is listed as 750. I know when you are trying to integrate a power app or use a power automate flow the limit is 12 columns. 


Is 750 referring to the number of columns that the SharePoint lists can have of this data type?

The limit is no more than 12 lookup columns in a view.  You can have more than that in the list itself, you just can't add more than that to an individual view of the list.  The problem is that Power apps doesn't support the use of SharePoint Views.  Power Automate does.  So the list itself can have more than 12 lookup views, but Power Apps can't.  I've worked in the past with one client to use Power Automate to retrieve the data because they had more than 12 lookup columns in their list.  The data was then passed back to Power Apps and stored in a collection.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Resolver I
Resolver I

Hi @BlueCatOwner01  The simple reason why Power Apps does this limiting lookups is because of "Performance".

We don't want Apps that are very slow for our businesses, that's why they kept the default that way..


Helpful resources

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.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,852)