Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Maximum lookup column threshold in sharepoint online using source connector

(0) ShareShare
ReportReport
Posted on by 2

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!

  • Pstork1 Profile Picture
    Pstork1 64,703 on at
    Re: Maximum lookup column threshold in sharepoint online using source connector

    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.

  • RandyHayes Profile Picture
    RandyHayes 76,287 on at
    Re: Maximum lookup column threshold in sharepoint online using source connector

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

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.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard