Only show items from subfolder within sharepoint library

(0) Share

Report

Posted on by jamest1994

105

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)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
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/") )

Was this reply helpful? Yes No
jamest1994 105 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No