I have an Excel hosted on OneDrive with 2 column and 11,402 rows.
I have this formula in my Label:
It works until I start looking up anything after row 501
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.
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.
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.
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications