Power Apps SharePoint Document Library Browser 

Not sure if sommething has changed, but I had to use 'Value' insted of 'Result' in the code: Set(varFolderPath, Concat(FirstN(Split(varFolderPath, "/"), CountRows(Split(varFolderPath, "/"))-2), Value, "/") & "/") Love your videos PowerApps would be so much harder to learn without all your input.

"In life, death, taxes, and delegation are the most important things." - Shane Young Now one of my favorite quotes.

This is pretty awesome Shane. Lots of fun techniques and tips to manage stuff with Visible and vars. Love it! Thank you 😊

@Shane Young. Great stuf! One note though: you can use delegation in combination with SharePoint libraries (thanks to Reza Dorrani, would never have found that out by myself). If you add an indexed library column ('IndexedFolderPath') which you populate by flow, your solution works with large (>5000 item) lists. I've created such a flow which also iterates down the foldertree in case an upper parent is renamed. But I am sure you write a better one yourself if this is something which you would find useful. Thanks for all your work for the community and keep it up!

Brilliant as always Shane, thanks for sparking the ideas with your videos. Was an absolute novice six months ago, but with your vids i've learnt a lot... and we're producing so many apps via powerapps now. Thank you 😉

Dude!! Another one of your videos that sent me down a rabbit hole!! Thank you!!! I was able to combine this with a SharePoint List and filter the Document (Gallery) files based on the Title name of my SharePoint List. Love your stuff!

Sir, you are a freaking legend. Long live the king of Powerapptopia

OMG! Thank you so very much for this video. I am back on the horse now and happy with the progress. Thanks Shane. I just purchased Office Hours and can't wait for you to get me straightened out.

A very important video. I'm making a playlist of these 'Basics/All about' videos as a reference for my studies. Thanks, Shane. Best, Paul

Thanks for leaving it the little workflows in-between. I was good to see little bonuses like quickly modifying a list (thumbnail) and then refreshing the data source. I feel like I now have a much broader understanding of how things click together :-)

Ty so much for your videos Shane its because of you that I passed my PL-100 and became a certified app maker. Also I will forever identify you as striped zebras way cooler tag in my opinion

Love the coding for the up arrow. Brilliant!

This video is exactly what I needed. Thank you!

Hey thanks Shane the Launch() function was what I have been looking for!

Dude, you run very well! Great video.

Awesome Shane !!, thanks for all these tips

Hi Shane - love your vids, very well done and informative. Giddyup

Hey Shane, Great video, as usual, thanks for sharing! The good thing is also it respects the library and/or sub-folder, file permissions based on how it's configured in SharePoint to the users. I have one question: 1. If I have User A, User B belongs to the Documents library and I have User C and User D belongs for example to Accounting Library is it possible to apply filter condition on the main gallery to display the content of the folders based on the library and the current user signed-in?

Great video, the step by step instructions really helped! Thank you

Hello from Brazil !!! Thank you very much. Your explanation is great and simple.

Very gooood job!! Thanks Shane!

Amazing Shane as always. :) Your tutorials and resources have helped me save countless hours and allowed me to create comprehensive apps for my company. I subscribe to your curated library and Power Apps and Power Automate 201. Is there a resource file for this video in either of those? So excited for Power Apps and Power Automate 201 2022. Thank you for being awesome!

Thank you Shane. Great video.

@Shane Young I Enjoyed this video too. I am building a pastoral care app for the school I teach at. I was wondering If it is possible to mimic the Teams feature where a document library is populated with folders 📂 when students submit their assignments. Any other work they submit is subsequently added to their folder. When we meet with parents it would be great to have all the supporting docs in a single folder for each student. Thanks for all your efforts. PS I'm not sure I'm ever going to finish this app if I keep watching your videos🤣🤣

A great video, alone I would never have succeeded! Very useful for me, thanks for the help!

Thanks so much for the video Shane! Is it possible to have two different document libraries in one app? Since its set OnStart value I'm kinda stuck how to do it.

Excellent video! Thank you very much!

Great video again. So thanks!

Hi Shane. Love your work (as always). I built something like this recently, but am having some difficulty with using metada for filtering (we have created a bunch of doctype groups as various filters in our libraries.) I'm getting an error about that column being a record. Is this a function of the term store setup effectively being a bunch of records grouped together? Am I not referencing it correctly and/or is there a way to do so? Really appreciate your thoughts on that - I see you were simply able to reference the metadata AnimalType in the preview... Cheers from Down Under.

First of all: i like you're video tutorials a lot. I wonder if there is simple way to get the url out of element type link from a sharepoint library? when you use the "Link to item" you only will get the path to the shortend document.

This reminds me so much of FileMaker. I used it way back around 2011? It was a database application on Macs

Hi Shane, Awsome stuff you make. Very good step by step. One thing I cannot solve, do you know if something is changed regarding the Thumbnails? When I want to change the sample image for a thumbnail, it doesn't work..

Hi Shane, this looks like it could be part of a solution I'm looking for for the charity I work for. I'm looking for a way to display template forms from a SharePoint library to lots of different Teams. I've looked at adding a flow that will copy the selected from the master library to the Teams library. However, I hit a snag as the flow wants current & destination site addresses. do you know if there's a way to pass these dynamically? The app will need to work for over 70 Teams

@Shane, great video. i am just starting out learning about PowerApps and Sharepoint. Was wondering, is there a way when people are viewing the content to disable the ability to download and/or use the right click option to do Save As. Want to block the ability to disable downloading content. Thank you

Very nice Shane, you are a great teacher, I recommend to people trying to learn Power Apps. I share your dislike of delete. :-) But how about rename? Or move. These are things we all want to do with the files and folders in SharePoint. :-) Am I wrong to think we need SharePoint API to do this? Cheers, Michel

Hi Shane, nice solution I must say :) Though I don' see how you would be able to use this method when using for example different sharepoint sites for each project that you want to browse and thus need to make hundrerds of connections to datasources in powerapps.

Cool video, how do you delete or remove a file if it is in a folder inside the "Documents" library. You said that you were in Shared Documents but you deleted from Documents. How can you delete one level down?

Hi have you done a video where we can read the contents of an excel file we upload in the document library as you have done above but then upload that data into dataverse? And is it also possible to filter the documents on the powerapps by the user so that users only see what they have uploaded?

Good job, Sir!

As always useful, nice video, Can we put a search in this app. I've managed to handle delegation, add a text column in SP Library, Some how search is not working on that. Please have a thought. Thank You

Hi Shane, this covers some points I have been stuck on. One thing I have been trying to work out is if CDS could be used to store documents, or, is it simply not a document storage service?

Great content as usual. Have you ever applied metadata (i.e. using document content types) upon adding a document to a library through a powerapp?

Good one. Now I know delegation ranks right up there with taxes. Was a good reminder on Concat, Split, and grouping the shade/pop-ups. I still don't know how you are getting the SharePoint links to images to show on your mobile. I'm still failing at that.

Hi Shane, Again a very interesting video. Unfortunately I also had the "delegation problem". I use a dirty trick for this, to load libraries with more than 2000 items. I copy the data into a collection with the filter by the "Modified" column and a date earlier than the library was created. Since I only want to display dates, this is sufficient for me.

Hello Shane, your explanations are excellent, there is only one detail that I would like to know if it can be applied, I have a large number of folders in the library. Will it be possible to filter a specific folder and access its content?

Great Video! I added the search icon for the preview but when I enter the code listed set(varRecord, ThisItem); set(varShowPreview, true) ThisItem is not being recognise as a valid function. What am i doing wrong or what I left off

Death Taxes & Delegation are the most important things in Life. Carved that on my wall!

Great video, as always. And incredibly well timed, I must say. You could prevent the whole delegation issue by pointing the gallery to a collection instead of the SharePoint library, right?

Hi Shane! You have been a LIFESAVER for me (non IT person... dabbling to make things easier for my team at work) building these types of apps for the first time in my life (currently on my 3rd in the last year or so)!!!! Thank you for your videos!! You are always my go-to! I'm having a hard time getting my "nested" document library gallery to reset. I've tried multiple functions, but I can only seem to get it to go back to the top record inside the subfolder selected, and not to the "main library" view where all the folders are listed. Is there a trick to getting a gallery back to the original "startup look" by clicking a button? Or will the app need to restart completely to do so? Thanks in advance! ETA: I solved the problem while trying to fix another problem with deep linking LOL!!! I ended up setting my variable on the gallery screen "OnVisible" function. Now, it resets every time I go back to it **YESSSS!!!!** Thanks! - Now back to my deep linking issue 😠

👍👍 Life saver great content Shane . Possible to create folder when the plus icon is clicked ? Please advice how I can create folder in low and push files in the folder

Hi Shane I have found this video really helpful however I am stumbling on Filter(Documents, 'Folder path' = "foldername/") to filter my main folders. it just refuses to recognise the command. Any suggestions?

Brilliant!

Excelent, thanks!

This is 100% what I have been looking for!!! Except this is not working for me :( Does the Document Library need to have specific settings enabled?

Great video, thanks! How do you manage to open word documents in a new browser tab? When I try to do that the documents are always downloaded.

Soooo helpful. Thanks so much for this. Is there a way of adding a sort (sorry very new to this)

Love the videos. One problem, "Result" in the up arrow does not work for me. It is not recognized.

Good stuff thanks and is there a way to get the subfolder/specific folder open and see the item on the gallery when the screen loads rather than navigating it from the beginning. If yes , what would be the code foe the test folder here. Thanks

Hi Shane and Team, I know this Video is 3 years old, I was wondering if there has been any advance on the 2000 max records for galley search ,filter & folder path. I have an automation that raises Repair Purchase orders and sends them to our Vendor base. Each order is pushed to a SharePoint Document library as a PDF. I would like to be able to have a canvas app where an approved user can pull down a PDF copy. I have approx 22,000 active orders as some components in the airline industry have long turn times. Building the app is a piece of cake, Delegation is the issue. Any Tips or workaround would be appreciate. Also, as always Great content on all your videos . Thanks

Thanks again as always Shane, another great video! I've got everything working like I need it to, however I can't figure out how to create nested folders. I'm using PA to create a folder in the document library but it only saves it to the root. Not sure how I pass the file path to create a folder within another folder. Any assistance would be appreciated!

My previous comment seems to have disappeared. I was curious as to why delegation failed for Filter() using Text and + which the documentation seems to imply should work. I just found a Microsoft forum post which showed that delegation for Filter() is supported for columns which are either custom or are same as those used by Lists.

Is there a work around for the non-delegable limitation? Is it possible to set the gallery data source to specific folder and it subfolders?

Hey guys and Shane! Awesome video! I actually used your solution on a project. I have one question though. I have seen the video where you teach “how to upload a file to a Sharepoint folder from PowerApps” and I saw that you mention the video in this one we are now but doesn’t go in detail. But I would like to CHOOSE the folder in the SP library that the file will go before uploading it. Is that possible? Could anyone or Shane kindly help please? Thank you very much.

Thanks for useful content. Is it possible do the same thing with File System Connector?

Shane - how can we search these document libraries? I have large quantities of files and need to search the title, but "search" and "filter" will not work... :(

I have 2 galleries. 1st gallery contains names of SP libraries. like you have 1 folder called 'Documents', I have 17 folders. Can you say how to fetch folder path for the site contents tab in SP cuz all lists & libraries are displayed there. From there, I want to display the respective data in 2nd gallery.

thanks for the tuto, is it possible to do the same thinks but in PowerApps Portal ?

Hi Shane, great Video. Is there any way to rename the document without using a flow?

Hi @shane Young, I am struggling to connect my power app to an excel file data source, that resides in a folder inside a SharePoint document Library. When choosing data source, i can only connect to a list, but NOT a folder inside a document library. Any pointers would be appreciated.

Hey shane young, can you make a video where you work with loops trought table. For example if user selects number then it loops trought table/collect if collection contains number it should add +1 to result and loop again trought collection until there is no match. for example: ColNumberCOllection: Result 1 2 3 4 5 User selects number: 1 Loop starts Selected number changes to 6.

How do u suggest to clear and reset the variable back to "Shared Documents/", I am asking kindly cuz my variable shows "LibName/FolderName1/" initially, then when I re-run it shows "LibName/FolderName1/FolderName1/" Again runs: "LibName/FolderName1/FolderName1/FolderName1/" Pls help me out here.

First thanks for great videos. I have a question for you. If you have two screens and screen1 has Gallery1 connected to DataSource but it is with filter and AddColumns. (I added calculated columns to be able to display some status based on the data). Now If I want to do details screen and I try to use the Gallery1.Selected for item or your trick to use varRecord that was set it complains that Item is not valid. Is there any trick to edit details of the modified collection? Thanks for any tips.

Can there be a button in the gallery to download the document into the download folder instead of opening it then having to have it?

Excellent video, very helpful. Could something be done where you use this to choose a file and then attach it into a SharePoint Item ? - Just a thought

Hi, Shane. Great video. Could you help me on how to send an email with files attached using a Document Library gallery. Mi intention is to send the attachments of all documents shown on gallery after filtering it in an email. I havent been able to get the blob from the file in the library. I am trying to put it in a collection (name; contentbytes) and then use the Outlook365 connector. I would appreciate your help. Regards.

Hi Shane, is it possible to use cam scanner or scanner pro app to scan a document in pdf then attach to a record and email out?

Hi Shane, how can I get rid of the folder? All I want to be live is the actual files

Hello Shane, I have a document library created based in a Customized Content Type Document Set, I'm trying to build a Custom Form SharePoint for that, but I get always an error when I try to save it, the famous "Network Patch funtion", I think is it not possible to have a Customized form for this type of scenario?

hey @Shane, when i use result on the function you have provided for the back button, it throws me an error (Result isn't recognized) . I don't understand what i am doing wrong...

Thanks Shane

Shane, do you think Microsoft will change PowerApps at any point for uploading the files, as I know when you click on the + button you have to change the file type drop-down from image files to all files in order to upload say a PDF file.. ?

is there a way to add a feature that allows the user to save or "pin" favorite documents? or make available offline?

Hi Shane, How are you ? One way to win over the delegation would be to create a new column and make a flow that takes the path in that column

@shane Young - i have 9 documents Library List, one by one folder created, Example - AP>FY22>P01>China>LocalFile>Account Number>"Excel File" This way folder structure, can I able to access this document via Power Apps without any location Master Data? KIndly advice

Great! but not usable with the delegation problem 😕

@Shane Young if the URL of the SharePoint data source changes, will my PowerApp update eventually/sync after a crawl. Or do I need to physically remove and readd the data source?

Hi Shane, I am wondering if you could point me in the right direction. I love your videos. I am currently attempting to build a capabilities hub for my company. It would be a hub of all the teams and their capabilities with a search function for the capability you are looking for and then directs you to the correct team with their info. Have you got any videos that are somehow linked to this kind of thing? If not, it would be amazing if you could make one :) Keep up the good work!

Hi Shane, can you do a video on how to restore document library versions per item/documents. thank you in advance. keep it up im an avid follower now.

Having a very strange problem which is driving me crazy! I'm filtering my Documents library by Folder path but it is not showing me files, just folders! delegation is not an issue (root folder contains 613 documents and limit in PA set to 2000). I just cannot work out why it is not showing me the files present in the folders! HELP! example of my item filter for the gallery. Filter(LocalDoc,'Folder path'="Shared Documents/General/") there are both files and folders in the "General" folder yet only Folders show up in the gallery.

I have a sharepoint document libaraby with 3203 files, which can be accessible with power app, but if I add a new file to the sharepoint, it is not reflecting in power apps. Refreshing datasource / using clearcollect() did nothing.

Is there a way to force the Launch() to open a PowerPoint from a SharePoint document library in "Show"/"View" mode - when I use this command it opens the file in edit view? I've been searching for about two weeks. I'm trying to make an interactive help-file for the application. Even my Sway files open in edit mode instead of in play when using the Launch() function.

Hi Shane, do you have a video that shows how to surface SharePoint document library in a Power Apps Portal page, please?

What you can do with Libraries with more than 10.000 elements.?

Can access SharePoint Library in ForAll function?

For some reason in the Folder 'up arrow' function, 'Result' doesn't work, but 'Value' does.

Hi Shane, great videos! I’m trying to duplicate this and the back button doesn’t seem to like “Result” in the function, has an update changed how this works? Referring to: Set(varFolderPath, Concat(FirstN(Split(varFolderPath, “/“, CountRows(Split(varFolderPath, “/“))-2), Result, “/“) & “/“)) Hope you respond 👍🏻

Hi Shane...I just connected sharepoint folders to powerapps but some of folders are missing. I checked the folders which are not showed up in powerapps but I checked the sharepoint folders and the folders are right there in sharepoint folder....and the folders even don't have lots of subfolder or files in it. Could you please help?

hello. I have a problem. I perform all the steps in the video and when I try the app, when I enter a folder, it enters it but the content inside or the subfolders do not appear. I can't find the error

Hello, thanks for these explanations. Quick comment: in different PA regional settings (German speaking areas in this case) the "Thumbnail" does not exist, but "Miniature" instead. & Question: I believe you briefly mentioned it in this video and I searched the internet, various forums etc excessively and basically think this to be the sad reality, but just in case, I ask anyway: There is indeed no way of creating a button or whatever to simply "open" a Word or Excel or PDF File in the desktop version, or is there? Ideally, a Word TEMPLATE. Just open, so when the user is done with PA, s/he could continue with the Word File. Sounds simple, but apparently I already found the limits of Power Apps:-)

Hi Shane, Love your videos. Watched your video where you confessed to deleting 78,000 items at clients' SP and 3 hours later we investigated same issue. Can't help myself but laugh while solving the mystery of disappeared file :). [ Recycle bin to the rescue! - Shane Young ] Now - can you to create a video on how to view existing pdf file in PowerApps - scenario is when you have to approve invoice (which is pdf file) in Approvals PowerApp.