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.
@@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 :)
@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!
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.
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 😉
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
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...
@@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!
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?
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?
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.
👍👍 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?
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 ua-cam.com/video/olJWU756tl0/v-deo.html
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.
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.
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.
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 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?
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.
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
@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
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 ua-cam.com/video/2FQoTp6RXwc/v-deo.html Other than that I have not ran into issues with folders not showing up.
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.
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
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.
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?
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... :(
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?
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!
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.
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.
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
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.
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.
@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?
@@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?
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.
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
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?
@@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.
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. ua-cam.com/video/2gE0e_AsdMw/v-deo.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!
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.
@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🤣🤣
@@ShanesCows Thanks for saving me an hour of my life hehe. Darn you delagation! I will maybe break up the library and try that. When there is a will there is a way.
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, 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?
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.
@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
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.
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.
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.. ?
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
"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. 😹
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!
Sir, you are a freaking legend. Long live the king of Powerapptopia
You are very kind Mark. Thanks 😎
@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!
Shane been following for years, thank you for the hard work
This is pretty awesome Shane. Lots of fun techniques and tips to manage stuff with Visible and vars. Love it! Thank you 😊
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! 🐶
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!
Hey thanks Shane the Launch() function was what I have been looking for!
Awesome. Glad to help. 😀
Love the coding for the up arrow. Brilliant!
Glad to hear it! 🐶
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!
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!
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.
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 :)
Dude, you run very well!
Great video.
Thanks
Hello from Brazil !!!
Thank you very much. Your explanation is great and simple.
Thanks and welcome
Hi Shane - love your vids, very well done and informative. Giddyup
Thanks 👍
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, "/") & "/")
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
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!
Awesome Shane !!, thanks for all these tips
My pleasure!
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
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 ua-cam.com/video/cjcDH7_v6cE/v-deo.html 😎
@@ShanesCows tyvm, implemented and works like a charm. great stuff.
Very gooood job!! Thanks Shane!
You are welcome 👍
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?
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.
👍👍 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
ua-cam.com/video/2gE0e_AsdMw/v-deo.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,...
Death Taxes & Delegation are the most important things in Life.
Carved that on my wall!
Love it 🤩
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?
Thanks for useful content. Is it possible do the same thing with File System Connector?
I have never tried, sorry.
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.
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 ua-cam.com/video/olJWU756tl0/v-deo.html
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. ua-cam.com/video/_NCLeRpot3k/v-deo.html
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.
Thank you Shane. Great video.
My pleasure!
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 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.
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.
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..
Excellent video! Thank you very much!
Glad it helped!
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 again. So thanks!
My pleasure!
If I have two document libraries, can I set the "OnStart" to two folder paths?
You could have two variables. But then you probably need two galleries to show the different folders.
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 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.
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
Help! 'Link to Item' doesnt appear to be a valid control anymore!
@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
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 ua-cam.com/video/2FQoTp6RXwc/v-deo.html
Other than that I have not ran into issues with folders not showing up.
Hi Shane, great Video. Is there any way to rename the document without using a flow?
Not that I know of but never tried.
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.
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, how can I get rid of the folder? All I want to be live is the actual files
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.
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.
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 ua-cam.com/video/e0kMjb686tc/v-deo.html
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... :(
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.
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
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?
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. 😍
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.
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.
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
For some reason in the Folder 'up arrow' function, 'Result' doesn't work, but 'Value' does.
please could you share the link to the upload document video
ua-cam.com/video/3QaiM8SeWfM/v-deo.html
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.
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.
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 there be a button in the gallery to download the document into the download folder instead of opening it then having to have it?
Tried to set up Set varFolderPath, to my shared but gallery dissapears , and dont know why ;(
@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?
What you can do with Libraries with more than 10.000 elements.?
What does "Result" store?
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? ua-cam.com/video/UaBmVUQx_Fk/v-deo.html
@@ShanesCows thank you, the issue was the flow used for setting values, which is then filtered to avoid delegation warnings.
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
Great! but not usable with the delegation problem 😕
Can access SharePoint Library in ForAll function?
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,
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!!
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. ua-cam.com/video/2gE0e_AsdMw/v-deo.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 it always must be from SharePoint documents library?
Sorry, I don't understand the question. Power Apps works with all SharePoint list types.
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.
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. 😉
@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, 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
Can you get around the delegation limits with pagination in this case or is that a waste of time? GTP just suggested it to me.
Not that I know of, non-delegation is mostly undeafted. 🥴
@@ShanesCows Thanks for saving me an hour of my life hehe. Darn you delagation! I will maybe break up the library and try that. When there is a will there is a way.
@@ShanesCows New doc library done. Flow in place to move data once every 6 months. That works for me. ty again.
Excelent, thanks!
You're welcome!
Good job, Sir!
Thank you kindly!
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, 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.
@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.
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, 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. ua-cam.com/video/Pa-pYEkLH-U/v-deo.html
@@ShanesCows Ill have to give that a go! Thanks :)
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