Announcements
Hi @Vardan ,
Sorry to give you the bad news, but 30k rows using Excel as a Data Source will have significant restrictions in what you can do - Excel is a terrible data source (see this video) with very limited Delegation capability and many things that should technically work simply do not. If you have access to SharePoint lists, you might seriously consider shifting to them.
I have gone through the video already but SharePoint also has a limitation of 20000 rows while creating a list. Can we create a power automate flow to load 30000 rows and then use that as a source in lookup column. Will it make looking up operation very slow?
Not sure about Excel but if your data is in a SharePoint list there are various ways round 2000 limit. One is to add a text column (arbitrary name "dumCol") to the SP list. For records 1 to 2000 the column could contain, for example, "one", for the next 2000 records "two", the next 2000 "three", etc. You should then be able to load all the records in batches of 2000 using Filter, e.g. ClearCollect(myCollection,Filter(mySpList,dumCol="one"));Collect(myCollection,Filter(mySpList,dumCol="two"),Filter(mySpList,dumCol="three")
@Vardan ,
Which video are you referring to (do you mean 2,000 rows) - SharePoint can technically hold 33 million records and I have several well over 100k. I have a blog on Delegation that may be of use to you.Trying to filter 30k records locally will be exceedingly slow if it works at all.
Even if i am able to load the 30k record in sharepoint using power automate when I am using that to populate drop down or combobox in power apps it giving a delegation warning I cannot use gallery So how should I approach this in power apps I cannot use filter too.
The only way you are going to search 30,000 rows is by using StartsWith().
Filter( SPList, StartsWith( YourFieldName, YourTextSearch.Text ) )
I have a blog on a possible workaround using a Combo Box that may be useful to you.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 383 Super User 2026 Season 2
Mohsin Ali 356
WarrenBelz 232 Most Valuable Professional
