Power Apps SharePoint Document Library Browser
ฝัง
- เผยแพร่เมื่อ 20 ก.ย. 2024
- If you want to work with SharePoint Document Libraries, then this is the video for you. File thumbnails, IsFolder, Filtering, Navigating, Upload, and Deleting are all covered in an awesome Mobile app demo. So much fun! 🥳
Power Apps Consulting and training at www.PowerApps9...
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.
Yeah, sorry, they changed from Result to Value a few months ago. 🫤 Glad you figured it out.
Thank you, you save me.
@@angelrubenvazquezrivera5971 Thank you for pointing this out.
@ShaneCows, maybe consider adding this as a note to the description for those that don't always see or go through comments :)
Thanks Sir!!
@@ShanesCows i can only get this to work with folders, it wont display any files!!!! HELP!
"In life, death, taxes, and delegation are the most important things." - Shane Young
Now one of my favorite quotes.
Came up with it in moment and it cracked me up. 😹
Sir, you are a freaking legend. Long live the king of Powerapptopia
You are very kind Mark. Thanks 😎
Love the videos. One problem, "Result" in the up arrow does not work for me. It is not recognized.
Try Value instead of Result. The formula creates a table with one column and the column name is Value. Success?
This video is exactly what I needed.
Thank you!
You're so welcome!
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!
Fantastic Josh!
@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 😉
Happy to help Gary. Have a great day!
This is pretty awesome Shane. Lots of fun techniques and tips to manage stuff with Visible and vars. Love it! Thank you 😊
Hey thanks Shane the Launch() function was what I have been looking for!
Awesome. Glad to help. 😀
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
Congrats Cory! I need to take that exam myself.
Great video, the step by step instructions really helped! Thank you
Happy to help :)
Love the coding for the up arrow. Brilliant!
Glad to hear it! 🐶
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.
Fantastic! 🐶
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 :-)
Awesome! That is always my hope by sprinkling in the little things.
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
Glad it was helpful!
Dude, you run very well!
Great video.
Thanks
Hello from Brazil !!!
Thank you very much. Your explanation is great and simple.
Thanks and welcome
This reminds me so much of FileMaker. I used it way back around 2011? It was a database application on Macs
I vaguley remember it. That was a while ago. :)
Yes. Yes it was! Wow. Time flies
Death Taxes & Delegation are the most important things in Life.
Carved that on my wall!
Love it 🤩
Excellent video! Thank you very much!
Glad it helped!
Very gooood job!! Thanks Shane!
You are welcome 👍
Hi Shane - love your vids, very well done and informative. Giddyup
Thanks 👍
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.
All of the pieces are here. Use this video to find the folder you want. Then pass that folder path to the flow as shown in the other video you referenced.
@@ShanesCows Oh right! Thank you very much Shane! I've learned a lot through your videos, you're awesome!
Great video again. So thanks!
My pleasure!
Shane you demo the Upload feature in the beginning but never shared how you implemented that. Are there follow up videos to this one?
Here is a link to the updated upload video th-cam.com/video/cjcDH7_v6cE/w-d-xo.html 😎
@@ShanesCows tyvm, implemented and works like a charm. great stuff.
Have you done a video on how to access a document's version history from a Power Apps gallery?
I have not, and I have never had to do it so not sure I have anything in my head for this one. I know it is possible via the SharePoint HTTP action and REST API but that is far as my brain goes.
@@ShanesCows Thanks. I actually found a way to do it! th-cam.com/video/X-hFMMKuPsM/w-d-xo.html starting at 17:16
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...
Change Result to Value.
Set(varFolderPath, Concat(FirstN(Split(varFolderPath, "/"), CountRows(Split(varFolderPath, "/"))-2), Value, "/") & "/")
Thank you Shane. Great video.
My pleasure!
👍👍 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
th-cam.com/video/2gE0e_AsdMw/w-d-xo.html This video. I did it talking about Teams but it is the same for SharePoint. :)
@@ShanesCows Thank you so much Shane , Both combined contents solved my requirement. You deserve my paycheck this time 😊, Now working on metadata,...
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.
Tyler if you have a gallery and use the Thumbnail.Large do you not see the images? That is so weird.
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?
A great video, alone I would never have succeeded! Very useful for me, thanks for the help!
You're welcome!
@@ShanesCows This mode applies up to 2000 raws. With larger lists of file/folder I think I should create a collection via power automate because 'folder path' cannot be delegated. But I don't know how to do it!
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 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.
Glad you found a work around :)
Can you tell me the formula you have used to do this ?
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?
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..
Thanks for useful content. Is it possible do the same thing with File System Connector?
I have never tried, sorry.
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!
I am pretty sure you can download the working app. 😍
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?
Yes. I show in this video filtering to a folder. Then you could add search nested around that filter
Good job, Sir!
Thank you kindly!
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
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?
Probably. I didn't go any further down this rabbit hole but I am sure there is some more creativity to be had.
For some reason in the Folder 'up arrow' function, 'Result' doesn't work, but 'Value' does.
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.
It is not possible. If you want to connect to Excel then the file has to be hosted in OneDrive for Business.
Soooo helpful. Thanks so much for this. Is there a way of adding a sort (sorry very new to this)
This video should help Beth. th-cam.com/video/_NCLeRpot3k/w-d-xo.html
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
I haven't tried but I think yes. I show you how to use a variable to navigate in the video. So set variable when the app opens. Kind of like we do deep linking th-cam.com/video/olJWU756tl0/w-d-xo.html
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?
Could it be a Delegation issue? Do your library, as a whole, have lots of items?
More on Delegation here th-cam.com/video/2FQoTp6RXwc/w-d-xo.html
Other than that I have not ran into issues with folders not showing up.
Awesome Shane !!, thanks for all these tips
My pleasure!
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
I like it
@Altino Fernandes: Sorry, I'm a noob... can you explain more? I'm intrigued...
@@melissaburwell3378 Original sharepoint columns are not delegable in Power Automate. If you create a new column, it will be delegable. Create a column, just like we do in the list.
@@altino91255268 thanks!!
I'm actually reposting someone elses question because i have the same problem.
"Cannot see the pdf files and also want to add a search option, how can I do that? Thanks in advance."
Excelent, thanks!
You're welcome!
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.
Brilliant!
Thanks 😊
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.
I have never used a + so not sure how that would work.
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.
Lukas I haven't done that before. I would check out my videos on Sequence th-cam.com/video/oKJkVx2gehw/w-d-xo.html and Row numbers th-cam.com/video/Uuolue31t5o/w-d-xo.html . I do think it is possible.
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
Gabriel - Is it possible your document library has more files than the delegation limit? If so, that would explain you not getting results.
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?
It has a file column type but I haven’t used it for a real customer app. So I am not sure how well it does or doesn’t work. 😑
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.
That should be how your browser is configured and the url your are Passing to it.
Love your videos Shane. Followed this right the way through and it all worked right up until 'Result' searched n cant really find out much about 'Result' function. its no longer available in settings/experimental to enable. any one able to assist?
Robin what is the time stamp I show where you are struggling? I will try to look tomorrow
@@ShanesCows Hi Shane. 18:47. Result function throws an error. any help would be greatly appreciated.
@@robshields76 Got it. They changed Result to Value 😐😐
@@ShanesCows ah I see. Will try it in the morning. Thanks a lot for the help.
Bonjour,
j'aimerais faire le même type de navigation mais ma galerie est utilisée pour plusieurs bibliothèques de documents que j'appelle via une variable. Comment puis-je procéder ?
Merci
For the Gallery Items property you will need to have an If statement. If(variable = "Dogs", DogTable, variable="Cats", CatTable, etc....
You cannot use a variable as the data source directly.
thanks for the tuto, is it possible to do the same thinks but in PowerApps Portal ?
Not sure if it is possible but if it is then it would not be easy. :( You would most likely have to figure out how to call the SharePoint rest api.
Tried to set up Set varFolderPath, to my shared but gallery dissapears , and dont know why ;(
I can't get the previous button to work at all. I'm not sure what i'm doing wrong.
It should be setting the variable with the shorter path. Try showing the variable in a label on the screen so when you click back you can see what is happening.
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.
If it is a complex column type then it will be a record. ColumnName. Should show you the possible values.
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.
I have never done it. If I end up doing it I will make a video for sure.
So Document Libraries with Ks of Docs are lost? Really bad news. Great Vid anyway. I can recommend the Shane's Curated Library!
Thanks Toni. Delegation on folders is dumb for sure.
@@ShanesCows I wish more content regarding Document Libraries. That's my personal everyday business. I handle ks of Docs and use the content type features. But how in PowerApps? That's my topic.
Hi Shane, do you have a video that shows how to surface SharePoint document library in a Power Apps Portal page, please?
I don't. I do not do much with portals. 😐
@@ShanesCows Oh~~ Thank you for your reply. 😉
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
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.
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,
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?
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.
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
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?
This is as close as I have been th-cam.com/video/e0kMjb686tc/w-d-xo.html
Cannot see the pdf files and also want to add a search option, how can I do that? Thanks in advance.
i can see SOME PDF's but not all. I hope you get a reply to this. I'll be keeping an eye.
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.
Do you maybe have a delegation issue? th-cam.com/video/UaBmVUQx_Fk/w-d-xo.html
@@ShanesCows thank you, the issue was the flow used for setting values, which is then filtered to avoid delegation warnings.
Hi Shane, how can I get rid of the folder? All I want to be live is the actual files
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?
Hi Shane,
Taking my baby steps with PowerApp. Decided to do something files/documents. Ended up watching your video. Helps me a lot.
Thing that troubles me is that I have to something like:
If(ThisItem.'{IsFolder}','dossier-147590_640.png', thisitem.'{Thumbnail}'.Small)
Where you do
If(ThisItem.IsFolder,'dossier-147590_640.png', thisitem.Thumbnail.Small)
Where do the curlies come from?
But neither of them seem to work for me
Anyway... thanks for the video
Peter
@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
Help! 'Link to Item' doesnt appear to be a valid control anymore!
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, great Video. Is there any way to rename the document without using a flow?
Not that I know of but never tried.
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!
I don’t have anything like this but will add it to my list to ponder
Hi Shane, Im pretty sure i asked this in another video but i haven't got a response yet and im not sure if its even possible since there is no clear answer on this.
Can you upload images or files to document library that you specify in the PowerApps, i want to be able to select a folder or folder name and then tell it to upload my images to that folder in Sharepoint. Is this possible.
Kind Regards
This video th-cam.com/video/2gE0e_AsdMw/w-d-xo.html
@@ShanesCows You're gonna make me cry, I skipped this video previously thinking it won't be what i wanted. You are the only go to Power Platform MVP in my Books, Keep doing your awesome work.
Great! but not usable with the delegation problem 😕
is it always must be from SharePoint documents library?
Sorry, I don't understand the question. Power Apps works with all SharePoint list types.
What you can do with Libraries with more than 10.000 elements.?
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?
Yes, but the Collect function isn't delegable so it would only be grabbing the first 500 records also.
You can use Flow to get only one folder content returned with a SharePoint HTTP Request. Easy with Response (premium license!), less easy without as then you need to use ForAll and Splits to convert the return string to a table. But it can be done. Not sure how to get the thumbnails yet, but if I figure it out, I'll make a post of a flow variant of this example.
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
Yes. Two options. One grab the Link and add it to a HyperLink column in SharePoint item. That way you don't move the file you just link to it. Two: Send the base64 to flow and have Flow add attachment to a list item.
@@ShanesCows Thank you
@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
@shane Young any update or its not doable in power apps??
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.
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... :(
@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?
Physically change the app. Sorry
@@ShanesCows Thank you. We were able to delete the SharePoint data source in PowerApps, then immediately re-add it and then everything reconnected. However; one of our developers had hard coded one path within the app, and for that we were able to do a find and replace. The associate workflows were not so forgiving though... and those we had to remap every single SharePoint connection. 🙄
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?
@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🤣🤣
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!
This video should help. I talk about Teams but it is 100% the same for SharePoint and I show that also I think. th-cam.com/video/2gE0e_AsdMw/w-d-xo.html
@@ShanesCows Thanks, I'll check it out. I watched some of your other videos around libraries but haven't crossed this one, the title didn't stick out to me. Thanks again for your efforts!
is there a way to add a feature that allows the user to save or "pin" favorite documents? or make available offline?
You would have to track that in another list and connect the dots. I did it one of my videos… which one…if I remember I will add another comment. Hmmm
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.