Answered

Pre filter photo library that exceeds 8K

(0) Share

Report

Posted on by Dorinda

1,512

I have an app that is connected to a library that has over 8K of pictures. I know I cannot load them all at one because of the limitation in place.

I want to see if I can on start or on visible collect those images and filter to a specific name.

I tried this no joy

ClearCollect(colSinglePhaseReg, 'Asset Photos*DO NOT USE'.AssetClass ="Single Phase Regulator");

I have several screens that are broken down but the individual Asset Class so that if I wanted to filter it on visible or OnStart so I can have all of the images show for that particular Asset Class.

Would appreciate the help

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Pstork1 69,661 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
If you are going to pre-filter the library by asset class then there really is no reason to pull them into a collection using OnStart. Just use a Filter() in the items of the gallery where you are displaying them.

Filter('Asset Photos*DO NOT USE', AssetClass ="Single Phase Regulator")
Dorinda 1,512 on at

Like
a
(0)

Report
Copy link

Link copied!
@Pstork1

I tried that and it works on every other screen but this one and I dont know if it is because it is further down but this is the code that I have working everywhere else by on this screen

Filter( 'Asset Photos*DO NOT USE', Substation.Value = Gallery4_11.Selected.Station && AssetClass = "Single Phase Regulator" && AssetPosition = Gallery4_11.Selected.'Asset Location' )
Verified answer

Dorinda 1,512 on at

Like
a
(0)

Report
Copy link

Link copied!
DUH I figured it out, I had the wrong field matching!!! I need more coffee

Filter( 'Asset Photos*DO NOT USE', Substation.Value = Gallery4_11.Selected.Substation && AssetClass = "Single Phase Regulator" && AssetPosition = Gallery4_11.Selected.'Asset Location' )
Pstork1 69,661 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

What about that filter doesn't work? what error is it giving? When you say further down is it included with other code in the Items property? If it is then check that the other code is running successfully. Otherwise this code won't be reached.