Unanswered

Asset Manager with more than 2000 records

(0) Share

Report

Posted on by SH-23070720-0

Hello,

I recently found that PowerApps only pulls through a maximum of 2000 records from a Microsoft / Sharepoint list. I am planning to have an asset manager that will exceed the maximum amount.

Is there any way that this can be exceeded? I want to be able to search my app for any asset that I have in my list if it is possible. My current items property on the gallery looks like this

With({SourceItem:'Asset Manager'},
Sort(
 If(
 IsBlank(TextSearchBox1.Text),
 SourceItem,
 Search(
 SourceItem,
 TextSearchBox1.Text,
 "Location",
 "Title"
 )
 ),
 "Title"
)
)

It is currently set so that I can search for either the asset tag (Title) or the location of a number of assets.

I'm a bit clueless with formulas so I have no idea what I am doing or what direction to go in, so any help would be appreciated! Thanks

Categories:

General Questions

Using Apps Using Formulas

All responses (15)

Answers (0)

SH-23070720-0 on at

Like (0)

Report

Re: Asset Manager with more than 2000 records

Thanks @WarrenBelz
I will check at some point next week as I've been caught with some other things that have taken my priority.
WarrenBelz 146,708 Most Valuable Professional on at

Like (1)

Report

Re: Asset Manager with more than 2000 records

Hi @HeronS98 ,

Please have a read of Collections in this blog of mine - it may assist
SH-23070720-0 on at

Like (0)

Report

Re: Asset Manager with more than 2000 records

Hi @CNT ,
Sorry I closed up shop for the year in Dec and have only just got back - I hadn't got it working, no.
CNT 10,919 Super User 2025 Season 1 on at

Like (1)

Report

Re: Asset Manager with more than 2000 records

@HeronS98 Di you get it to work?
SH-23070720-0 on at

Like (0)

Report

Re: Asset Manager with more than 2000 records

I'll test about and get back to you.
CNT 10,919 Super User 2025 Season 1 on at

Like (0)

Report

Re: Asset Manager with more than 2000 records

@HeronS98 I've the same without any problems Maybe it's something else in the App that's causing the problem.
SH-23070720-0 on at

Like (0)

Report

Re: Asset Manager with more than 2000 records

Still getting that same error as previous.
CNT 10,919 Super User 2025 Season 1 on at

Like (0)

Report

Re: Asset Manager with more than 2000 records

@HeronS98 Then do it like this,

Clear(col1);

Collect(col1, Filter('Asset Manager', AssetManagerID<2001);

Clear(col2);

Collect(col2, Filter('Asset Manager', AssetManagerID>2000 && AssetManagerID<4001);

...

...

Clear(colCombined);

Collect(colCombined, col1, col2,......)
SH-23070720-0 on at

Like (0)

Report

Re: Asset Manager with more than 2000 records

When I put into OnVisible, it says col1 name isn't valid. Does is need to be defined elsewhere?
CNT 10,919 Super User 2025 Season 1 on at

Like (0)

Report

Re: Asset Manager with more than 2000 records

@HeronS98 Where you place it depends on the App. The best place would be in the OnVisible of the Screen. As you can get only 2000 records at a time, please follow the formula below. col1, col2, etc., are intermediate collections. Finally, all the records will be in the collection called colCombined.

ClearCollect(col1, Filter('Asset Manager', AssetManagerID<2001);

ClearCollect(col2, Filter('Asset Manager', AssetManagerID>2000 && AssetManagerID<4001);

...

...

ClearCollect(colCombined, col1, col2,......)