Power Apps SharePoint Document Library Tutorial

Поделиться
HTML-код
  • Опубликовано: 29 май 2024
  • In this Power Apps tutorial video, we will explore how to create a fully featured SharePoint Document Library browsing experience in PowerApps.
    We will preview documents using File Thumbnails, use PDF Viewer control for pdf & office files, filter with delegation on isFolder, folder path using a simple technique of folder default values, navigate through the SharePoint document library using a breadcrumb experience like modern SharePoint libraries.
    All the above without using any Power Automate flows and keeping delegation in check wherein we can work with document libraries having more than the delegable limit of 2000 documents.
    #PowerApps #SharePoint #DocumentLibrary
    Documentation:
    docs.microsoft.com/en-us/powe...
    Document Previews Video - • PowerApps PDF Viewer S...
    Upload a document to SharePoint - • Upload & Tag Multiple ...
    & • PowerApps upload multi...
    Download sample App - github.com/rdorrani/PowerApps...
    Breadcrumb Gallery Items property:
    Split(Left(varCurrentPath,Len(varCurrentPath)-1),"/")
    Breadcrumb button OnSelect property:
    Set(
    varCurrentPath,
    Left(
    varCurrentPath,
    Find(
    ThisItem.Result,
    varCurrentPath
    ) + Len(ThisItem.Result)
    )
    )
    Doc library gallery Items property:
    Filter(Documents,hiddenFolderPath = varCurrentPath && (Status.Value = drpStatus.Selected.Value || IsBlank(drpStatus.Selected)) )
    Doc library gallery OnSelect property:
    If(ThisItem.IsFolder,Set(varCurrentPath,ThisItem.'Folder path'&ThisItem.Name&"/"))
    Table of Contents:
    00:00 - Introduction to Power Apps SharePoint Document Library Tutorial
    00:57 - Power App Walk through of SharePoint documents with folders
    02:05 - SharePoint document library with folders and files
    03:04 - Power Apps query SharePoint documents library on isFolder with delegation
    10:40 - Power Apps show documents with folders & query folder path with delegation
    20:55 - Build a breadcrumb navigation in Power Apps to traverse folders and files in SharePoint
    25:28 - Filter SharePoint documents library in PowerApps
    28:33 - Subscribe to Reza Dorrani channel

Комментарии • 260

  • @musicpie3198
    @musicpie3198 2 года назад +3

    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.

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Thank you for your kind words

  • @EpicDreamer_
    @EpicDreamer_ Год назад +2

    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!

  • @DanielNDemo-bk2km
    @DanielNDemo-bk2km 2 года назад +2

    That was brilliant. I always learn so much by watching your videos. Thank you, Reza.

  • @greatkingrat
    @greatkingrat 7 месяцев назад +1

    Like the introduction, the result is simple, elegant and professional. Thanks for a great (and powerful) video

  • @133mhz.
    @133mhz. Год назад +3

    When you said all this without using power automated flows you had me there :)

  • @DanielChristian19
    @DanielChristian19 3 года назад +1

    Nice! Adding the document content-type and the new column is a great work around.

    • @RezaDorrani
      @RezaDorrani  3 года назад

      Thanks Dan. Some old school SharePoint skills to the rescue!

    • @ramisolipe7001
      @ramisolipe7001 3 года назад +1

      @@RezaDorrani @Daniel Christian : I fan of you both :)

  • @christerrussberg3059
    @christerrussberg3059 2 года назад +1

    Thanks Reza!! I always learn a lot when viewing your videos.

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Glad to hear that. Thank you for following my channel.

  • @brunoburagohain9830
    @brunoburagohain9830 3 года назад +1

    Always something to learn from your videos. Big salute to you. waiting for your next one

  • @yeraldo05
    @yeraldo05 3 года назад +1

    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!! 👏

  • @anthonyleduc
    @anthonyleduc 2 года назад +1

    Thank you for the deligation issue with isfolder. Very interesting

  • @kevinjoseph9023
    @kevinjoseph9023 7 месяцев назад +1

    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!

    • @RezaDorrani
      @RezaDorrani  7 месяцев назад

      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

  • @prajwalskateel
    @prajwalskateel 3 года назад +1

    Always able to learn new things from your video,, thank you 😊

  • @sahilthakur03
    @sahilthakur03 3 года назад +1

    thats the most apt name for this video.. its a complete tutorial. Thanks for sharing

  • @chrisproctor2854
    @chrisproctor2854 Год назад

    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!

    • @RezaDorrani
      @RezaDorrani  Год назад

      Great to hear that the solution helps!

  • @katelinhill7946
    @katelinhill7946 Год назад +1

    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!!

  • @milkatesfaye
    @milkatesfaye 3 года назад +1

    Awesome video as usual! Thank you 🙏🏾

  • @SubrataPal123
    @SubrataPal123 10 месяцев назад +1

    Thank you very much 😊😊. Now waiting for monday video and new learning.

  • @PrashantGijare
    @PrashantGijare 3 года назад +1

    Brilliantly done and explained!

  • @sininv1
    @sininv1 2 года назад

    Hi Reza, this is very good . Always good video tutorial to learn from.. please show more. Thanks

  • @enghatemosman
    @enghatemosman 2 года назад +1

    Such a good work Reza, thank you a lot.

  • @nikhilsinghyadav9512
    @nikhilsinghyadav9512 Год назад +1

    Thank you Reza for such a splendid content

  • @karukarthi2609
    @karukarthi2609 3 года назад +1

    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.

  • @AakashDhawanKash
    @AakashDhawanKash Год назад +1

    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

    • @RezaDorrani
      @RezaDorrani  Год назад +2

      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.

  • @andrevinicius137
    @andrevinicius137 2 года назад +1

    Great video, helped me a lot !!! Thanks

  • @gkakun
    @gkakun 4 месяца назад +1

    Brilliant! thanks a lot for this video!

  • @desktopservices9313
    @desktopservices9313 2 года назад +2

    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!

    • @RezaDorrani
      @RezaDorrani  2 года назад +2

      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.

    • @andrevinicius137
      @andrevinicius137 2 года назад

      Is there any update about it ? I need to get this working within a library where a new folder is added daily

    • @davidakridge2831
      @davidakridge2831 Год назад +4

      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. :)

    • @JacquelineMoon-wt3kn
      @JacquelineMoon-wt3kn 11 месяцев назад

      @@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!

    • @TiestoCrack
      @TiestoCrack 10 месяцев назад

      @@davidakridge2831 Same here, would appreciate if you could share what did you use!

  • @oscargonzalezvalverde3887
    @oscargonzalezvalverde3887 2 года назад +1

    Hi Reza, great video, Thanks!!!

  • @italliesptyltd6617
    @italliesptyltd6617 Год назад +1

    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?

    • @RezaDorrani
      @RezaDorrani  Год назад

      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.

  • @ashtoshsingh8310
    @ashtoshsingh8310 3 года назад +1

    This was mind blowing

  • @mikemerrow4186
    @mikemerrow4186 2 года назад +1

    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!!!!

    • @RezaDorrani
      @RezaDorrani  2 года назад

      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.

  • @GordeNN
    @GordeNN 8 месяцев назад +1

    Really Helpful

  • @mattmavis2845
    @mattmavis2845 2 года назад +1

    Thank u once again!

  • @linshi7909
    @linshi7909 9 месяцев назад +1

    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.

    • @RezaDorrani
      @RezaDorrani  9 месяцев назад

      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.

  • @lucascarl7243
    @lucascarl7243 3 года назад +1

    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.

    • @RezaDorrani
      @RezaDorrani  3 года назад +1

      You could easily do that in flow.

  • @geralddahl9159
    @geralddahl9159 3 года назад +1

    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.

    • @RezaDorrani
      @RezaDorrani  3 года назад

      Check ruclips.net/video/QoNQjvHk6qc/видео.html

    • @geralddahl9159
      @geralddahl9159 3 года назад +1

      @@RezaDorrani thank you - I'll check it out! take care

  • @TheDjMessiah
    @TheDjMessiah 2 года назад +1

    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?

    • @RezaDorrani
      @RezaDorrani  2 года назад +1

      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.

  • @voodoomanclothingco.3102
    @voodoomanclothingco.3102 10 месяцев назад +1

    so awesome!!

  • @MrAmir2306
    @MrAmir2306 2 года назад +1

    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.

    • @RezaDorrani
      @RezaDorrani  2 года назад +1

      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.

  • @josiahbabu2282
    @josiahbabu2282 4 месяца назад

    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.

    • @RezaDorrani
      @RezaDorrani  4 месяца назад

      I did a separate video on that
      ruclips.net/video/vqK29FWbLxU/видео.htmlsi=oL5SGNxFPCedIuw8

  • @myatix1
    @myatix1 2 года назад +1

    Great Video! Such a shame Microsoft hasn’t made Folders deligable. Adding the folder structure doesn’t work if the folder structure is dynamic…

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Thanks Alan. Wish there was a better option for folders.

  • @aniketshukla8967
    @aniketshukla8967 3 года назад +1

    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
      @RezaDorrani  3 года назад

      For MSFT Stream there is a stream control that can be leveraged.
      SharePoint video files is something I have not tried out.

    • @aniketshukla8967
      @aniketshukla8967 3 года назад +1

      @@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!

  • @MichaelGer
    @MichaelGer 2 года назад

    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.

    • @RezaDorrani
      @RezaDorrani  2 года назад +1

      You would need to do update existing folders via PowerShell or may be via flow using REST APIs

  • @manikantabatchu1182
    @manikantabatchu1182 2 года назад +1

    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.

    • @RezaDorrani
      @RezaDorrani  2 года назад +1

      You may want to use a timer control in that case to only show pdf viewer control after timer duration.

  • @savedios
    @savedios Год назад +1

    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.

    • @RezaDorrani
      @RezaDorrani  Год назад +1

      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

    • @savedios
      @savedios Год назад +1

      @@RezaDorrani Thanks so much

  • @TrionicoMusic
    @TrionicoMusic 2 года назад +1

    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?

    • @RezaDorrani
      @RezaDorrani  2 года назад

      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

  • @jimmydoe1653
    @jimmydoe1653 2 года назад

    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??

    • @RezaDorrani
      @RezaDorrani  2 года назад

      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.

  • @kolomagoulidis
    @kolomagoulidis 3 месяца назад +1

    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

    • @RezaDorrani
      @RezaDorrani  3 месяца назад

      Glad it helped!
      I did not run into the double click issue though.

  • @marienaalvarez8235
    @marienaalvarez8235 2 года назад +1

    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

    • @RezaDorrani
      @RezaDorrani  2 года назад +1

      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.

    • @marienaalvarez8235
      @marienaalvarez8235 2 года назад +1

      @@RezaDorrani thanks for your response.

  • @samratguha8933
    @samratguha8933 2 месяца назад +1

    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
      @RezaDorrani  2 месяца назад

      Delegation cannot get or query more than 2k rows of data.
      Not sure what camouflaged delegation for 50k means

    • @samratguha8933
      @samratguha8933 2 месяца назад

      @@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 ?

    • @RezaDorrani
      @RezaDorrani  2 месяца назад

      @@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.

    • @samratguha8933
      @samratguha8933 2 месяца назад +1

      @@RezaDorrani understand!! thanks a lot Reza for taking out time and replying😊

  • @yodo94
    @yodo94 3 месяца назад +1

    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

    • @RezaDorrani
      @RezaDorrani  3 месяца назад

      May be possible. Not something I have tried.

  • @Trial4life
    @Trial4life Месяц назад

    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?

    • @RezaDorrani
      @RezaDorrani  Месяц назад +1

      The solution shown is best for new libraries.
      For older ones, you would need to use PowerShell or flow

    • @Trial4life
      @Trial4life Месяц назад

      @@RezaDorrani Thank you. And do I also need a flow that populates the hiddenFolderPath every time that a new folder is created?

    • @RezaDorrani
      @RezaDorrani  Месяц назад +1

      @@Trial4life Yes

  • @muratarabacilar
    @muratarabacilar 9 месяцев назад +1

    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.

    • @RezaDorrani
      @RezaDorrani  9 месяцев назад

      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

  • @franktack6926
    @franktack6926 Год назад

    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
      @RezaDorrani  Год назад

      You will need those many connections.
      Power Apps is not ideally suited for this requirement.

    • @franktack6926
      @franktack6926 Год назад +1

      @@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!!!

  • @prizim
    @prizim 3 года назад +1

    nice!

  • @sureshkumarnarayanasamy1952
    @sureshkumarnarayanasamy1952 Месяц назад +1

    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.

    • @RezaDorrani
      @RezaDorrani  Месяц назад

      The technique shown in video is delegable. Works with more than 2k items.

  • @sundrapillay6668
    @sundrapillay6668 3 года назад +1

    Thanks Reza

  • @talib_tv
    @talib_tv Год назад

    Great video, Reza!
    I wanna implement a download folder (or .zip file) functionality in the library. Could you help me with this?

    • @RezaDorrani
      @RezaDorrani  Год назад

      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

  • @ramisolipe7001
    @ramisolipe7001 3 года назад

    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).

    • @RezaDorrani
      @RezaDorrani  3 года назад +1

      A flow can only have 1 trigger. You can add multiple trigger conditions but they can only be related to 1 trigger.

  • @carajter07
    @carajter07 2 года назад +1

    Hey Reza, perfect complementing video to part1. Are you releasing a part3 video with an upload function?

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Uploading documents with metadata was something I did 10 months ago but is still valid
      ruclips.net/video/r3UC3TMXhlI/видео.html

    • @carajter07
      @carajter07 2 года назад

      @@RezaDorrani thx for the Link to the Video that I completed succesufuly, you are a top RUclipsr 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

    • @RezaDorrani
      @RezaDorrani  2 года назад +1

      @@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/

    • @carajter07
      @carajter07 2 года назад

      @@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"

    • @RezaDorrani
      @RezaDorrani  2 года назад

      @@carajter07 I will have to try this out. I would recommend you post on the forums at powerusers.microsoft.com

  • @alhussenbaraze5423
    @alhussenbaraze5423 Год назад

    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 ?

    • @RezaDorrani
      @RezaDorrani  Год назад

      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

    • @alhussenbaraze5423
      @alhussenbaraze5423 Год назад +1

      @@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

  • @kanishkaroychowdhury4050
    @kanishkaroychowdhury4050 2 года назад +1

    great video reza... how can we upload folder or files from powerapps? any video for that please?

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Check ruclips.net/video/r3UC3TMXhlI/видео.html

  • @737cl9
    @737cl9 2 года назад

    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 ??

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Possible. You would need to create a collection, data from which will have to be loaded from your multiple libraries.

    • @737cl9
      @737cl9 2 года назад +1

      @@RezaDorrani Thank you so much.! You are always been very helpful. Keep up the good work. Pleasure to have you around. With Best Regards,

    • @737cl9
      @737cl9 2 года назад

      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.

  • @abrilg2432
    @abrilg2432 10 месяцев назад

    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?

    • @RezaDorrani
      @RezaDorrani  10 месяцев назад +1

      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.

  • @issiewizzie
    @issiewizzie 3 года назад +1

    Love you already yeh

  • @bcso365tech8
    @bcso365tech8 2 года назад

    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?

    • @RezaDorrani
      @RezaDorrani  2 года назад

      In that case you would need to connect to all the 4 doc libs in your Power App.

  • @VikramSingh-vj5xu
    @VikramSingh-vj5xu 2 года назад

    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

    • @RezaDorrani
      @RezaDorrani  2 года назад

      It will respect SharePoint folder permissions.

  • @fla1910
    @fla1910 3 года назад +1

    Hello Reza! Do you have any course from scratch to advanced about the entire Power Platform?

    • @RezaDorrani
      @RezaDorrani  3 года назад +2

      I am planning to start my own training portal by late this year.
      I have my RUclips live training also starting soon.

    • @fla1910
      @fla1910 3 года назад +1

      @@RezaDorrani Awesome! I am trying to find some good contents in this format and with your quality but it is very hard to find!

    • @RezaDorrani
      @RezaDorrani  9 месяцев назад

      Check channel memberships. I have gone live with a training tier that you can sign up for now.
      ruclips.net/user/rezadorranijoin

  • @AshutoshDubeyCivil
    @AshutoshDubeyCivil 11 месяцев назад

    Can we have a selective folder view as per the selection done in main gallery...
    Means as per gallery files/folders can be viewed.?.

    • @RezaDorrani
      @RezaDorrani  11 месяцев назад

      Power Apps does not understand SharePoint views. Gallery has a single pattern to it.

    • @AshutoshDubeyCivil
      @AshutoshDubeyCivil 11 месяцев назад

      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..

    • @RezaDorrani
      @RezaDorrani  11 месяцев назад

      @@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.

  • @davidoriakhi3713
    @davidoriakhi3713 7 месяцев назад

    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

    • @RezaDorrani
      @RezaDorrani  7 месяцев назад

      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

  • @737cl9
    @737cl9 2 года назад

    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.

    • @RezaDorrani
      @RezaDorrani  2 года назад

      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.

  • @bwersel
    @bwersel 2 года назад +1

    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.

    • @bwersel
      @bwersel 2 года назад +1

      Reza - I figured out the multiple filter syntax myself. Thank you SO, SO much for your wonderful tutorials.

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Looks like you got it to work based on your 2nd comment.

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Great!

  • @infy25
    @infy25 2 года назад

    Is it possible Reza, without gallery control only using pdf viewer and image control SharePoint document library can be accessed in powerapps?

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Document Library will return a collection of data (files). PDF Viewer can only show 1 item at a time.

  • @muhammadhassan1843
    @muhammadhassan1843 10 месяцев назад

    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

    • @RezaDorrani
      @RezaDorrani  10 месяцев назад

      No files will be deleted.
      Try this trick and test and confirm.

    • @muhammadhassan1843
      @muhammadhassan1843 10 месяцев назад

      @@RezaDorrani Just to confirm 'Will all existing files pick default of new column to No'??

    • @RezaDorrani
      @RezaDorrani  10 месяцев назад

      @@muhammadhassan1843 Default is set when file is newly added. Existing ones you would have to set either manually or via flow.

  • @abayomiakinyemi7704
    @abayomiakinyemi7704 2 года назад

    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

    • @RezaDorrani
      @RezaDorrani  2 года назад

      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

    • @abayomiakinyemi7704
      @abayomiakinyemi7704 2 года назад

      @@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

    • @RezaDorrani
      @RezaDorrani  2 года назад

      @@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/

  • @dkfresh6656
    @dkfresh6656 3 года назад

    Great video! Can something like this be done for document sets?

    • @RezaDorrani
      @RezaDorrani  3 года назад +1

      Absolutely! May be an idea for version 3 of my video on this series.

    • @dkfresh6656
      @dkfresh6656 3 года назад +1

      @@RezaDorrani That would be awesome!

    • @RezaDorrani
      @RezaDorrani  3 года назад

      @@dkfresh6656 Will add it to my backlog

    • @jimfitch
      @jimfitch 2 года назад

      Would like to see how to do this with document sets.

  • @ladykilla6
    @ladykilla6 2 года назад

    hi is there way to pin or save commonly used documents once they are found?

    • @RezaDorrani
      @RezaDorrani  2 года назад

      You would have to build that logic in Power Apps. Not available Out of the box.

    • @ladykilla6
      @ladykilla6 2 года назад +1

      @@RezaDorrani ok thanks for reply

  • @hermanodame3302
    @hermanodame3302 2 года назад +1

    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.

    • @RezaDorrani
      @RezaDorrani  2 года назад +1

      Check ruclips.net/video/UYK7yruBHDM/видео.html
      Warning: I used to speak very fast then :)

  • @aafreensultana1835
    @aafreensultana1835 Год назад

    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?

    • @RezaDorrani
      @RezaDorrani  Год назад

      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.

  • @karukarthi2609
    @karukarthi2609 3 года назад

    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..

    • @RezaDorrani
      @RezaDorrani  3 года назад +1

      I believe it is the limitation of that API. Im thinking we may need to escape the special character in the Power App.

    • @karukarthi2609
      @karukarthi2609 2 года назад

      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.

    • @RezaDorrani
      @RezaDorrani  2 года назад +1

      @@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.

  • @bhavyapatnam7586
    @bhavyapatnam7586 2 года назад

    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.

    • @RezaDorrani
      @RezaDorrani  2 года назад

      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/

    • @bhavyapatnam7586
      @bhavyapatnam7586 2 года назад +1

      @@RezaDorrani oh! ok sir, thank you.

  • @M365Community
    @M365Community 3 месяца назад

    Also make video - How to create folder in SP library in power apps using Graph API

    • @RezaDorrani
      @RezaDorrani  3 месяца назад

      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.

  • @joselin4753
    @joselin4753 Год назад

    Hi Reza how can I add a search box to search a specific file within the selected folder?

    • @RezaDorrani
      @RezaDorrani  Год назад

      Idea would be to filter down to that folder level - similar to breadcrumb technique in video and then use standard functions like search

    • @DavidMarco-uq8bc
      @DavidMarco-uq8bc Год назад

      @@RezaDorrani Love your videos. Can you please explain more about using textsearchbox in this situation?

    • @RezaDorrani
      @RezaDorrani  Год назад

      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 RUclips 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.

  • @MadRockway
    @MadRockway 3 года назад

    Hi Reza, is it possible to submit form with enter key?

    • @RezaDorrani
      @RezaDorrani  3 года назад +1

      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.

    • @MadRockway
      @MadRockway 3 года назад +1

      @@RezaDorrani thank you so much.

  • @kevingonzales2990
    @kevingonzales2990 6 месяцев назад

    The hiddenIsFolder column, created in sharepoint library is not recognized in PowerApps even though I have followed the steps in setting up the column,

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      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

    • @kevingonzales2990
      @kevingonzales2990 6 месяцев назад

      @@RezaDorrani was able to fix it, its just a matter of refreshing data

  • @siddharthgoutam7857
    @siddharthgoutam7857 Год назад

    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

    • @RezaDorrani
      @RezaDorrani  Год назад +1

      powerusers.microsoft.com/t5/Building-Power-Apps/Downloading-Document-from-SharePoint-Library-in-Power-Apps/td-p/1585117

    • @siddharthgoutam7857
      @siddharthgoutam7857 Год назад

      @@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

    • @RezaDorrani
      @RezaDorrani  Год назад +1

      @@siddharthgoutam7857 Im not aware of how this can be done in power apps. I would recommend posting your query on forums.

  • @issiewizzie
    @issiewizzie 3 года назад +1

    Would this work document sets

    • @RezaDorrani
      @RezaDorrani  3 года назад

      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.

  • @sagarranjanparida5740
    @sagarranjanparida5740 3 года назад

    Hi Reza, I have followed the video but I am not able to see the files and folders inside the folder in 1st screen

    • @RezaDorrani
      @RezaDorrani  3 года назад

      Video description has link to download the App and the steps for setup. I will recommend you check that out.

  • @stanbecnel6878
    @stanbecnel6878 3 года назад

    Could you do this where the user could see all the document libraries they have access to as the first level?

    • @RezaDorrani
      @RezaDorrani  3 года назад

      It requires a connection to a specific doc library. So you would have to have all those connections in there.

  • @gabrielrodri30
    @gabrielrodri30 Год назад

    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

    • @RezaDorrani
      @RezaDorrani  Год назад

      I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/

  • @handricoc3302
    @handricoc3302 2 года назад

    hi Reza, after i following your instruction, my gallery cant show the data i've got, how can i show it again?

    • @handricoc3302
      @handricoc3302 2 года назад

      i hope you reply my message, thank you master

    • @RezaDorrani
      @RezaDorrani  2 года назад

      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

    • @RezaDorrani
      @RezaDorrani  2 года назад

      I always reply & I am no master :)

  • @djpowerage
    @djpowerage Год назад

    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.

    • @RezaDorrani
      @RezaDorrani  Год назад

      I have not come across this issue. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

  • @narendrakumarpappu6621
    @narendrakumarpappu6621 Год назад

    Help me i need to do breadcrumb for the screens navigation? Anyone...!

    • @RezaDorrani
      @RezaDorrani  Год назад

      I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

  • @StanOlbrot
    @StanOlbrot 2 года назад

    How to add Folder from PowerApp to Shared documents ( & sub folders ) ?

    • @RezaDorrani
      @RezaDorrani  2 года назад

      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

  • @andmanrique86
    @andmanrique86 9 месяцев назад

    Dear Mr. Reza, why the PDF viewer woks correctly on my owm application, but when I shared it doesn't work :(. Thank you.

    • @RezaDorrani
      @RezaDorrani  9 месяцев назад +1

      Check the pinned comment on my other video on pdf viewer.

    • @andmanrique86
      @andmanrique86 8 месяцев назад

      Could you share with me the video or the name of the video? Thank you@@RezaDorrani

    • @RezaDorrani
      @RezaDorrani  8 месяцев назад +1

      @@andmanrique86 A simple search of pdf reza will bring it up.
      ruclips.net/video/vqK29FWbLxU/видео.htmlsi=VrErvu44hWLNe1yK

  • @cyberpilot717
    @cyberpilot717 2 года назад

    What if you dont have a defined folder structure?

    • @RezaDorrani
      @RezaDorrani  2 года назад

      You could create the path column and populate it via flow for every new item added in that case.

  • @sandeeppoojary2467
    @sandeeppoojary2467 2 года назад

    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"

    • @RezaDorrani
      @RezaDorrani  2 года назад

      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. "

    • @AshutoshDubeyCivil
      @AshutoshDubeyCivil 11 месяцев назад

      @@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."

    • @RezaDorrani
      @RezaDorrani  11 месяцев назад

      @@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/

    • @AshutoshDubeyCivil
      @AshutoshDubeyCivil 11 месяцев назад +1

      @@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...

    • @RezaDorrani
      @RezaDorrani  11 месяцев назад

      @@AshutoshDubeyCivil Hope it works.

  • @mundopower
    @mundopower 2 года назад +1

    You are a myth! Thanks!

  • @2007pradipta
    @2007pradipta Год назад

    for me ThisItem.Thumbnail.Small is blank .

    • @RezaDorrani
      @RezaDorrani  Год назад

      Not sure why that would be the case. Il recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/

  • @debasishroy4173
    @debasishroy4173 2 года назад

    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.

    • @RezaDorrani
      @RezaDorrani  2 года назад

      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