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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Lookup function with l...
Power Apps
Unanswered

Lookup function with large data table

(0) ShareShare
ReportReport
Posted on by Prabhu_Rajaram

hello experts, i have created an application where i need to do the lookup value from static excel, it has more than 25k records and it will grow further in future. i used the below function to lookup the value but it works only upto 15000 records exactly. how to make it work with large data?

Prabhu_Rajaram_0-1671080931552.png

ClientList -> excel table (static excel)

Engagement number is the column in excel table

DataCardValue6 is the reference field

'Eng Manager Name' is the result i need to get from excel table.

 

The above function is working fine exactly till 15000 records, but it didnt pick the result post 15000.

Categories:
Building Power Apps
I have the same question (0)
  • Drrickryp Profile Picture
    Drrickryp Super User 2024 Season 1 on at

    @Prabhu_Rajaram 

    Static excel can only import 15k records but you can import sequential 15k tables and combine them in a collection. See my post here about how to import 45k zip codes. To use as a LookUp table.  https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Automatically-Prefill-City-and-State-using-Zip-Codes-in-your-App/ba-p/200465  as an example.

  • Prabhu_Rajaram Profile Picture
    Prabhu_Rajaram on at

    hi Drrickryp, thanks for your response, i used the below two approach, in both the case i get error.

     

    Prabhu_Rajaram_0-1671083084666.png

     

    Prabhu_Rajaram_1-1671083141446.png

    "The collect has some invalid arguments" or "The ClearCollect has some invalid arguments"error.

     

    if if use only one table into collections it works fine. i cant combine two table in one collection

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 396 Most Valuable Professional

#2
11manish Profile Picture

11manish 134 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 101 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans