Power Apps SharePoint Document Library Browser
HTML-код
- Опубликовано: 14 мар 2021
- 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.PowerApps911.com Наука
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!!
"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. 😹
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!
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!
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!
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! 🐶
Sir, you are a freaking legend. Long live the king of Powerapptopia
You are very kind Mark. Thanks 😎
This video is exactly what I needed.
Thank you!
You're so welcome!
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!
Hey thanks Shane the Launch() function was what I have been looking for!
Awesome. Glad to help. 😀
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.
Love the coding for the up arrow. Brilliant!
Glad to hear it! 🐶
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?
Awesome Shane !!, thanks for all these tips
My pleasure!
Hi Shane - love your vids, very well done and informative. Giddyup
Thanks 👍
Dude, you run very well!
Great video.
Thanks
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 :)
Hello from Brazil !!!
Thank you very much. Your explanation is great and simple.
Thanks and welcome
@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🤣🤣
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
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.
@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 gooood job!! Thanks Shane!
You are welcome 👍
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?
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?
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?
Thank you Shane. Great video.
My pleasure!
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?
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
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 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
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!
Excellent video! Thank you very much!
Glad it helped!
Great video again. So thanks!
My pleasure!
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
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.
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?
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
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, 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.
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... :(
Hi Shane, how can I get rid of the folder? All I want to be live is the actual files
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.
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.
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. 😍
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, 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. 😑
Death Taxes & Delegation are the most important things in Life.
Carved that on my wall!
Love it 🤩
Good job, Sir!
Thank you kindly!
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?
Can access SharePoint Library in ForAll function?
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.
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
What you can do with Libraries with more than 10.000 elements.?
Tried to set up Set varFolderPath, to my shared but gallery dissapears , and dont know why ;(
Help! 'Link to Item' doesnt appear to be a valid control anymore!
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?
For some reason in the Folder 'up arrow' function, 'Result' doesn't work, but 'Value' does.
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 ruclips.net/video/e0kMjb686tc/видео.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 ruclips.net/video/olJWU756tl0/видео.html
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.
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.
Excelent, thanks!
You're welcome!
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.
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.
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.
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 😠
Hi again! So, I got this functioning, including the deep linking a while back **cheers**, but I'm fumbling around with a new search box for the filtered gallery. Is this possible? I got the fx to not have any errors (lol), but when I type in my search box inside a folder, it takes me back to the folder list, instead of to the document I'm referencing within the folder. How do I get it to locate a document at the second level? This is what I have so far...
If(!IsBlank(TextInput1_1), SortByColumns(Filter('Sharepoint Doc Gallery', 'REF Number' = Value(TextInput1_1.Text)),"REFNumber", Descending), Sort(Filter('Sharepoint Doc Gallery', 'Folder path' = varfolderpath2), Name, Ascending))
Thank you in advance for any guidance :)
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, 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, "/") & "/")
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. ruclips.net/video/2gE0e_AsdMw/видео.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!
Hi Shane, great Video. Is there any way to rename the document without using a flow?
Not that I know of but never tried.
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. ruclips.net/video/_NCLeRpot3k/видео.html
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 ?
Thanks for useful content. Is it possible do the same thing with File System Connector?
I have never tried, sorry.
👍👍 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
ruclips.net/video/2gE0e_AsdMw/видео.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,...
Brilliant!
Thanks 😊
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.
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!
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?
I don’t know. Sorry
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 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??
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.. ?
Chris not if you use an attachment control instead of add media. ruclips.net/video/Pa-pYEkLH-U/видео.html
@@ShanesCows Ill have to give that a go! 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."
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.
This is what happens in one case: Invalid formula. Expected value compatible with datasource
I think I found solution: Set(varSelectedItemID, ThisItem.ID) and on another screen use DataSource from SP and set Item as LookUp by that ID. I tried First + Filter before which is not good
@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 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.
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
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 ruclips.net/video/oKJkVx2gehw/видео.html and Row numbers ruclips.net/video/Uuolue31t5o/видео.html . I do think it is possible.
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
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
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 can't find 'Folder path' has it been relegated?
Great! but not usable with the delegation problem 😕
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 ruclips.net/video/2FQoTp6RXwc/видео.html
Other than that I have not ran into issues with folders not showing up.
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.
I have never tried. Go to the library, open the file in view mode. Grab the url and put it into Launch. Does that work? If so now try to make the url dynamic
@@ShanesCows Thank you for taking the time to answer my question.
I've tried that, suggested in the PowerApps forums; however, the file is still opening in edit mode. I may have to resort to either a MS-Sway (not as friendly as one would think - but that maybe my lack of experience with the app) or an embedded link in a web-part within a SharePoint page which isn't ideal but maybe the work around.
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? ruclips.net/video/UaBmVUQx_Fk/видео.html
@@ShanesCows thank you, the issue was the flow used for setting values, which is then filtered to avoid delegation warnings.
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 👍🏻
Ignore me, helps if I write down the function correctly 🤦♂️
Thanks Shane
Anytime Sundra 😊
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.