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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (2,376)