I got almost everything to work in the first video. I then learned more from this one. It’s all working so well with the exception of getting PDF files to render in the PDF Viewer as prescribed. The office documents convert nicely. It’s strange because I do trigger and capture the link (text label) after adding the hyperlink column. I can’t figure out what is going wrong. But everything else works… thanks for all your coaching mate!
You are most welcome! I have not come across the mentioned issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you Reza. I have learnt so much by watching your videos. For me , you are the go to person for all things related to PowerApps and Flow. Again thanks for the work you are doing and sharing with all of us.
Thanks for this! I will try to implement this in my project. Libraries and files are always the most important thing and I believe users will like a lot the powerapp experience!
Anothtaa one! Again--to help keep things in a one stop place rather than going from app to sharepoint and back and forth, this will help keep things in one place!
Thanks Rezza! You’ve helped me so much with my project. I ran into one issue when making the pdf viewer visible only when certain document types were selected and had to adjust the Visible control where instead of using “).Result “ I used “).Value” And it worked for me! (Without the “”) Hopefully that might help someone else too. Thanks again!!
Thanks Reza.. I have also created similar kind of app in one of my project and implemented the same. I used document set. Through this video I have learnt breadcrumbs and delegation.. Thanks again.
Nice tutorial even 2 years later!! Thanks Reza for all ,this helped implement our companies doc libraries and it is functioning perfectly.The only issue i have with this is if user double clicks on a folder.The variable is then messed up and shows no results
Eye opening!! I developed something similar but your is more friendly user, thanks for the information Reza!! I'll definitely be improving my SharePoint list in Powerapps!! 👏
Hey Reza, You have made my life possible, if I was not able to watch your videos and learn how to do these I would have never found interest in Power Platform, you made it very easy for me to learn. Wanted to thank you from the bottom of my heart for these. Also wondered if not answered before, what if users move files from one folder to another, the default rule Doesnt apply to them, anyway to push it with Power Automate or something of that sort? Thank you
Thank You for watching and learning from the videos. I hope to keep producing quality content. If files are moved, then flow would be the way to check its details and accordingly set the value. I do not have any video reference on this though.
Hi Reza . Its a great tutorial.. Thanks for this. Meanwhile my documents library has more than 2000 items. Its loading only 2000 at 'Documents' collection which is been directly connected to SharePoint.
Great idea Reza, and certainly the most elegant approach in a static folder case. As far as I can see, it is not applicable when new folders and folder renames can occur (Q1: please correct me if I missinterpret). In those cases, a flow would cover that and your use of defaults would improve my current solution for that greatly. I cannot find a rest call to set the folder defaults though. Q2: do you know if that is implemented (on premises it is, but it looks like online it isn't). And a change would be to build/store delimited folder id's instead of the names like 6/12/34/ instead of shared documents/Asia/India/ to cover renaming (or make a complex flow to propagate that down the tree). As always, great video and thanks!
All great points! For a static folder case, this will work. If folders are renamed or files are moved, then it would require updating existing data. I don't think there is a REST Call for folder default values. This feature never got any love. Naming folders with IDs is a good idea as well.
I know this is a year later and I know that this was about not using Power Automate, but there is an UPdate Filter Properties in Power Automate to update both the hidden columns that Reza created. I can create a folder in Power Automate and update the properties to the hidden folder path. I pass parameters from Power Apps with the folder path I want to update. Works perfect. :)
@@davidakridge2831 Hi David! I was wondering how this is done as I am trying to do the same. I'm very new to Flow and PowerAutomate so any advice would be greaty appreciated!
Hey Reza! Thank you so much for this tutorial video which helps me a lot! I am encountering an issue when setting up the varCurrentPath. I have a few screens in the APP, and the document library is not the first screen. Would this be the reason why when I go back to the document library screen, the varCurrentPath is blank after I implemented Set(varCurrentPath, "Shared Documents/") in App > OnStart ? Looking forward to your guidance! Thank you in advance.
varCurrentPath is a variable. It should have a value if set. You may be editing your app, if so then ensure you run app onstart. You can right click the app object in app and run it.
HI Reza, Great Video. I implemented the same in my application and working fine. But need small requirement like when ever you are selecting one file to another file in the gallery and size of the file is large it is taking sometime to load. So, I want to hide the PDF viewer control while the other document is loading or clear the content of pdf viewer till the other selected document is loaded. Thanks.
Thank you very much. I want to create the folder with the user name and surname before the document upload and make it into this folder, how can I do this.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hello Reza. I highly appreciated your tutorials, thanks to them I completed an one app and now I am starting a new app with another functionality. I succeeded to organize library viewer as you showed in video, however, I have one question. The situation is: I have Sharepoint list with different column, name column in list matches with the name column in library. How can I connect the list and library so that when you click on gallery with item property Sharepoint list, the certain library folder with common name will be opened. Hope, you are getting me well.
I am understanding the requirement, but I do not have a video reference on this scenario and would have to try it out to provide guidance. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Great tutorial, thanks Reza. Just one question, the galley in your tutorial shows folders first and then files, it looks like this is because the ID happens to be in that order. Is there a way to sort the gallery to always show folders first and then files or would you need to essentially create 2 galleries to do that?
Its been a while since I did this video. From what I remember, the gallery shows all folders and files to start with at root level of library. You could try and use the sort function to sort by name of if it is a folder.
Hi Reza, this was a great video and helped make a great starting point for one of my apps. The only question i have been asked since deploying it was, is there a way to limit the amount of folders that return? For larger libraries with many folders, id like tp show at the most 4 folders. Thanks your help!!!!
Thanks for watching and liking the video. For limiting to a set of folders, you could check the level of the folder (by checking the path - number of / or so) and filter out data accordingly.
Wow, great video, thanks for your help... Maybe you can help me with something else; The filter works for me with the first level of folders, but if there is another folder within those, they do not appear in the view. What could it be?
I will have to look at your App in action to provide guidance. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hello Reza, I have a problem viewing documents within a library folder with the following path: DDR/215/Further Documentation. While in DDR and 215 the documents are visible. Nothing is seen in further documentation. Are there any limits? Could you help me. I thank you in advance.
I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
This is great! I'm working on a solution where the folders are getting created in a Power Automate Flow from a new item in a list. Is there a way to set up the hiddenFolderPath column without setting the value in the default content value section in the library settings? I'm guessing I could do this in the Flow.
Thanks for this wonderful tutorial! Can you please help me with a query, How do you access the file in the Image control? I had a specific criteria in my project where I needed to show the image in a gallery where the items are from different source. So to get that file in control i had to use 'File name with extension' = ThisItem.No & ".jpg", is there an alternative to avoid delegation in this case? Apologies if it is a basic thing, am quite new to powerapps.
Great video Reza. Thank you so much . I am working on a project where I need a similar app (preferably in a custom page) and would like to attach the selected document and send an email to a person. Is it possible from your app ? Bets regards Youcef
Is there a way to have a drop-down that shows all the libraries available on sharepoint and allows the user to select which library they want to upload/edit files in?
Probably possible using graph api or calling flow to get list of libraries from site. I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza, thanks for the video I copied every step in the process, however my 'OnSelect' to open the folder doesn't work! Do you know the reason why potentially? I even tried adding a button and copying the same code in but it doesn't work :( Its' been doing my head in for 2 days now and honestly im so frustrated
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Hi Reza, again an awesome video with great details ❤️, could you also tell if the new columns we have created for folder path will have any camouflage delegation issue for doc lib with many records (for ex 50k)
@@RezaDorrani camouflaged delegation is the one which you showed for the case of using With function in your other video, if I create a new column having value same of that of the folder path the delegation goes away right, it will work properly for large items (50k records) as well right ?
@@samratguha8933 Yes but it has nothing to do with 50k Delegation means 2k limit max. As long as function is delegable, it will work with large data. For SharePoint lists and libraries, there is concept of column indexing which you should look into.
Thank you for this tutorial. How can i populate the hiddenFolderPath and hiddenIsFolder columns programmatically if I already have a folder structure of more that 4000 files? I guess the only way would be to use a Power Automate flow, or am I missing something? Another thing: if I create a new folder, the Default value of hiddenFolderPath will be populated correctly, but what happens if I create new files/folders inside the new folder? Is there a way to automate the default value of the hiddenFolderPath of new folders?
Thank you very much for you great videos!!! You are the best :) I wanted to ask if there is a way to get access to folders count column in the sharepoint view within the power app form?
I'm not sure if that shows up in Power Apps. Power Apps does not understand SharePoint views. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza, thank you very much for the video, I'm just creating an app to view and manage documentation, the difference is that the folders are created directly when uploading a document, to maintain the structure I have used the shareponit option "copy folder" and " send http to sharepoint" and another to rename and move the folder I created. The problem is that I can't update the metadata part automatically (min 15:40 of the video) I have searched many options to make this change, almost all of them use an HTTP send to sharepoint, but so far I haven't been able to do it. Do you have a video explaining how to change this metadata automatically? Thank you very much for your help and for everything I have learned thanks to you.
Thanks. I do not have a specific video showing updating metadata part dynamically. I would recommend to post your issue with screenshots on the forums at powerusers.microsoft.com
The hiddenIsFolder column, created in sharepoint library is not recognized in PowerApps even though I have followed the steps in setting up the column,
I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza. If I making any updates to the documents in the sharepoint library. I am not able to see the updated version in the pdf viewer. How can I fix this?
It gets cached and will get cleared in some time. I believe there is a parameter that you can pass that clears the cache, but I do not remember what it was.
Hi, has anyone else come across the situation where only folders show up when filtering. If no filter, I get everything. If I filter for isfolder=false, I get nothing. If I filter for isfolder=true, I get the folders. Yes, there are files present. I can't figure it out.
Hi Reza, I have a document library that consist of 4000 items. It takes lot of time to load the content in the gallery. Is there anyway i can speed up the process. ? Collect and clear collect are non delegable.
A gallery would only load 100 items in memory is delegation is being respected. I would not recommend loading 4000 items in a collection. It will cause performance issues.
Thx for this great follow up video. Is there a way to dynamically set the folder path? (The Malaysia/India part in SharePoint - or perhaps in Dataverse.) Ideally the case I am aiming for is for every item to be inserted into a folder with an ID number assigned to match the value of master record from another list.
hello. I have a problem. I perform all the steps in the video and when I try the app, when I enter a folder, it enters it but the content inside or the subfolders do not appear. I can't find the error
Hello Reza, I am building an app where I want to store file uploads in Sharepoint Documents Library instead of the lists. Please point me to any of your videos that can help.Thank you.
How about showing the folder as per access to the logged in user access? Will it show every folder without considering the access or it will show only those folder as per the logged in user access like how it behaves in SPO document library? Please let me know. Thanks, Vikram
Can I ask irrelative question: how can I use two triggers in power automate , I need to trigger my flow using sharePoint triggers: when a file is created in a folder and when a file is created( properties only).
Hi Reza, Having an issue - it's not displaying the folder but have set the hiddenFolderPath values as same the folder name based upon the video. But it's only showing the files from the root folder, no directory. Also the hiddenIsFolder value is set to No. What Im doing wrong here? Also I don't see anywhere the hiddenIsFolder is used - is that correct? Do I need to do some code changes?? Any response is highly appreciated.
Video description has link to download sample App. As for your issue, I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani thx for the Link to the Video that I completed succesufuly, you are a top UA-camr btw. When I upload any file using method in the above mentioned-video, that same file wont be rendered in this app you are showing in this part2 Video. It shows "Hmm looks like this file doesn't have a preview we can show you" or "ERROR MSG: " PDF.js v1.9.426 (build: 2558a58d)" - Does it happen to you? but if you upload any file directly on SP in any browser, it will be perfectly rendered
@@carajter07 Oh. This is something I will have to try out and test. Are you getting this issue only in PDF? I will also recommend you post this issue with screenshots on the forums at powerusers.microsoft.com/
@@RezaDorrani hi Reza , you should get this "no preview " render-issue with any file type. I have tried many Flows to upload a file to SP . The frustration is huge. Does it happen to you as well? may because it is "experimental"
Thanks Reza!!!! Excellent video. I am working on a project that involve email attachment. Do you have any video covering uploading documents received in an email to a SQL table. Thanks Mariena
Thanks for watching and liking the video. I do not have any video reference for uploading docs from email to sql. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
I need to confirm if i want to show only files i'd set IsFolder=false but there's delegation so if I'll do this allow management of content types like that trick you did, will all the existing file be deleted? or those will just pick the default of that column to 'No'? Please tell me I am in a big problem
Hello Reza. Thank you very much for your video (all videos), I (we) really appreciate it. I really like this implementation, however, what about existing libraries, with many folders (our document library has over 7000 documents and more than 150 folders. How can I possibly set the defaults for all existing files and folders? Thank you in advance for your prompt reply. Michael.
Another fantastic video! I would love to allow my users to select and download multiple files. How might you/ this community approach adding such functionality to the experience demonstrated in this video??
Downloading multiple files is something I have not investigated on. There is no out of the box action. I will recommend you check on the forums at powerusers.microsoft.com/ in case someone has a workaround.
Awesome work, Reza. Thanks for all this great info. Is there a way we can do a similar kind of selection for video files whether it is MS Streams Videos or Video file from Sharepoint?
@@RezaDorrani Got it! I tried the MS Streams. I am interested to check if we can create something similar to your previous Document Viewer tutorial but for the video files. Very helpful videos btw. Thanks!
Hello Reza, is it possible to have an option to select a different document library? Lets say we have 4 different sites with Document Library's that we want to use with this App, how would you best add this feature into your App?
Hello Reza. Is it possible to add a search to this app? I have created the entire app, however I am at a loss in where to place the search function for the gallery. Any help or direction would be greatly appreciated!! By the way...excellent tutorial.
I'm having 2 doubts... 1st - pdf quality is degrading 2nd - After going back to previous screen if I again open pdf viewer it should reset to root folder..
@@AshutoshDubeyCivil 1- There is an option to get higher quality. You would need to read more about the api that generates pdf to know which param it needs to get that. 2- You would need to update the code accordingly. Its been a while since I did this video, hence do not recollect the code.
I will have to try it out myself to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Hey Reza, how can we download from documents or folders from SharePoint using PowerApps? I tried different approach but it's just opening the folder not letting us download? Any solution we be appreciated
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hello Reza ! Great video. Im trying to implement the "Set(varFolderPath; "Shared Documents/" on the start screen but power app doesent seem to recognize this function.. Any idea ?
Its a simple variable set function in power apps and should work. I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Sadly I can't seem to make it work. I would gladly ask support :) Will post in forum ID environnement Default-f4a12867-922d-4b9d-bb85-9ee7898512a0
Hi Rezna, thanks for this really interesting video. Is there a way to browse sharepoint document libraries from different sites without first making a data connection? For example if you have a sharepoint site per project, each containing thir own documents? When using your technique, I would have to make hundrers of data connections...
@@RezaDorrani as I indeed expected :( but since I always needed the same 3 folders for attachments, I used Powerautomate at OnVisible to load the adresses into 'shortcuts'. As most of the time in Powerapps: working around obnoxiousnous :) Anyway thanks a lot for your immeasurable contributions!!!
That would have to be a separate video altogether. I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my UA-cam channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.
I will have to see your App in action to know why. I did not face any such issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Reza I just wanted to bring to your notice if the pdf file name with some special characters like "&", the pdf viewer is not working. Any quick tip for this issue..
Hi Reza, would like to inform you that, pdf viewer are respecting the user who has premium license. Currently I'm facing issue with pdf document when we use "appres://datasource" api. It's not showing the pdf files.. When we use premium account it works fine. But not working with normal users account. Tried all the possibilities. Please let us know your thoughts.
@@karukarthi2609 I will have to get back to this and evaluate it to the full extent. I have plenty of work planned this month. PDF viewer is a standard connector so premium should not be required.
Hi Reza, I hope you are doing great.!. Quick question related to PowerApps gallery control Items property. Is it possible to show two document library contents in one gallery control ??
Hi Reza, Need your help :) I have a document library that has 3000 files and i would like to create a document viewer app where a user can view the document from the app instead of going through folders. Few challenges i'm facing at the moment: 1. Able to collect only 2000 items. 2. ClearCollect takes time to collect 2000 items. (almost 5mins) 3. Pdf viewer also takes time to load the document. ( >1min) Thank you for your help in advance.
I have not worked on this scenario. I will have to try it out to provide any guidance. I will recommend you check on the forums at powerusers.microsoft.com/
Good day Reza, thank you for the wonderful work please I was able to do something with the video and the pdf was showing on the Laptop but could not render on the mobile phone
Check video description for link to download sample App. For your issue, I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani thank you Reza. It still did not work I did not know if the re in any feature I did not turn on because it rendered perfectly well on the laptop and desktop although I prepare it intablet form
@@abayomiakinyemi7704 I would have to take a look at your App to know more about it. I will recommend you post your issue with screenshots on the forums at powerusers.microsoft.com/
Sounds like a good topic for the 3rd version of this series :) Yes, it can work with document sets as well. I am already using it in one of my projects.
Check the following comment on the video - "I think I figured out a solution for my pdf file problem. In the document URL the 32 digit id/number between 'azure-apim.net%2Fapim%2Fsharepointonline%2F' and 'datasets%2Fhttps' changes by user. So I kept a single dummy file at root level and saved its url in Pic column. In PA I am lookingup that file using its ID and substituting the 32 digit id/number out and concatenating it within my pdf document url. It seems to work. "
@@RezaDorrani can u pls explain once more "In PA I am lookingup that file using its ID and substituting the 32 digit id/number out and concatenating it within my pdf document url."
@@AshutoshDubeyCivil Explanation is as in pinned comment. If you need step by step guidance, then I would recommend posting your query on forums at powerusers.microsoft.com/
When you said all this without using power automated flows you had me there :)
I hope it was true :)
I got almost everything to work in the first video. I then learned more from this one. It’s all working so well with the exception of getting PDF files to render in the PDF Viewer as prescribed. The office documents convert nicely. It’s strange because I do trigger and capture the link (text label) after adding the hyperlink column. I can’t figure out what is going wrong. But everything else works… thanks for all your coaching mate!
You are most welcome!
I have not come across the mentioned issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you Reza. I have learnt so much by watching your videos. For me , you are the go to person for all things related to PowerApps and Flow. Again thanks for the work you are doing and sharing with all of us.
Thank you for your kind words
Thanks for this! I will try to implement this in my project. Libraries and files are always the most important thing and I believe users will like a lot the powerapp experience!
Sounds great!
Anothtaa one! Again--to help keep things in a one stop place rather than going from app to sharepoint and back and forth, this will help keep things in one place!
Great to hear that the solution helps!
That was brilliant. I always learn so much by watching your videos. Thank you, Reza.
My pleasure!
Thanks Rezza! You’ve helped me so much with my project. I ran into one issue when making the pdf viewer visible only when certain document types were selected and had to adjust the Visible control where instead of using “).Result “ I used “).Value”
And it worked for me! (Without the “”)
Hopefully that might help someone else too. Thanks again!!
Thanks for sharing
Like the introduction, the result is simple, elegant and professional. Thanks for a great (and powerful) video
You're very welcome!
Thanks Reza.. I have also created similar kind of app in one of my project and implemented the same. I used document set. Through this video I have learnt breadcrumbs and delegation.. Thanks again.
Great 👍
Thanks Reza!! I always learn a lot when viewing your videos.
Glad to hear that. Thank you for following my channel.
thats the most apt name for this video.. its a complete tutorial. Thanks for sharing
Glad you think so!
Nice tutorial even 2 years later!! Thanks Reza for all ,this helped implement our companies doc libraries and it is functioning perfectly.The only issue i have with this is if user double clicks on a folder.The variable is then messed up and shows no results
Glad it helped!
I did not run into the double click issue though.
Thank you for the deligation issue with isfolder. Very interesting
Thanks for watching
Thank you very much 😊😊. Now waiting for monday video and new learning.
👍
Always something to learn from your videos. Big salute to you. waiting for your next one
So nice of you
Nice! Adding the document content-type and the new column is a great work around.
Thanks Dan. Some old school SharePoint skills to the rescue!
@@RezaDorrani @Daniel Christian : I fan of you both :)
Eye opening!! I developed something similar but your is more friendly user, thanks for the information Reza!!
I'll definitely be improving my SharePoint list in Powerapps!! 👏
Great!
Always able to learn new things from your video,, thank you 😊
My pleasure 😊
Hey Reza,
You have made my life possible, if I was not able to watch your videos and learn how to do these I would have never found interest in Power Platform, you made it very easy for me to learn. Wanted to thank you from the bottom of my heart for these.
Also wondered if not answered before, what if users move files from one folder to another, the default rule Doesnt apply to them, anyway to push it with Power Automate or something of that sort?
Thank you
Thank You for watching and learning from the videos. I hope to keep producing quality content.
If files are moved, then flow would be the way to check its details and accordingly set the value. I do not have any video reference on this though.
Thank you Reza for such a splendid content
My pleasure!
Such a good work Reza, thank you a lot.
Glad you like it!
Hi Reza . Its a great tutorial.. Thanks for this. Meanwhile my documents library has more than 2000 items. Its loading only 2000 at 'Documents' collection which is been directly connected to SharePoint.
The technique shown in video is delegable. Works with more than 2k items.
Hi Reza, this is very good . Always good video tutorial to learn from.. please show more. Thanks
Thank You
Brilliantly done and explained!
Thank You
Awesome video as usual! Thank you 🙏🏾
Glad you enjoyed it!
Great video, helped me a lot !!! Thanks
Most welcome.
Hi Reza, great video, Thanks!!!
Your most welcome
Great idea Reza, and certainly the most elegant approach in a static folder case. As far as I can see, it is not applicable when new folders and folder renames can occur (Q1: please correct me if I missinterpret). In those cases, a flow would cover that and your use of defaults would improve my current solution for that greatly. I cannot find a rest call to set the folder defaults though. Q2: do you know if that is implemented (on premises it is, but it looks like online it isn't). And a change would be to build/store delimited folder id's instead of the names like 6/12/34/ instead of shared documents/Asia/India/ to cover renaming (or make a complex flow to propagate that down the tree). As always, great video and thanks!
All great points!
For a static folder case, this will work.
If folders are renamed or files are moved, then it would require updating existing data.
I don't think there is a REST Call for folder default values. This feature never got any love.
Naming folders with IDs is a good idea as well.
Is there any update about it ? I need to get this working within a library where a new folder is added daily
I know this is a year later and I know that this was about not using Power Automate, but there is an UPdate Filter Properties in Power Automate to update both the hidden columns that Reza created. I can create a folder in Power Automate and update the properties to the hidden folder path. I pass parameters from Power Apps with the folder path I want to update. Works perfect. :)
@@davidakridge2831 Hi David! I was wondering how this is done as I am trying to do the same. I'm very new to Flow and PowerAutomate so any advice would be greaty appreciated!
@@davidakridge2831 Same here, would appreciate if you could share what did you use!
Brilliant! thanks a lot for this video!
You're very welcome!
This was mind blowing
Thanks
Hey Reza! Thank you so much for this tutorial video which helps me a lot! I am encountering an issue when setting up the varCurrentPath. I have a few screens in the APP, and the document library is not the first screen. Would this be the reason why when I go back to the document library screen, the varCurrentPath is blank after I implemented Set(varCurrentPath, "Shared Documents/") in App > OnStart ? Looking forward to your guidance! Thank you in advance.
varCurrentPath is a variable. It should have a value if set. You may be editing your app, if so then ensure you run app onstart. You can right click the app object in app and run it.
HI Reza, Great Video.
I implemented the same in my application and working fine. But need small requirement like when ever you are selecting one file to another file in the gallery and size of the file is large it is taking sometime to load. So, I want to hide the PDF viewer control while the other document is loading or clear the content of pdf viewer till the other selected document is loaded.
Thanks.
You may want to use a timer control in that case to only show pdf viewer control after timer duration.
Thank you very much. I want to create the folder with the user name and surname before the document upload and make it into this folder, how can I do this.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hello Reza. I highly appreciated your tutorials, thanks to them I completed an one app and now I am starting a new app with another functionality. I succeeded to organize library viewer as you showed in video, however, I have one question. The situation is: I have Sharepoint list with different column, name column in list matches with the name column in library. How can I connect the list and library so that when you click on gallery with item property Sharepoint list, the certain library folder with common name will be opened. Hope, you are getting me well.
I am understanding the requirement, but I do not have a video reference on this scenario and would have to try it out to provide guidance. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Great Video! Such a shame Microsoft hasn’t made Folders deligable. Adding the folder structure doesn’t work if the folder structure is dynamic…
Thanks Alan. Wish there was a better option for folders.
Really Helpful
Glad to hear that
Thank u once again!
Thanks for watching
Great tutorial, thanks Reza. Just one question, the galley in your tutorial shows folders first and then files, it looks like this is because the ID happens to be in that order. Is there a way to sort the gallery to always show folders first and then files or would you need to essentially create 2 galleries to do that?
Its been a while since I did this video. From what I remember, the gallery shows all folders and files to start with at root level of library. You could try and use the sort function to sort by name of if it is a folder.
Hi Reza, this was a great video and helped make a great starting point for one of my apps. The only question i have been asked since deploying it was, is there a way to limit the amount of folders that return? For larger libraries with many folders, id like tp show at the most 4 folders. Thanks your help!!!!
Thanks for watching and liking the video.
For limiting to a set of folders, you could check the level of the folder (by checking the path - number of / or so) and filter out data accordingly.
Wow, great video, thanks for your help...
Maybe you can help me with something else; The filter works for me with the first level of folders, but if there is another folder within those, they do not appear in the view. What could it be?
I will have to look at your App in action to provide guidance. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hello Reza, I have a problem viewing documents within a library folder with the following path: DDR/215/Further Documentation. While in DDR and 215 the documents are visible. Nothing is seen in further documentation. Are there any limits? Could you help me. I thank you in advance.
I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
This is great! I'm working on a solution where the folders are getting created in a Power Automate Flow from a new item in a list. Is there a way to set up the hiddenFolderPath column without setting the value in the default content value section in the library settings? I'm guessing I could do this in the Flow.
You could easily do that in flow.
Thanks for this wonderful tutorial!
Can you please help me with a query, How do you access the file in the Image control? I had a specific criteria in my project where I needed to show the image in a gallery where the items are from different source. So to get that file in control i had to use 'File name with extension' = ThisItem.No & ".jpg", is there an alternative to avoid delegation in this case? Apologies if it is a basic thing, am quite new to powerapps.
I did a separate video on that
ua-cam.com/video/vqK29FWbLxU/v-deo.htmlsi=oL5SGNxFPCedIuw8
Great video Reza. Thank you so much .
I am working on a project where I need a similar app (preferably in a custom page) and would like to attach the selected document and send an email to a person. Is it possible from your app ?
Bets regards
Youcef
May be possible. Not something I have tried.
Is there a way to have a drop-down that shows all the libraries available on sharepoint and allows the user to select which library they want to upload/edit files in?
Probably possible using graph api or calling flow to get list of libraries from site. I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza, thanks for the video
I copied every step in the process, however my 'OnSelect' to open the folder doesn't work! Do you know the reason why potentially? I even tried adding a button and copying the same code in but it doesn't work :(
Its' been doing my head in for 2 days now and honestly im so frustrated
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Also make video - How to create folder in SP library in power apps using Graph API
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Hi Reza, again an awesome video with great details ❤️, could you also tell if the new columns we have created for folder path will have any camouflage delegation issue for doc lib with many records (for ex 50k)
Delegation cannot get or query more than 2k rows of data.
Not sure what camouflaged delegation for 50k means
@@RezaDorrani camouflaged delegation is the one which you showed for the case of using With function in your other video, if I create a new column having value same of that of the folder path the delegation goes away right, it will work properly for large items (50k records) as well right ?
@@samratguha8933 Yes but it has nothing to do with 50k
Delegation means 2k limit max.
As long as function is delegable, it will work with large data. For SharePoint lists and libraries, there is concept of column indexing which you should look into.
@@RezaDorrani understand!! thanks a lot Reza for taking out time and replying😊
Thank you for this tutorial.
How can i populate the hiddenFolderPath and hiddenIsFolder columns programmatically if I already have a folder structure of more that 4000 files? I guess the only way would be to use a Power Automate flow, or am I missing something?
Another thing: if I create a new folder, the Default value of hiddenFolderPath will be populated correctly, but what happens if I create new files/folders inside the new folder? Is there a way to automate the default value of the hiddenFolderPath of new folders?
The solution shown is best for new libraries.
For older ones, you would need to use PowerShell or flow
@@RezaDorrani Thank you. And do I also need a flow that populates the hiddenFolderPath every time that a new folder is created?
@@Trial4life Yes
Thank you very much for you great videos!!! You are the best :) I wanted to ask if there is a way to get access to folders count column in the sharepoint view within the power app form?
I'm not sure if that shows up in Power Apps.
Power Apps does not understand SharePoint views.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
so awesome!!
Thank you! Cheers!
Hi Reza, thank you very much for the video, I'm just creating an app to view and manage documentation, the difference is that the folders are created directly when uploading a document, to maintain the structure I have used the shareponit option "copy folder" and " send http to sharepoint" and another to rename and move the folder I created.
The problem is that I can't update the metadata part automatically (min 15:40 of the video) I have searched many options to make this change, almost all of them use an HTTP send to sharepoint, but so far I haven't been able to do it. Do you have a video explaining how to change this metadata automatically? Thank you very much for your help and for everything I have learned thanks to you.
Thanks.
I do not have a specific video showing updating metadata part dynamically.
I would recommend to post your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thanks so much
great video reza... how can we upload folder or files from powerapps? any video for that please?
Check ua-cam.com/video/r3UC3TMXhlI/v-deo.html
The hiddenIsFolder column, created in sharepoint library is not recognized in PowerApps even though I have followed the steps in setting up the column,
I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani was able to fix it, its just a matter of refreshing data
Hi Reza. If I making any updates to the documents in the sharepoint library. I am not able to see the updated version in the pdf viewer. How can I fix this?
It gets cached and will get cleared in some time.
I believe there is a parameter that you can pass that clears the cache, but I do not remember what it was.
Hi, has anyone else come across the situation where only folders show up when filtering. If no filter, I get everything. If I filter for isfolder=false, I get nothing. If I filter for isfolder=true, I get the folders. Yes, there are files present. I can't figure it out.
I have not come across this issue. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, I have a document library that consist of 4000 items. It takes lot of time to load the content in the gallery. Is there anyway i can speed up the process. ? Collect and clear collect are non delegable.
A gallery would only load 100 items in memory is delegation is being respected. I would not recommend loading 4000 items in a collection. It will cause performance issues.
Thx for this great follow up video. Is there a way to dynamically set the folder path? (The Malaysia/India part in SharePoint - or perhaps in Dataverse.) Ideally the case I am aiming for is for every item to be inserted into a folder with an ID number assigned to match the value of master record from another list.
Check ua-cam.com/video/QoNQjvHk6qc/v-deo.html
@@RezaDorrani thank you - I'll check it out! take care
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
I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/
Is it possible Reza, without gallery control only using pdf viewer and image control SharePoint document library can be accessed in powerapps?
Document Library will return a collection of data (files). PDF Viewer can only show 1 item at a time.
Hello Reza, I am building an app where I want to store file uploads in Sharepoint Documents Library instead of the lists. Please point me to any of your videos that can help.Thank you.
Check ua-cam.com/video/UYK7yruBHDM/v-deo.html
Warning: I used to speak very fast then :)
How about showing the folder as per access to the logged in user access? Will it show every folder without considering the access or it will show only those folder as per the logged in user access like how it behaves in SPO document library? Please let me know.
Thanks,
Vikram
It will respect SharePoint folder permissions.
Can I ask irrelative question: how can I use two triggers in power automate , I need to trigger my flow using sharePoint triggers:
when a file is created in a folder and when a file is created( properties only).
A flow can only have 1 trigger. You can add multiple trigger conditions but they can only be related to 1 trigger.
Hi Reza, Having an issue - it's not displaying the folder but have set the hiddenFolderPath values as same the folder name based upon the video. But it's only showing the files from the root folder, no directory. Also the hiddenIsFolder value is set to No. What Im doing wrong here? Also I don't see anywhere the hiddenIsFolder is used - is that correct? Do I need to do some code changes?? Any response is highly appreciated.
Video description has link to download sample App.
As for your issue, I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hey Reza, perfect complementing video to part1. Are you releasing a part3 video with an upload function?
Uploading documents with metadata was something I did 10 months ago but is still valid
ua-cam.com/video/r3UC3TMXhlI/v-deo.html
@@RezaDorrani thx for the Link to the Video that I completed succesufuly, you are a top UA-camr btw. When I upload any file using method in the above mentioned-video, that same file wont be rendered in this app you are showing in this part2 Video. It shows "Hmm looks like this file doesn't have a preview we can show you" or "ERROR MSG: " PDF.js v1.9.426 (build: 2558a58d)" - Does it happen to you? but if you upload any file directly on SP in any browser, it will be perfectly rendered
@@carajter07 Oh. This is something I will have to try out and test. Are you getting this issue only in PDF?
I will also recommend you post this issue with screenshots on the forums at powerusers.microsoft.com/
@@RezaDorrani hi Reza , you should get this "no preview " render-issue with any file type. I have tried many Flows to upload a file to SP . The frustration is huge. Does it happen to you as well? may because it is "experimental"
@@carajter07 I will have to try this out. I would recommend you post on the forums at powerusers.microsoft.com
Thanks Reza!!!! Excellent video. I am working on a project that involve email attachment. Do you have any video covering uploading documents received in an email to a SQL table. Thanks Mariena
Thanks for watching and liking the video.
I do not have any video reference for uploading docs from email to sql.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani thanks for your response.
I need to confirm if i want to show only files i'd set IsFolder=false but there's delegation so if I'll do this allow management of content types like that trick you did,
will all the existing file be deleted?
or those will just pick the default of that column to 'No'?
Please tell me I am in a big problem
No files will be deleted.
Try this trick and test and confirm.
@@RezaDorrani Just to confirm 'Will all existing files pick default of new column to No'??
@@muhammadhassan1843 Default is set when file is newly added. Existing ones you would have to set either manually or via flow.
Hello Reza. Thank you very much for your video (all videos), I (we) really appreciate it. I really like this implementation, however, what about existing libraries, with many folders (our document library has over 7000 documents and more than 150 folders. How can I possibly set the defaults for all existing files and folders? Thank you in advance for your prompt reply. Michael.
You would need to do update existing folders via PowerShell or may be via flow using REST APIs
Thanks Reza
Most welcome
Another fantastic video! I would love to allow my users to select and download multiple files. How might you/ this community approach adding such functionality to the experience demonstrated in this video??
Downloading multiple files is something I have not investigated on. There is no out of the box action.
I will recommend you check on the forums at powerusers.microsoft.com/ in case someone has a workaround.
Awesome work, Reza. Thanks for all this great info. Is there a way we can do a similar kind of selection for video files whether it is MS Streams Videos or Video file from Sharepoint?
For MSFT Stream there is a stream control that can be leveraged.
SharePoint video files is something I have not tried out.
@@RezaDorrani Got it! I tried the MS Streams. I am interested to check if we can create something similar to your previous Document Viewer tutorial but for the video files. Very helpful videos btw. Thanks!
Hello Reza, is it possible to have an option to select a different document library? Lets say we have 4 different sites with Document Library's that we want to use with this App, how would you best add this feature into your App?
In that case you would need to connect to all the 4 doc libs in your Power App.
Hello Reza. Is it possible to add a search to this app? I have created the entire app, however I am at a loss in where to place the search function for the gallery. Any help or direction would be greatly appreciated!! By the way...excellent tutorial.
Reza - I figured out the multiple filter syntax myself. Thank you SO, SO much for your wonderful tutorials.
Looks like you got it to work based on your 2nd comment.
Great!
Can we have a selective folder view as per the selection done in main gallery...
Means as per gallery files/folders can be viewed.?.
Power Apps does not understand SharePoint views. Gallery has a single pattern to it.
I'm having 2 doubts...
1st - pdf quality is degrading
2nd - After going back to previous screen if I again open pdf viewer it should reset to root folder..
@@AshutoshDubeyCivil 1- There is an option to get higher quality. You would need to read more about the api that generates pdf to know which param it needs to get that. 2- You would need to update the code accordingly. Its been a while since I did this video, hence do not recollect the code.
Dear Mr. Reza, why the PDF viewer woks correctly on my owm application, but when I shared it doesn't work :(. Thank you.
Check the pinned comment on my other video on pdf viewer.
Could you share with me the video or the name of the video? Thank you@@RezaDorrani
@@andmanrique86 A simple search of pdf reza will bring it up.
ua-cam.com/video/vqK29FWbLxU/v-deo.htmlsi=VrErvu44hWLNe1yK
Hi Reza, I have followed the video but I am not able to see the files and folders inside the folder in 1st screen
Video description has link to download the App and the steps for setup. I will recommend you check that out.
Hello Reza! Do you have any course from scratch to advanced about the entire Power Platform?
I am planning to start my own training portal by late this year.
I have my UA-cam live training also starting soon.
@@RezaDorrani Awesome! I am trying to find some good contents in this format and with your quality but it is very hard to find!
Check channel memberships. I have gone live with a training tier that you can sign up for now.
ua-cam.com/users/rezadorranijoin
How to add Folder from PowerApp to Shared documents ( & sub folders ) ?
I will have to try it out myself to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
nice!
Thanks!
Love you already yeh
Thank you :)
Hey Reza, how can we download from documents or folders from SharePoint using PowerApps? I tried different approach but it's just opening the folder not letting us download? Any solution we be appreciated
powerusers.microsoft.com/t5/Building-Power-Apps/Downloading-Document-from-SharePoint-Library-in-Power-Apps/td-p/1585117
@@RezaDorrani Thankyou Reza but what I am trying to achieve is download the folder instead of file in zip just like how it allows us in SharePoint
@@siddharthgoutam7857 Im not aware of how this can be done in power apps. I would recommend posting your query on forums.
Great video, Reza!
I wanna implement a download folder (or .zip file) functionality in the library. Could you help me with this?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hello Reza ! Great video. Im trying to implement the "Set(varFolderPath; "Shared Documents/" on the start screen but power app doesent seem to recognize this function.. Any idea ?
Its a simple variable set function in power apps and should work.
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Sadly I can't seem to make it work. I would gladly ask support :) Will post in forum
ID environnement
Default-f4a12867-922d-4b9d-bb85-9ee7898512a0
What if you dont have a defined folder structure?
You could create the path column and populate it via flow for every new item added in that case.
Hi Rezna, thanks for this really interesting video. Is there a way to browse sharepoint document libraries from different sites without first making a data connection? For example if you have a sharepoint site per project, each containing thir own documents? When using your technique, I would have to make hundrers of data connections...
You will need those many connections.
Power Apps is not ideally suited for this requirement.
@@RezaDorrani as I indeed expected :( but since I always needed the same 3 folders for attachments, I used Powerautomate at OnVisible to load the adresses into 'shortcuts'. As most of the time in Powerapps: working around obnoxiousnous :) Anyway thanks a lot for your immeasurable contributions!!!
hi is there way to pin or save commonly used documents once they are found?
You would have to build that logic in Power Apps. Not available Out of the box.
@@RezaDorrani ok thanks for reply
Hi Reza how can I add a search box to search a specific file within the selected folder?
Idea would be to filter down to that folder level - similar to breadcrumb technique in video and then use standard functions like search
@@RezaDorrani Love your videos. Can you please explain more about using textsearchbox in this situation?
That would have to be a separate video altogether. I make videos when I get multiple requests on a particular topic.
Every quarter I ask subscribers for topic suggestions on the Community Tab of my UA-cam channel.
Subscribers vote for topics and the highest voted topics get added to my backlog.
Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.
hi Reza, after i following your instruction, my gallery cant show the data i've got, how can i show it again?
i hope you reply my message, thank you master
I will have to see your App in action to know why. I did not face any such issue.
I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
I always reply & I am no master :)
Reza I just wanted to bring to your notice if the pdf file name with some special characters like "&", the pdf viewer is not working.
Any quick tip for this issue..
I believe it is the limitation of that API. Im thinking we may need to escape the special character in the Power App.
Hi Reza, would like to inform you that, pdf viewer are respecting the user who has premium license. Currently I'm facing issue with pdf document when we use "appres://datasource" api. It's not showing the pdf files.. When we use premium account it works fine. But not working with normal users account. Tried all the possibilities.
Please let us know your thoughts.
@@karukarthi2609 I will have to get back to this and evaluate it to the full extent. I have plenty of work planned this month. PDF viewer is a standard connector so premium should not be required.
Hi Reza, I hope you are doing great.!. Quick question related to PowerApps gallery control Items property. Is it possible to show two document library contents in one gallery control ??
Possible. You would need to create a collection, data from which will have to be loaded from your multiple libraries.
@@RezaDorrani Thank you so much.! You are always been very helpful. Keep up the good work. Pleasure to have you around. With Best Regards,
Hi Reza, Need your help :)
I have a document library that has 3000 files and i would like to create a document viewer app where a user can view the document from the app instead of going through folders. Few challenges i'm facing at the moment:
1. Able to collect only 2000 items.
2. ClearCollect takes time to collect 2000 items. (almost 5mins)
3. Pdf viewer also takes time to load the document. ( >1min)
Thank you for your help in advance.
Could you do this where the user could see all the document libraries they have access to as the first level?
It requires a connection to a specific doc library. So you would have to have all those connections in there.
Sir can u tell me how to put two libraries in one new collection? so that I can use the meta data from both of them and customize my PowerApp.
I have not worked on this scenario. I will have to try it out to provide any guidance.
I will recommend you check on the forums at powerusers.microsoft.com/
@@RezaDorrani oh! ok sir, thank you.
Help me i need to do breadcrumb for the screens navigation? Anyone...!
I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Good day Reza, thank you for the wonderful work please I was able to do something with the video and the pdf was showing on the Laptop but could not render on the mobile phone
Check video description for link to download sample App.
For your issue, I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani thank you Reza. It still did not work I did not know if the re in any feature I did not turn on because it rendered perfectly well on the laptop and desktop although I prepare it intablet form
@@abayomiakinyemi7704 I would have to take a look at your App to know more about it. I will recommend you post your issue with screenshots on the forums at powerusers.microsoft.com/
Would this work document sets
Sounds like a good topic for the 3rd version of this series :)
Yes, it can work with document sets as well. I am already using it in one of my projects.
Great video! Can something like this be done for document sets?
Absolutely! May be an idea for version 3 of my video on this series.
@@RezaDorrani That would be awesome!
@@dkfresh6656 Will add it to my backlog
Would like to see how to do this with document sets.
Hi Reza, is it possible to submit form with enter key?
You would need to ensure you set focus on the submit button after the form is filled out so user can hit enter. I dont know of any other way.
@@RezaDorrani thank you so much.
Hi Reza,
Thanks for the Solution, other users are not able to view PDF File, Give the error "make sure the PDF file is coming from an HTTPS Links"
Check the following comment on the video -
"I think I figured out a solution for my pdf file problem. In the document URL the 32 digit id/number between 'azure-apim.net%2Fapim%2Fsharepointonline%2F' and 'datasets%2Fhttps' changes by user. So I kept a single dummy file at root level and saved its url in Pic column. In PA I am lookingup that file using its ID and substituting the 32 digit id/number out and concatenating it within my pdf document url. It seems to work. "
@@RezaDorrani can u pls explain once more "In PA I am lookingup that file using its ID and substituting the 32 digit id/number out and concatenating it within my pdf document url."
@@AshutoshDubeyCivil Explanation is as in pinned comment. If you need step by step guidance, then I would recommend posting your query on forums at powerusers.microsoft.com/
@@RezaDorrani I think I got it after reading again and again.. have tried it.. if it works tomorrow I'll ask other users.. else will do as guided...
@@AshutoshDubeyCivil Hope it works.
You are a myth! Thanks!
Thank You :)
for me ThisItem.Thumbnail.Small is blank .
Not sure why that would be the case. Il recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/