Unanswered

Navigating Folders & Subfolders In A SharePoint Document Library

(1) Share

Report

Posted on by elfreddos

112

So I've been following this guide (Make A Power Apps Approvals Form - Matthew Devaney) on how to achieve this. I'm getting stuck at this section. He's basically hard-coded the browsing to begin at the Library root, or parent folder which is Customer Files.

I have a SharePoint Document Library setup with the below hierachy:

What I have are a series of parent project folders, I want the users to be able to browse each individual project folder from clicking on the associated project folder and then seeing the folders with the version numbers in them. I don't want the users to be able to see and browse (in PowerApps) all the folders at once.

The problem with Matthew's example is that he points PowerApps to the Document Library root (this is his code for the Items property of the gallery browser:

SortByColumns(
    Filter(
        'Customer Files',
        'Folder path' = varFolderPathCurrent
    ),
    "{IsFolder}",
    Descending,
    "{Name}",
    Ascending
)

What I want is for the browsing to add the associated project folder from within 'Customer Files' and I can get the parent folder name by getting it from the previous screen:

Set(varProjectFolderName, LookUp('DEV-Master-Projects-Library', ID = Value(ThisItem.'Submission Document ID'.Value), Name));

But then how to I attach that portion to the rest to begin browsing one level up from the main Document library? Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

WarrenBelz 153,079 Most Valuable Professional on at

Like (1)

Report
Hi @elfreddos,

FolderPath can incude sub-folders, but your main issue here is that queries on FolderPath are not Delegable, so once you have more than 500 (you can increase to 2,000) files in your Library, you will not receive the full amount of records (it will only filter from the first 500-2000).

UpdateContext( varFolderPathCurrent, ProjectX/ProjectX_ICE_V )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
elfreddos 112 on at

Like (0)

Report

Hi @WarrenBelz thanks but that didn't really answer my question.

You hardcodded the path.

The image was just supposed to show where I want to land in the folder hierarchy. Project X was just an example imagine at the "Project whatever" level you have many folders. Instead of being able to see all those folders I want to be able to click on a gallery item on one screen and then to into it's corresponding Folder on the next, be it:

Project X

Project Y

Project Z

I just don't want to go into the Library root or top level to be able to see all the different project folders.

Does that make sense? Is that possible?

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

Hi @elfreddos,

A couple of videos - from Reza Dorrani and Shane Young may assist you here.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
WillPage 2,307 Super User 2025 Season 2 on at

Like (0)

Report

I would suggest converting your root folders into document sets. That way you can use metadata to filter instead of only having the folder path to go on. With a document set, you can have a column called Project Name, and have the child items within the document set inherit the value for Project Name. So in yoru app you just filter the library by 'Project Name' = "Whatever" which is a delegable query. Make the server do the work.

Was this reply helpful? Yes No