Announcements
Maximum lookup column threshold in sharepoint online using the source connector in Power Apps . I am still getting the error regarding exceeding the lookup columns. I count 15 managed metadata
Is there any way to filter columns to get only 12 columns and prevent this error? I mean to have the ability to pull only the columns that I need and ignore the rest.
Thank you!
@BillRamz
No, you cannot use a "view" of your list in PowerApps. You will need to reduce your lookup columns in the list.
Lookup columns are intended to provide a better experience in the SharePoint interface.
Since you are building an app for your data, the lookup columns are not relevant as you app can provide all the lookup you need in it.
So, it shouldn't be that hard to remove and adjust.
I hope this is helpful for you.
As @RandyHayes said there is no way to do it using Power Apps alone. If you are designing your own data source then I agree with Randy, you should replace your Lookups with columns that provide the necessary data. But if you are using a pre-existing data source there is another option. Power Automate has support for restricting columns returned using SharePoint views. I have called a flow in the past to retrieve data and return it to Power Apps as a collection. Power Apps can then use the collection as a data source and save changes to the data source through Power Automate.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 549 Most Valuable Professional
Kalathiya 225 Super User 2026 Season 1
Haque 224
