cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BlueCatOwner01
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?

4 REPLIES 4
Pstork1
Dual Super User III
Dual Super User III

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.
A-Roosevelt
Frequent Visitor

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

Cheers...

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

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