cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

LOOKUP value more than 2.000 number

I whant to make a app. where i can tape in a customer number and the app shall show the name of the customers.   But i have over 5.000 customersnumbers.

And i will do the same whit my products but i have over 13.000 of them.   

I can make the lookup function if it is in the first 2.000 number but if it higher than that i will not work.

 

I have my data in excel worksheet. 

 

What is the right way to fix it. 

 

Thanks in Advance.

1 ACCEPTED SOLUTION

Accepted Solutions

@KlausDK
Yes, it will work in SharePoint. I had your same issue when I began learning PowerApps and did not know Sharepoint. It does take awhile to learn but every minute you spend doing it will be completely worthwhile. SharePoint is a highly valuable job skill to have.

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

View solution in original post

5 REPLIES 5
Super User III
Super User III

@KlasDK
The only way to fix this problem is to choose another data source than Excel. There is no workaround. You will always be limited to 2,000 rows no matter what you do.

I would using suggest SharePoint instead.

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

@mdevaney 

if i change it to Sharepoint list will it then work? or do i have to do some work arounds in the sharepoint list.   I am not use to work in  a sharepoint list. 

@KlausDK
Yes, it will work in SharePoint. I had your same issue when I began learning PowerApps and did not know Sharepoint. It does take awhile to learn but every minute you spend doing it will be completely worthwhile. SharePoint is a highly valuable job skill to have.

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

View solution in original post

@KlasDK
Pro tip: to get your Excel data into SharePoint very fast do this.

#1. Put your data in an Excel data table
#2. On the table menu click the import to SharePoint button

Waauu  thats whas a very god information. 

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (37,664)