Answered

LOOKUP value more than 2.000 number

(0) Share

Report

Posted on by KN-23070506-0

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
KN-23070506-0 6 on at

Like
a
(0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
KN-23070506-0 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Waauu thats whas a very god information.

Was this reply helpful? Yes No