PowerApps Lookup Limitation

%3CLINGO-SUB%20id%3D%22lingo-sub-150878%22%20slang%3D%22en-US%22%3EPowerApps%20Lookup%20Limitation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-150878%22%20slang%3D%22en-US%22%3E%3CP%3ERight%20now%20there%20seems%20to%20be%20a%20limit%20on%20the%20number%20of%20%22lookup%22%20fields%20that%20a%20list%20can%20have%20if%20you%20want%20to%20create%20a%20PowerApp%20connected%20to%20that%20list.%20Currently%20set%20to%20no%20more%20than%208%20fields.%20This%20includes%20Person%2Fgroup%20lookup%20and%20list%20lookup%20fields.%20I%20am%20trying%20to%20build%20a%20POC%20list%20that%20utilizes%20the%20underlying%20links%20to%20the%20person%20profile%20inherent%20in%20a%20person%2Fgroup%20lookup%20field%20so%20that%20we%20do%20not%20have%20to%20collect%20and%20manage%20the%20additional%20user%20information%2C%20just%20the%20persons%20name.%20Letting%20users%20click%20on%20a%20persons%20name%20to%20access%20all%20of%20their%20info%20in%20their%20Delve%20profile%2C%20as%20well%20as%20all%20of%20the%20other%20features%20available%20with%20a%20person%20lookup%20in%20SharePoint%20Online.%20The%20issue%20is%20if%20I%20am%20only%20limited%20to%208%20person%20fields%20and%20my%20company%20tracks%20more%20department%20heads%20than%20that%2C%20what%20options%20do%20I%20have%20if%20I%20want%20to%20customize%20the%20forms.%20Are%20you%20planning%20on%20expanding%20the%20number%20of%20lookups%20one%20can%20use%20in%20PowerApp%20forms%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-150878%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-305237%22%20slang%3D%22en-US%22%3ERe%3A%20PowerApps%20Lookup%20Limitation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-305237%22%20slang%3D%22en-US%22%3E%3CP%3ESeems%20like%20this%20is%20still%20a%20thing%3F%20In%20flow%20you%20can%20choose%20a%20view%20for%26nbsp%3B%22Limit%20Columns%20by%20View%22%20...%20but%20in%20powerapps...%20aka%2C%20the%20thing%20you%20need%20to%20use%20to%20edit%20forms...%20no%20can%20do%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-188475%22%20slang%3D%22en-US%22%3ERe%3A%20PowerApps%20Lookup%20Limitation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-188475%22%20slang%3D%22en-US%22%3E%3CP%3ERunning%20into%20the%20same%20issue%20here.%20There%20are%20a%20LOT%20of%20fields%20in%20SharePoint%20that%20count%20as%20lookup%20fields%2C%20which%20makes%20this%20a%20serious%20problem.%20Also%20when%20I%20add%20the%26nbsp%3BSharePoint%20list%20as%20a%20data%20source%2C%26nbsp%3Bit%20wants%20to%20get%20all%20the%20fields.%20There%20is%20no%20way%20to%20customize%20that%20query%20if%20you%26nbsp%3Bstart%20from%20the%20'Customize%20forms'%20option%20on%20the%20SharePoint%20list.%3C%2FP%3E%3CP%3EAll%20I%20can%20think%20of%20right%20now%20is%20to%20split%20up%20my%20data%20in%26nbsp%3Btwo%20(or%20more)%20lists%2C%20but%20then%20I%20would%20need%20to%20add%20an%20additional%20data%20source%20in%20PowerApps%20studio%20to%20retrieve%20the%20'linked%20data'%26nbsp%3Bfrom%20the%20other%20SharePoint%20lists.%3C%2FP%3E%3CP%3EAt%20least%20that%20way%20you%20could%20bring%20down%20the%20number%20of%20lookup%20fields%20retrieved%20per%20data%20source%2C%20so%20it%20ends%20up%20within%20boundaries.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EFar%20from%20ideal%2C%20obviously%20(if%20that%20works%20at%20all)%2C%20would%20love%20some%20more%20sophisticated%20way%20to%20adjust%20those%20queries.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-151222%22%20slang%3D%22en-US%22%3ERe%3A%20PowerApps%20Lookup%20Limitation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-151222%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20List%20View%20Lookup%20Threshold%20is%20actually%20a%20SharePoint%20limit.%20SharePoint%20blocks%20queries%20that%20exceed%20the%20list%20view%20threshold.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-151199%22%20slang%3D%22en-US%22%3ERe%3A%20PowerApps%20Lookup%20Limitation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-151199%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20is%20a%20Office365%20Users%20connection%20that%20lets%20you%20search%20for%20users%2C%20and%20also%20get%20extended%20profile%20information%20for%20a%20(single)%20user.%20Maybe%20you%20can%20get%20this%20information%20pulled%20into%20your%20PowerApp%20when%20the%20users%20presses%20a%20button%20(More%20Person%20info).%20This%20connector%20is%20available%20in%20MS%20Flow.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-151074%22%20slang%3D%22en-US%22%3ERe%3A%20PowerApps%20Lookup%20Limitation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-151074%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20you%20tried%20a%20Choice%20column%26nbsp%3Bto%20rule%20out%20if%20its%20related%20to%20the%20SharePoint%26nbsp%3Blist%26nbsp%3B%20lookup%20threshold%3F%26nbsp%3B%20Just%20a%20thought.%3C%2FP%3E%0A%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fspses%2F2013%2F12%2F02%2Fsharepoint-20102013-list-view-lookup-threshold-uncovered%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblogs.msdn.microsoft.com%2Fspses%2F2013%2F12%2F02%2Fsharepoint-20102013-list-view-lookup-threshold-uncovered%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Visitor

Right now there seems to be a limit on the number of "lookup" fields that a list can have if you want to create a PowerApp connected to that list. Currently set to no more than 8 fields. This includes Person/group lookup and list lookup fields. I am trying to build a POC list that utilizes the underlying links to the person profile inherent in a person/group lookup field so that we do not have to collect and manage the additional user information, just the persons name. Letting users click on a persons name to access all of their info in their Delve profile, as well as all of the other features available with a person lookup in SharePoint Online. The issue is if I am only limited to 8 person fields and my company tracks more department heads than that, what options do I have if I want to customize the forms. Are you planning on expanding the number of lookups one can use in PowerApp forms?

5 Replies

Have you tried a Choice column to rule out if its related to the SharePoint list  lookup threshold?  Just a thought.



https://blogs.msdn.microsoft.com/spses/2013/12/02/sharepoint-20102013-list-view-lookup-threshold-unc...

There is a Office365 Users connection that lets you search for users, and also get extended profile information for a (single) user. Maybe you can get this information pulled into your PowerApp when the users presses a button (More Person info). This connector is available in MS Flow.

The List View Lookup Threshold is actually a SharePoint limit. SharePoint blocks queries that exceed the list view threshold.

Running into the same issue here. There are a LOT of fields in SharePoint that count as lookup fields, which makes this a serious problem. Also when I add the SharePoint list as a data source, it wants to get all the fields. There is no way to customize that query if you start from the 'Customize forms' option on the SharePoint list.

All I can think of right now is to split up my data in two (or more) lists, but then I would need to add an additional data source in PowerApps studio to retrieve the 'linked data' from the other SharePoint lists.

At least that way you could bring down the number of lookup fields retrieved per data source, so it ends up within boundaries.

Far from ideal, obviously (if that works at all), would love some more sophisticated way to adjust those queries.

Seems like this is still a thing? In flow you can choose a view for "Limit Columns by View" ... but in powerapps... aka, the thing you need to use to edit forms... no can do?