Forum Discussion
PowerApps Lookup Limitation
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?
