cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jamestcbs
Helper II
Helper II

Only show items from subfolder within sharepoint library

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)

1 ACCEPTED SOLUTION

Accepted Solutions
BCBuizer
Super User
Super User

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.



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

View solution in original post

3 REPLIES 3
BCBuizer
Super User
Super User

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

 

 



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

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
Super User
Super User

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.



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (1,391)