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