cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bolin-stratus
Post Partisan
Post Partisan

Modify Dropdown Items Property to List Files From a Specific SP Doc Library Folder

I have a dropdown menu that is populated with files from a SP document library "Documents" and it excludes folder names using this code on the Items property:

 

Filter(Documents, !IsFolder)

 

This works great but now I need to designate a specific folder "Gold" in the SP document library to list all files from excluding any folder names. How would I modify the Items property code to only list files (not folders) in the "Gold" folder of the SP document library "Documents"?

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User III
Dual Super User III

Set the Items property equal to the following.

Filter(Documents, 'Folder path'="Shared Documents/SP Fest Demo/" && !IsFolder)

Replace "Shared Documents/SP Fest Demo/"  with the full path to the folder.  Make sure to include the closing '/' .  YOu will see that 'Folder path' isn't a match that is delegable since its not indexed and there is no way to make it delegable.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

4 REPLIES 4
Pstork1
Dual Super User III
Dual Super User III

Set the Items property equal to the following.

Filter(Documents, 'Folder path'="Shared Documents/SP Fest Demo/" && !IsFolder)

Replace "Shared Documents/SP Fest Demo/"  with the full path to the folder.  Make sure to include the closing '/' .  YOu will see that 'Folder path' isn't a match that is delegable since its not indexed and there is no way to make it delegable.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

@Pstork1 - Thanks for the quick response. This is the solution!  When designating the folder path, I tried several things before I got it to work. Even though the SP document library was "Documents" (default doc libr), I had to explicitly used "Shared Documents/" at the beginning of the folder path for it to work as shown below.  Thank you! 

Filter(Documents, 'Folder path' = "Shared Documents/Gold/" && !IsFolder)

 

Just a quick clarification.  The Display name of the document library is "Documents", but the internal name is "Shared Documents".  That's what you will see in the URL if you look closely.  That's why you have to use Shared Documents in the path.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

@Pstork1 - Thank you for the clarification. 

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (68,555)