Announcements
I have an Excel hosted on OneDrive with 2 column and 11,402 rows.
I have this formula in my Label:
LookUp(Source,column1= TextInput1.Text,column2)
It works until I start looking up anything after row 501
Any solutions?
Yes, don't store your data in Excel:
https://baizini-it.com/blog/index.php/2017/08/29/powerapps-101-data-storage/
There's no free connection I can use to host?
Or will I still be able to use SQL once my "$200" trail runs out?
Have you tried importing your spreadsheet into a SharePoint list?
I am not sure what you mean, but Azure SQL Database is not free. However, you can use the lowest tier and it will be cheap.
See here:
https://baizini-it.com/blog/index.php/2017/09/26/powerapps-and-azure-sql-database-101/
Do SharePoint lists not have a limit or rows that PowerApps will stop reading after?
It depends on predicatest but from your example it seems like it would work. Here is a link that talks about Delgable data sources and if you go down to the Filter and LookUp delegable section you will see what is supported.
Delegable data sources
That ALMOST worked but looks like the view limit is 5000. So PowerApps won't accept the formula
How large is your list? To try and get around the 5k limit in SharePoint, go into list setting and click on Index Columns and create an index for the column you are using in the lookup (i.e. column2). This works for creating filtered views in SharePoint with the 5K limit but I haven't run into this issue in PowerApps to give it a try.
There are 11401 rows in the list. I've managed to do the index, but how do I have PowerApps pull from it now?
Once you create the index in SharePoint it will takes awhile (maybe over night) for SharePoint to actually update the index. Then to test it out you would just run the same lookup code and see if it starts working.
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 402 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 296 Most Valuable Professional
