web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Lookup column from tab...
Power Apps
Unanswered

Lookup column from table containing 12,000+ records

(1) ShareShare
ReportReport
Posted on by 34

Hello,

Is there a limit of 5,000 records for Dataverse lookup columns?

Its my first time building tables and one lookup column from a table of over 12,000 records doesn't work. My initial reading suggests there's a 5,000 record limit but there are ways around this via Automate.

Are these 'workarounds' accepted as valid and don't have any negative features?

Thanks

I have the same question (0)
  • MichaelFP Profile Picture
    1,847 Super User 2025 Season 2 on at
    Re: Lookup column from table containing 12,000+ records

    @MrSheen  you can paging the result and include in a array. 

     

    But power automate is not recommend to do it this type of job, for a large number of data. You will gonna struggle with the limits from Dataverse and Power Automate

  • ivan_apps Profile Picture
    2,187 Moderator on at
    Re: Lookup column from table containing 12,000+ records

    Are you creating a model-driven app or a canvas app? 

    lookup columns will be able to search all records when you type in a search criteria. Be sure to configure your Quick Find view to select which columns are being searched. 

     

    5000 was the default count limit when displaying a view, it would say 5000+ records when there were more (model-driven). Hopefully that helps.

  • Jonathan Manrique Profile Picture
    2,687 on at
    Re: Lookup column from table containing 12,000+ records

    Hi @MrSheen 

     

    Depending on what you are doing, if it is a Canvas App or Model Driven

    In the case of the first, if it is a Lookup where you must show values ​​and they are 12000, unless you make a filter and handle the delegation issue, you will have many problems finding the record. Maybe you can also use search to search the record using the first words or endwith or starwith

    In the case of Model Driven you do not have those delegation problems and just by writing the first three letters you would have it

     

  • MrSheen Profile Picture
    34 on at
    Re: Lookup column from table containing 12,000+ records

    Thanks all for your help. Stupidly the data table I was trying to lookup from wasn't populated so now it is everything works. Thanks again.

  • Shashank Bhide Profile Picture
    942 Moderator on at

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 757 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 322 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 209 Super User 2025 Season 2

Last 30 days Overall leaderboard