Long time retrieving files from subfolders on document library

[Sesese]

Hi guys,

I've a gallery that shows files from a specific subfolders filtered from a document library subfolder according to the title that I call from another gallery.

The Items control of the gallery that displays files is "Filter(Documents;'Folder path'= Concatenate("Shared Documents/Requests/Utility/Attachments/Number";Last(Split(Gallery1_4.Selected.Title;" ")).Result;"/")).

The issue here is that the app requires long time on loading the files from the subfolders; how can I manage a better way to store them (with a collection) or does exists a workaround to speedup the loading?

[v-xiaochen-msft · Accepted solution]

Hi @Sesese ,

I can not simplify your formula because it's good and simple enough...

Try to save them into collection when the app is loaded. It should have better performance when user chooses the folder path.

Best Regards,

Wearsky