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:

Connecting to Data

All responses (5)

Answers (1)

KN-23070506-0 6 on at

Like (0)

Report

Re: LOOKUP value more than 2.000 number

Waauu thats whas a very god information.
mdevaney 29,987 Super User 2025 Season 1 on at

Like (0)

Report

Re: LOOKUP value more than 2.000 number

@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
Verified answer

mdevaney 29,987 Super User 2025 Season 1 on at

Like (0)

Report

Re: LOOKUP value more than 2.000 number

@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.
KN-23070506-0 6 on at

Like (0)

Report

Re: LOOKUP value more than 2.000 number

@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.
mdevaney 29,987 Super User 2025 Season 1 on at

Like (0)

Report

Re: LOOKUP value more than 2.000 number

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