Only show items from subfolder within sharepoint library

[jamestcbs]

Hi! Is there a way to only display items within a specific folder path from a sharepoint library.

I'm trying to display items within a gallery using the below formula. 'A' is my data source but I'd only like to show the items from within the following folder path: A > Marketing Master > 5. Instant marketing

Filter(
A,
If ('Brand filter'.Selected.Result = "All", true, Brand= 'Brand filter'.Selected.Result),
Group= 'Group filter'.Selected.Result,
If ('Audience filter'.Selected.Result = "All", true, Audience= 'Audience filter'.Selected.Result),
If ('Focus filter'.Selected.Result = "All", true, Focus = 'Focus filter'.Selected.Result),
If ('Media filter'.Selected.Result = "All" , true, Media = 'Media filter'.Selected.Result)
)

I also have a few dropdowns that I'm hoping I can apply the same logic to. For example:

Sort(Distinct(A, Group),Result,Ascending)

[BCBuizer]

Hi @jamestcbs ,

A way to do this is to use the 'folder path', but unfortunately this is not delegable, so you may run into issues in case your data source has more items than the Data Row Limit (standard 500, be can be raised to 2000):

Filter(A, StartsWith('Full Path',"A/Marketing Master/5. Instant marketing/"))

Combining that with your existing filter whilst optimising the existing conditions:

Filter(
A,
'Brand filter'.Selected.Result = "All" || Brand= 'Brand filter'.Selected.Result),
Group= 'Group filter'.Selected.Result,
'Audience filter'.Selected.Result = "All" || Audience= 'Audience filter'.Selected.Result),
'Focus filter'.Selected.Result = "All" || Focus = 'Focus filter'.Selected.Result),
'Media filter'.Selected.Result = "All" || Media = 'Media filter'.Selected.Result),
StartsWith('Full Path',"A/Marketing Master/5. Instant marketing/")
)

[jamestcbs]

Hi thanks for the help, is there no way to access specific folders that contain more than 2,000 items then? We'll be using the folder to store all completed PDFs/PPTs for previewing and downloading via a gallery. Eventually this folder will contain more than 2000

Is the only other option to store all items within 'A' rather than a specific folder path? Thanks

[BCBuizer · Accepted solution]

Hi @jamestcbs ,

In that case I would probably set up a new library and have it synchronise with the mentioned folders. This library can then be linked to PowerApps without any issues.