Power Apps Export to PDF

Поділитися
Вставка
  • Опубліковано 23 лип 2024
  • In this video, you will learn how to create a PDF file from Power Apps data using Power Automate flows and the OneDrive connector. We will cover generating the HTML, passing parameters from PowerApps to flow, generating the PDF file using the standard OneDrive connector and then storing the PDF in a data source like SharePoint or sending the generated PDF as an email attachment. This tutorial will also include embedding images & tables into the generated PDF document.
    #PowerApps #PDF #PowerAutomate #SharePoint #OneDrive
    Power Apps export to csv/excel - • Export Power Apps data...
    Download the flows - github.com/rdorrani/Microsoft...
    OneDrive for Business connector documentation - docs.microsoft.com/en-us/conn...
    Download a file in another format - docs.microsoft.com/en-us/oned...
    w3 Schools HTML - www.w3schools.com/html/
    Table of Contents:
    00:00 - Introduction
    00:56 - Use OneDrive connector in flow to convert HTML to PDF
    06:25 - Send dynamic data to generate PDF using OneDrive connector in Power Automate flow
    08:46 - Add image in generated PDF file
    12:19 - Export Power Apps data to PDF & include tables
    16:05 - Export filtered Power Apps data to PDF using flow
    20:33 - Export Power Apps data to PDF including Images
    25:06 - Subscribe to Reza Dorrani channel

КОМЕНТАРІ • 516

  • @alzaimoor79
    @alzaimoor79 3 роки тому +10

    As usual, distinguished in choosing topics, really a smart way, thanks for sharing

  • @OmegaVestoLord
    @OmegaVestoLord Рік тому +2

    Just started a new job fresh out of collage, these videos are helping a lot to get me up to speed on powerapps quickly. There isn't a ton of super specific content on Powerapps and automate, so these videos are highly appreciated

    • @RezaDorrani
      @RezaDorrani  Рік тому +1

      Most welcome and thanks so much!

  • @cmacdhon
    @cmacdhon 2 роки тому +3

    It doesn't matter what type of powerapps functionality I do a Google search for, Reza has video describing how to do it. Absolutely amazing!!

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      That's the goal 😊
      Thank You for watching.

  • @kevindunn212
    @kevindunn212 Рік тому +2

    Reza is the best. Really knows how to break it down and not leave any steps out.

  • @EpicDreamer_
    @EpicDreamer_ 2 роки тому +2

    Thank you Reza! You are light in office 365 world! And don’t be humble because you deserve it!!!!!

    • @RezaDorrani
      @RezaDorrani  2 роки тому +1

      Thank You so much 🙏
      It is the love of my subscribers that drives me to do better work.

  • @fesa7978
    @fesa7978 3 роки тому +1

    Thank you Reza for your generosity. I learn a lot from watching your videos 🙂

  • @joanasousa6233
    @joanasousa6233 2 місяці тому +1

    Everytime a problem arises, there's a Reza tutorial, you've helped me a lot, thank you so much Reza

  • @chadalthaus3866
    @chadalthaus3866 3 роки тому +3

    This is so clever and simple. I hadn’t thought of using HRML and OneDrive. I was only thinking about word templates and converting those to pdf.
    Great video, Reza!

  • @cptcavernicola
    @cptcavernicola 3 роки тому +1

    I have been waiting for this for a very long time ... thank you, Reza.

  • @fabiofilho7660
    @fabiofilho7660 3 роки тому +1

    Reza, I'm from Brazil and I want to congratulate you, your videos help me a lot. ;)

    • @RezaDorrani
      @RezaDorrani  3 роки тому

      Happy to hear that! Love to Brazil.

  • @ccmedranoh
    @ccmedranoh 3 роки тому +1

    Hello Reza, the truth is, thank you very much for your excellent videos, receive a warm greeting from Peru, you help me a lot in my projects that I have been implementing. Thank you so much for everything!

    • @RezaDorrani
      @RezaDorrani  3 роки тому

      You are most welcome. Thank you for watching.

  • @ramon_1992_
    @ramon_1992_ 3 роки тому +1

    Thank you so much for the shared content !! Another excellent video, congratulations !!

  • @ukreddy56
    @ukreddy56 3 роки тому +1

    Very detailed explanation and thank you so much. Happy to say am doing in the similar way in my project ☺️ and now can do even better as you said. Thanks again...

  • @bradjareczek5827
    @bradjareczek5827 2 роки тому

    Great "flow" in your tutorial here. Great delivery and content. Thank you for sharing.

  • @shibubhai5790
    @shibubhai5790 3 роки тому +1

    Thanks for this video Export to PDF. I'm waiting for long time. That's awesome.

  • @sujisam5508
    @sujisam5508 3 роки тому +1

    Thanks for sharing this Reza! Really useful.

  • @TSHORYUKEN
    @TSHORYUKEN Рік тому +1

    Thanks so much for all contents u share on powerapps !

  • @AmrAlOmari
    @AmrAlOmari 3 роки тому +1

    Thanks a lot, just amazing, looking forward to try it on the weekend

  • @Deadpool12353
    @Deadpool12353 3 роки тому +3

    I love your channel, its very detailed organised and fits viewers requirements..other ms developers please learn from reza.

  • @MyThefury
    @MyThefury 2 роки тому +1

    Simply awesome - you are simply the iron man of powerapp

  • @alfonsolans
    @alfonsolans 2 роки тому +1

    Reza awesome stuff Brother keep rocking thanks for being so great to all of us appreciate it

  • @volkanz18
    @volkanz18 Рік тому +2

    You are my hero! Keep up the good work! ❤

  • @LandscapeInMotion
    @LandscapeInMotion 2 роки тому +2

    Very nicely explained Reza - and practical! Personally, I would generate all the HTML in the PowerApp, and just pass the HTML as a variable to convert to Flow to convert to PDF.

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      If HTML is generated in Power App and any change is needed, one would have to change the App + publish the App.
      Ideally, I would read the HTML from a configuration list.

    • @LandscapeInMotion
      @LandscapeInMotion 2 роки тому

      @@RezaDorrani yeah that’s a great point. So you would only have to deploy the flow when changes are needed. Having said that, I’ve been creating Flows within the powerapps editor, but they don’t appear in Power Automate - do you know why?

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      @@LandscapeInMotion they do. In same env where App is created

  • @hendrixkalusokoma7105
    @hendrixkalusokoma7105 5 місяців тому

    You are the MAN. Thank you again

  • @ericmild4050
    @ericmild4050 3 роки тому +1

    Very good video. I always appreciate your videos.

  • @billimantecas
    @billimantecas 2 роки тому

    Excelent video thanks I learn very much with your tutorials

  • @salaheddinemekhlouf428
    @salaheddinemekhlouf428 3 роки тому +1

    Thank's Reza , very interesting !

  • @sofiejensen3804
    @sofiejensen3804 2 роки тому +1

    so simple - so good!

  • @allancaetano64
    @allancaetano64 2 роки тому +1

    Great video, Reza!

  • @TheDistractionStudio
    @TheDistractionStudio 3 роки тому +1

    Thank you Reza!! 🎩’s off

  • @GozersHouse
    @GozersHouse 3 роки тому +1

    So useful, great video

  • @shaktidas5704
    @shaktidas5704 2 роки тому +1

    Hi Reza,
    Your videos are really amazing. I am loving watching these. I am new to Power Platform and having total 10 years into SharePoint technologies. Though I have learnt Power Apps and Power Automate from various different sources, I haven't done any real time project end to end. Just wanted to check if you have any Demo video project end to end, which I can practice and gain some more confidence and which will be helpful for my Power Platform job hunting. Thanks :)

    • @RezaDorrani
      @RezaDorrani  2 роки тому +1

      Most of my videos are step by step tutorials.
      Check playlists on my channel, I did live training sessions which may help.

  • @ayihtchesco7988
    @ayihtchesco7988 3 роки тому +1

    Honestly, I was wondering how to achieve this, thank you

  • @RanjitSingh-xk9sb
    @RanjitSingh-xk9sb 3 роки тому +1

    Thank you for the great information. We implemented this functionality last week.
    Now I know why word-break css was not working.

    • @RezaDorrani
      @RezaDorrani  3 роки тому

      Thanks for watching. I hope in a future update it supports the word-break css.

  • @booter654
    @booter654 3 роки тому +1

    Great explanatory skills, Reza. I am an MCT & have never cracked such ease of successful knowledge transfer. Good work!

    • @RezaDorrani
      @RezaDorrani  3 роки тому

      Thank you for your kind words!

  • @brokenSnake
    @brokenSnake 3 роки тому +1

    The part where you passed the data set using Json from canvas app to the flow is really cool. Just a question though, is it possible to use parse Json instead of the select action to turn the Json into objects that can be used to create the html table?

    • @RezaDorrani
      @RezaDorrani  3 роки тому +1

      Yes, you can directly use parse json.

  • @dingersu
    @dingersu 2 роки тому +1

    So that's how to solve the img problem 🙌🙌 thank you :-)

  • @rusticfittings1
    @rusticfittings1 2 роки тому

    You are a genius

  • @denizc2849
    @denizc2849 3 роки тому +1

    thank you!

  • @elissandramaria6471
    @elissandramaria6471 Рік тому +1

    thank you to dhare your knowledge, Im wondering how did you do on Select action in the field map, to organize only the specific fieds 'Id' from the json

    • @RezaDorrani
      @RezaDorrani  Рік тому

      Video description has link to download the flow

  • @user-ju8hf2qd2w
    @user-ju8hf2qd2w Рік тому +1

    Reza this is AMAZING VIDEO :) Now I can extract all receipts from All Items Attachments and make one file :) What would I do without you? :)

    • @RezaDorrani
      @RezaDorrani  Рік тому

      What would I do without all of my subscribers? :)

  • @ceciliachan9616
    @ceciliachan9616 2 роки тому +1

    Dear Mr Dorrani, Thank you so much for your teaching. It is a simple and clever way to easily accomplish the tasks. By the way, instead of using png file in the demo, may I know if we could embed other files as jpg, tiff, docx. to the single HTML page as well?

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      Thanks for watching and liking the videos.
      Embedding images would require getting the base64 code and then add them to the HTML. Note that this approach is limited to small file sizes only. Images will quickly hit the limit.

  • @paolovr1970
    @paolovr1970 Рік тому +1

    Thanks a lot Reza, always clear and amazing.
    But if I've the storage of inspection photo on SQL table stored on a varbinary colum, do you think I can use your solution? Html need a src URL link of the pictures 🤔

    • @RezaDorrani
      @RezaDorrani  Рік тому

      My solution would not work with SQL. I do not have a video reference on SQL scenario. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

  • @susanclark1778
    @susanclark1778 2 роки тому +1

    This is very helpful - I just have issue as I am using a gallery.selected to pull a certain row in a table with attachments. I am not certain how to execute on the power app side to tell the flow what to pull, any guidance would be appreciated. Thanks for doing these videos!!

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      I would have to look at your App and scenario in action to provide any guidance. I would recommend to post your query with screenshots on the forums at powerusers.microsoft.com

  • @samosborne7712
    @samosborne7712 3 роки тому

    Thanks for your videos. I have learned a lot reviewing them. One question, can you dynamically name the created pdf?

    • @RezaDorrani
      @RezaDorrani  3 роки тому

      Yes you can! We are naming the document when creating it in flow. We can use dynamic content or add expressions to define the dynamic naming of the files.

  • @mblherry
    @mblherry 2 роки тому +1

    Thanks very much for this demonstration. Question: For the HTML content can I pass content from an HTMLEditor.text component?

  • @violettabybina6996
    @violettabybina6996 Рік тому +1

    Hello Reza, as usual video is super helpful! Thank you a lot!
    One question. Content that i save to pdf doesn't fit well in the file. Landscape format might be better solution but when pdf is generated I don't know how to define landscape format to the file or maybe inside HTML format i can condition portrait format.

    • @RezaDorrani
      @RezaDorrani  Рік тому

      The pdf generation technique shown in video does not provide those options. You would need to look into 3rd party premium connectors.

  • @Ram92026z
    @Ram92026z 3 роки тому

    HI @Reza, I have seen almost all your videos pertaining to my project but just in case I have missed, do you cover any "Import" of data from say, an MS Word Template or any other file format? I have seen all your 'export videos but not the other way around. Thanks.

    • @RezaDorrani
      @RezaDorrani  3 роки тому +1

      I have not covered any importing of data.
      Importing data from word document would be a challenge. Excel would be a better option.

    • @Ram92026z
      @Ram92026z 3 роки тому +1

      @@RezaDorrani , Thanks a lot for your response.

  • @christerrussberg3059
    @christerrussberg3059 3 роки тому +1

    Hi Reza, a very good presentation (as always...). But one question. Have you any exemple where you create a PDF from PowerApps including Office files (Word/excel).

    • @RezaDorrani
      @RezaDorrani  3 роки тому

      I'm assuming you want to convert word or excel files to PDF. The showcased technique using flow onedrive to convert will work with word and excel.
      docs.microsoft.com/en-us/onedrive/developer/rest-api/api/driveitem_get_content_format?view=odsp-graph-online

  • @harrietscott9513
    @harrietscott9513 3 роки тому +1

    Thanks for the video! Quick question - the Power Automate flow is not showing up in my Power Apps. I can see previous flows I have made but not this one. The flow is tested and running with no issues. Any idea how I can connect this to Power Apps please?

    • @RezaDorrani
      @RezaDorrani  3 роки тому

      Check to see if you have built the flow in the same environment as the App.

  • @harioachira
    @harioachira 2 роки тому +1

    Hey Reza, thanks for this wonderful wonderful video. Any way to attaching this pdf fle automaticaly to sharepoint list attachement ,while pressing the Export button?

    • @RezaDorrani
      @RezaDorrani  2 роки тому +1

      You can use flow to add these as file attachments to list item. I have done some videos on my channel where I have done something similar. You will need to look through those.

  • @genaricheta5823
    @genaricheta5823 3 роки тому +1

    Thank you for the demo! But a question, is there a way for the recipient to be dynamic? For instance, whoever users who would use the app would receive the exported PDF via email. I believe this part was hard coded on your video because you sent the email to your email.

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      Possible. You can pass the email of the recipient as a parameter to flow.

    • @BenjaGm
      @BenjaGm 2 роки тому

      Nice question, did you solved it?

  • @loadcvdaily1142
    @loadcvdaily1142 3 роки тому +1

    Hi Reza, thanks for your video. I want to ask how Id and Title from powerapps show (18.04) in select ? I tried many times I didn't find the way. Thanks for your attention.

    • @RezaDorrani
      @RezaDorrani  3 роки тому

      By using expressions. Video description has link to download the flows.
      I have even made the app available at github.com/rdorrani/PowerApps/blob/master/InspectionApp_20210518155834.zip

  • @TheGingerFuchs
    @TheGingerFuchs Рік тому

    If i have a report with 10 section that needs to be populated from a sharepoint list with ~200 columns including image columns. I have it running for a single image/text combo, but am wondering if PA would run into performance issues or if I could even create that many actions? Batching by section and merging might be an option?

    • @RezaDorrani
      @RezaDorrani  Рік тому +1

      That seems to be a lot of columns. Not sure if you would hit any size limits. Check documentation to see about limits.
      This video uses OneDrive connector which definitely has a small size limit and your scenario would not fit. You would need to look into 3rd party premium connectors.

  • @twangt
    @twangt 3 роки тому +1

    Great Video as usual!
    Do you have any video examples on how to use the PDF viewer? For example view files from a SharePoint document library. If not, that could be very interesting to know more about! :)
    Keep up the good work!

    • @RezaDorrani
      @RezaDorrani  3 роки тому +2

      I have one video coming next week that uses the PDF Viewer. The document in that case comes from list attachments.
      For PDF viewer to show data from a library, you would need flow. Check this - ua-cam.com/video/ut0g7hsWoC4/v-deo.html

    • @twangt
      @twangt 3 роки тому +1

      @@RezaDorrani Aha I understand! Thanks! :)

  • @fanzfanzilla
    @fanzfanzilla Рік тому +1

    Hello Reza, thank you for one more great tutorial. I have an use case where by I want to generate a PDF that has signature block which user signs using a smart card (PIV or CAC) and hits submit which saves the file as part of the app and sends the email to the next person in the workflow to review/approve/sign it with a smart card. How can this be achieved?

    • @RezaDorrani
      @RezaDorrani  Рік тому

      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.

  • @andrewpndavies
    @andrewpndavies 2 роки тому +1

    Really enjoyed this video. Can the same technique be used to create a pdf from a Microsoft list stored in sharepoint, along with images?

  • @byronmakesnoise
    @byronmakesnoise 2 роки тому +1

    Awesome tutorial.
    Have a quick question, how would you export each list entry, individually? As soon as a new entry is created, a button on PowerApps should be able to export to pdf only, the last created entry.
    Is this possible?

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      Possible. When an item is created, onsuccess call the flow and send the ID.
      I do not have a video reference on this specific scenario though. I would recommend giving it a shot and in case of issues, posting your issue with screenshots on the forums at powerusers.microsoft.com

  • @abhivijayakumar
    @abhivijayakumar 9 місяців тому +1

    Hi Reza, thanks for the insightful video. A quick clarification: Is there a way to bypass the create file in onedrive and create a file directly in SharePoint since my list may have large data? I was able to create a html file and save it in a Document library.

    • @RezaDorrani
      @RezaDorrani  9 місяців тому

      The convert to pdf is a OneDrive only action.

  • @MyanmarOnline
    @MyanmarOnline 3 роки тому +2

    Thanks for your useful information. You already have videos on "Export to Excel" and now "Export to PDF". I'd like to request a video on "Export to Word" that use share point list data. The scenario is in Powerapps view page, we'll have a link or icon to click to export to predefined word template. Thanks you in advanced.

    • @RezaDorrani
      @RezaDorrani  3 роки тому +2

      I will add it to my backlog but I would need a lot more folks requesting it to start working on a video. Word templates are a premium feature.

    • @kayfax672
      @kayfax672 2 роки тому

      Hey, I had the same issue because of having to create contracts and memos with a lot of dynamic values including a lot of if statements in different languages, so what I came up with is creating the text content including tables as Html in PowerApps, then a button creates a blank but named Word file in a specific file location including metadata using a template path file content and opens it in Word, then user can copy/paste the HTML into, save, done. It also writes the file link back to the app, so you can re-open if needed to adjust. That way, you can us CD headers and footers etc. without the Word connector.

  • @MrAbueslam
    @MrAbueslam 2 роки тому +1

    Thank you for your great video and effort , I am not sure how to get the html for my power apps form (in my case purchase order) that I need to convert to pdf

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      You would need to create an HTML. There is no direct way to get it.

  • @wellyadeirawan
    @wellyadeirawan 3 роки тому +1

    That's a great video, Reza, really helped me...
    I'm looking for how to export to pdf using filtering in PowerApps
    can you share how to enter ID and Title in JSON Select...
    Thanks for advance

    • @RezaDorrani
      @RezaDorrani  3 роки тому +1

      2 ways, you can filter data in App itself and pass filtered collection to flow or query data source in flow and perform query.
      Most of this is covered in the video.

  • @martincodd
    @martincodd Рік тому +1

    This video is great.
    I am having an issue though where I use a Lookup column in my list but the flow does not return the selected item but instead the GUID. Is there a workaround?

    • @RezaDorrani
      @RezaDorrani  Рік тому

      I will have to look at your App/flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

  • @Figgyinchains
    @Figgyinchains 2 роки тому +1

    Great video Reza!
    Question: at 22:00 you mentioned you're passing the ID, but every time I try to do this I get the options "Compose_Inputs" or "Body"
    What am I doing wrong here? I feel like I'm missing steps here.

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      When clicking on "Ask in Power Apps" to get the parameter from power apps, the name of the action will determine the name of the parameter. In my case I renamed the compose action to ItemId and then did ask in power apps.

  • @cdackply
    @cdackply 2 роки тому

    Hello Reza,
    Can we use "Convert file (Preview)" action in production environment for html to pdf conversion. Is it still a preview feature and will it cause any issues in the future?
    Thanks in advance.

    • @RezaDorrani
      @RezaDorrani  2 роки тому +1

      It has been in preview since 2+ years. It's the only free action that allows that.
      There are 3rd party actions (premium) that offer more flexibility & are NOT in preview.

  • @emiliomadrid7285
    @emiliomadrid7285 2 роки тому +1

    your videos have helped me a lot.
    Thank you very much for sharing.
    How can I make the columns go down as rows? I have added 6 columns and only 4 are visible

    • @RezaDorrani
      @RezaDorrani  2 роки тому +1

      There is a width limit. For wide column scenarios this would not work. Columns changing down to rows would be complex and would need usage of flow expressions.
      I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

  • @brendanv666
    @brendanv666 2 роки тому +1

    Hi Reza, how would the Get items function work where the choice column in Sharepoint allows multiple selections? I found that I think a "Apply to each" would need to happen?

    • @RezaDorrani
      @RezaDorrani  2 роки тому +1

      It would add that apply to each loop. You can use the join expression to convert all the multiple selections into a string and use in document.

    • @brendanv666
      @brendanv666 2 роки тому

      @@RezaDorrani thanks mate that worked. Also sorry to hear about what happened.

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      @@brendanv666 🙏

  • @sandeephancysandeephancy5191

    This is good. If we have Multiple screens to print and each screen contains images and some text fields is power automate is suggested or better going with html code. If so how that would be getting images dynamically for print purpose?

    • @RezaDorrani
      @RezaDorrani  Рік тому

      Videos shows how to export data. Not printing. Print function supports single page only. Dynamic images - assuming you mean - images being passed to flow is shown in video

  • @justasking8217
    @justasking8217 2 роки тому +1

    Amazing content as always Reza. What about if I have a gallery with data from SQL? Is it possible to do this?

    • @RezaDorrani
      @RezaDorrani  2 роки тому +1

      Concept should work with any data source.

  • @shivisharma3712
    @shivisharma3712 Рік тому

    Thank you for this wonderful idea!!!
    There is two mail send to the receipt after trigger the flow.
    How can I send only one mail ?

  • @sachinjain3482
    @sachinjain3482 3 роки тому +1

    Great; thank you sir,
    I have tried this and working.
    But i have one question In my html content is rotted 90 deg and the html is showing 90 deg but after conversion in PDF content is not rotating.
    Can you please share that this conversion support rotation or not?

    • @RezaDorrani
      @RezaDorrani  3 роки тому

      I believe rotation is not supported.

  • @dariaditzel3996
    @dariaditzel3996 3 роки тому +1

    Hey Reza, thanks for this very insightful video. We have a usecase of a damage report app, where multiple images can be uploaded per damage case. The idea is to create an official document, including some basic information, signatures and of course, images. Atm we use flow to fill in a Word template (HTML is too complex for our citizen developers) and then convert it to PDF-document. One issue is with flexible images count: so it might be a case with 3 damages, each with different amount of pics. We solved it with multiple Word templates, but then the interesting part comes where we need to merge multiple PDFs into one PDF-file (due to 2 MB limitation we cannot create just one Word/PDF). Did you have such a usecase and maybe have an idea how to solve this issue? Thanks in advance for your response.

    • @RezaDorrani
      @RezaDorrani  3 роки тому

      I have not done much work with the word template feature and the merge PDFs feature. Both of these are premium connectors.
      In the video I try and show how to achieve some of them using standard connectors.
      I am not aware of the limitations of those premium connectors or any workarounds.
      I will recommend you check on the forums at powerusers.microsoft.com/

    • @bl4747
      @bl4747 Рік тому

      there is a workaround using Library of Docs and using Tags

  • @Thaara1424
    @Thaara1424 11 місяців тому +1

    Hello Reza, Thank you for the Innovative Ideas, I'm searching for a flow which converts the attachments in sharepoint list from word attachments to pdf attachments and could update the same list in attachments. Is it possible, else give me some idea abt it. Thanks

    • @RezaDorrani
      @RezaDorrani  11 місяців тому +1

      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.

  • @guigamerboy
    @guigamerboy 2 роки тому +1

    Hi Reza. Amazing video. Could you explain what command you need to add to run the flow in the powerapps? what is the itemID.

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      ItemID is the ID of the item for which you need the data to be exported.
      Video description has links to download sample flows. Video explains how the value is passed.

  • @williamm8460
    @williamm8460 Рік тому +1

    Hi Reza, Great video!
    I wanted to know what the HTML was that you sent from PowerApps for the Inspection Report was?
    I've attempted the version of this approach you posted recently, however it was unsuccessful for me, and the test inspection use-case is definitely far more simple.
    Cheers

    • @RezaDorrani
      @RezaDorrani  Рік тому

      I picked simple HTML from w3schools. All references are in video description.

    • @williamm8460
      @williamm8460 Рік тому +1

      @@RezaDorrani Apologies, have been back through the video. I see the code you mentioned.

  • @feltreter1032
    @feltreter1032 2 роки тому +1

    Your video Really Help me understood alot about PowerApps and the flow!! Do you have video shows passing combobox values from powerapps to flow? My PowerApps has several comboboxes and each one allows multi filter values. Don't know how to pass each combobox's values to the flow?? Make it more complicated, my app also has a input text box for users to enter text for filtering. Greatly appreciated!!

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      I do not have a video on passing combox box info.
      I will recommend you check on the forums at powerusers.microsoft.com/

  • @dimosgrigoropoulos274
    @dimosgrigoropoulos274 5 місяців тому +1

    Great video and thank you for all of your videos they have been a great help. I have something similar and I got the flow to work but what is the trigger that goes in powerapps for the flow. I want to be able to export the form to pdf upon submit for example. Thank you.

    • @RezaDorrani
      @RezaDorrani  5 місяців тому

      Trigger is as shown in video

    • @dimosgrigoropoulos274
      @dimosgrigoropoulos274 5 місяців тому

      @@RezaDorranithank you for your reply. I think I said it wrong. I am trying to figure out where to get the ID required in flow to put in powerapps. I am new to all this and learned a lot from your videos.

    • @RezaDorrani
      @RezaDorrani  5 місяців тому

      @@dimosgrigoropoulos274 Video description has link to download the flows. Its been a long while since I did this video hence do not remember the specifics.

  • @johanhaasbroek9952
    @johanhaasbroek9952 2 роки тому +1

    Hey Reza, thanks for this awesome video! You're channel is helping me so much its crazy!
    I just have one question:
    I am trying to create a pdf from filtered table just like you have done. In your video at 18:10 is where I get completely lost.
    When using the select function how do I specify the data points I want to print "Enter value" column?
    It looks like you are using power apps variables, but this flow has not been activated yet so we dont have those variables yet? I also don't think I should be adding new variables because then the flow is looking for additional values in powerapps and in this use case we only give the flow the user email as well as the Json data.
    So how do I specify in the Select function which "columns" I want printed to pdf? When I click on "enter value" I don't see the column names to choose from. I only see my created variables (Email & data) as well as outputs from the data and email compose variable functions. But nowhere do I see the JSON data's columns to choose from
    I hope my question makes sense. I would really appreciate your feedback as I am extremely stuck at this point.

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      Those are not variables. Those are data points from the JSON object passed from apps to flow. To get those data points, you would need to use expressions.
      Video description has a link to download the sample flow.
      For the Select action if you go to peek code, you can look at the expressions.

    • @johanhaasbroek979
      @johanhaasbroek979 2 роки тому +1

      Reza thank you so much! Now I get it.
      You are the best!

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      @@johanhaasbroek979 Thanks

    • @johanhaasbroek9952
      @johanhaasbroek9952 2 роки тому

      @@RezaDorrani Hey Razi, I have gone to your github to download the flows.
      But in both of the flows you uploaded you don't use the select action in either of them so I am struggling to know how to write the expressions to specify the data points I want using the select action.

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      @@johanhaasbroek9952 Use expression item()?[‘PropertyName’]

  • @loadcvdaily1142
    @loadcvdaily1142 2 роки тому +1

    Hi Reza, thank for sharing. I wanna ask you how did you manage the size of html while you had more than 1 images (photos) in one file? Html file size cannot bigger than 2 MB rite?

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      2MB is the limit. My images captured had small sizes. Power Apps mobile app - under settings - Optimize images on upload was turned on for me.

    • @loadcvdaily1142
      @loadcvdaily1142 2 роки тому

      @@RezaDorrani I'm sorry, where did you turned on optimize images? where we can see those settings? thank you

    • @RezaDorrani
      @RezaDorrani  2 роки тому +1

      @@loadcvdaily1142 In mobile app, open power apps, click on profile image on top left and you should see that option in menu.

  • @mkavo
    @mkavo 2 роки тому +1

    Hi Reza, this is excellent.
    Do you know can you create the PDF based on your dataverse data within Model Driven app directly or just need to embed the canvas app within the Model Driven app form?
    Cheers!

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      There are options in model driven apps where you can call a flow.
      You can also add a custom page (canvas app) in model driven apps. Better option that embedding canvas app.

    • @mkavo
      @mkavo 2 роки тому +1

      @@RezaDorrani Cool, I was assuming to have the PDF icon that initiates the Flow I need to put the custom page (canvas app) into the model driven, but if same can be achieved without it then great!!

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      @@mkavo It can be done. Model driven apps can call flow.

  • @vinayayinapurapu
    @vinayayinapurapu 3 роки тому +1

    became an power addict.. will be power expert learning from your videos soon.. Great stuff my friend.. Also is there an link to inspection app? working on similar use case.

    • @RezaDorrani
      @RezaDorrani  3 роки тому

      Thank You.
      No link yet. I have one more thing to add to the App which will I will showcase in my video next week and then plan to share the entire App.

    • @vinayayinapurapu
      @vinayayinapurapu 3 роки тому

      @@RezaDorrani hey can’t wait to watch it. Btw congratulations on new home 🏡😎

    • @RezaDorrani
      @RezaDorrani  3 роки тому +1

      @@vinayayinapurapu That is not my home. I was just walking around a neighborhood and saw a new construction and took some pics as I thought it would fit well for my use case 😊

  • @derrickkuria4206
    @derrickkuria4206 2 роки тому

    Hi Rezza, I am creating a reporting tool that I write Notes on Power Apps and Convert into PDF and send it to SharePoint and an Email. Also, I never got the other tools to format PDF.

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      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

  • @user-ju8hf2qd2w
    @user-ju8hf2qd2w Рік тому

    Hello Reza, can you please advise or show direction how to extract all sharepoint list items with images (receipts) your help would be much appreciated.

    • @RezaDorrani
      @RezaDorrani  Рік тому

      I do not have a reference on this scenario and something that would be a challenge for flow with high volume of data. I recommend checking on forums in case someone has done something similar powerusers.microsoft.com

  • @dheaindah4855
    @dheaindah4855 Рік тому

    hai Reza, thank you for your video, but I have a problem about the pictures size in pdf. I make a flow from sharepoint list attachment, can you give the cooding for the format size of HTML coding ?
    thank you

    • @RezaDorrani
      @RezaDorrani  Рік тому

      Video description has link to download sample flows. You can check the code in it.
      Alternatively, I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

  • @wendybarrera3348
    @wendybarrera3348 Рік тому

    Thank you Reza!! If I need the PDF horizontally? is it possible with this flow? In the html, I wrote the codes so that it is horizontal, but it always comes out vertically. The problem is that I have a table with 9 columns and the information is not complete.

    • @RezaDorrani
      @RezaDorrani  Рік тому

      You cannot do that with this approach. You would need to look at 3rd party connectors.

  • @patricklittle9068
    @patricklittle9068 2 роки тому +1

    Reza ... great video that covers a lot of territory. One question on a key point that I'm missing. I am trying to imitate the sequence where you export filtered data to PDF using flow, except I am sending the values from an unfiltered collection. After I get to the Select/Data Operations at around 18:07 and enter 'json(outputs('Data')), I am unable to do any mapping. Specifically, when I select 'ask powerapps', it does not show or allow me to select any of the column headings. Is there another video you've prepared that has those details? I suspect I am missing something simple. :( Thank you! r/ Patrick

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      For those you would need to write expressions as follows:
      item()?[‘propertyname’]

  • @ayaala4896
    @ayaala4896 Рік тому

    Thanks Reza, I have a question can this pdf include attachments? and could we download it when clicking on it in exported pdf?

    • @RezaDorrani
      @RezaDorrani  Рік тому

      I’m not sure about attachments. My guess is No.

  • @ThePassiontea
    @ThePassiontea 2 роки тому

    what is the code you use for your onSelect button in 20:35 ( export Power App data to PDF including Images). I have managed to get the flowing working, but i have no way to create the button.

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      Code is to call the flow from Power Apps and pass parameters.
      Example: ua-cam.com/video/emAhLzVG9bM/v-deo.html & ua-cam.com/video/1_F9msqF-f8/v-deo.html

  • @thiagodalmora5110
    @thiagodalmora5110 5 місяців тому +1

    Hello Reza. Thank you! I just have a question: Is there any chance that the Convert File (to PDF) have go to error if the file exceed an size limit? For me, looks like 20MB it's the size limit, but I need to include a bunch of images in PDF, that will exceeds this limit . Do you know if there's any other solution?

    • @RezaDorrani
      @RezaDorrani  5 місяців тому

      Check documentation on size limit. There may be 3rd party premium connectors that offer bigger file sizes.

  • @ppei2012
    @ppei2012 3 роки тому

    Reza, your videos are high quality guaranteed. Thank you for sharing! I have one question: I could not add ID and Title dynamic contents to my flow because Ask in PowerApps will not generate those fields. How can I make them available to my flow?

    • @RezaDorrani
      @RezaDorrani  3 роки тому

      Ask in Power Apps should generate parameters in flow. This is in built behavior. If its not generating then there must be some bug which you would need to report to MSFT.
      I typically tend to add a compose action, and within compose select ask in power apps which generates the parameter for flow.

    • @ppei2012
      @ppei2012 3 роки тому +1

      @@RezaDorrani Thank you!

  • @mangeshmalvankar5957
    @mangeshmalvankar5957 3 роки тому +2

    Hey Reza, thanks. I have been waiting for this solution very long time. I have a question- On Select data operation if I have to Split values for specific column field(On key value pair- for Value field), how can I add expression for it. I am struggling with the solution and appreciate your help. Thanks

    • @RezaDorrani
      @RezaDorrani  3 роки тому +1

      Split expression depends on your data, your schema etc. Not possible to provide guidance here on chat without looking at your solution.
      I will recommend you post your query with screenshots on the forums at powerusers.microsoft.com/

    • @mangeshmalvankar5957
      @mangeshmalvankar5957 3 роки тому +1

      @@RezaDorrani Sure. Thank you

  • @mustafahussainmohsin320
    @mustafahussainmohsin320 Рік тому

    Hi @RezaDorrani I want to export to PDF all of my gallery items to a PDF along with their Attachment pictures if they are attached..
    is there video? I am kinda stuck

    • @RezaDorrani
      @RezaDorrani  Рік тому

      I 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

  • @ashlyg5286
    @ashlyg5286 2 роки тому +1

    Reza , Thanks for this video.
    Is there any way to generate pdf with multiple records with multiple images?
    This video shows pdf generation for images in a single record.

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      I do not have a video reference for multiple record scenarios.
      I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

  • @ntk1348
    @ntk1348 3 роки тому +1

    As always great work Reza. Is there a way to get the generated pdf back into the PowerApp and open it in Acrobat Reader? Thanks!

    • @RezaDorrani
      @RezaDorrani  3 роки тому

      Shhhhh. That is my next video coming soon :)

    • @ntk1348
      @ntk1348 3 роки тому +1

      @@RezaDorrani Amazing! Can't wait for that!

  • @LannaSanches
    @LannaSanches 3 роки тому

    Thanks! Would you know how to turn left the pdf file?

    • @RezaDorrani
      @RezaDorrani  3 роки тому +1

      I don't believe it is possible with the standard connector options. You would need to use 3rd party connectors for that.

  • @salonibansal3111
    @salonibansal3111 3 роки тому

    Hi, can you share the html style code you used to style the table,
    I have created the html table and added it in the compose action, when i add the dynamic content into the html and runs it, the data keeps falling out of the table. All content is not visible

    • @RezaDorrani
      @RezaDorrani  3 роки тому

      Check ua-cam.com/video/VnWg-Eox37Q/v-deo.html for HTML Table styling.
      I will have to look at your flow in action to provide any guidance related to your issue. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
      I have also made the sample App (which includes the connected flows) available for download at github.com/rdorrani/PowerApps/blob/master/InspectionApp_20210518155834.zip

  • @thanhthule4564
    @thanhthule4564 6 місяців тому +1

    One more time, it remains super brilliant work even after 2 years. Thank you for the video. One question about one scenario, I submit a form, whose data is fed into a template in Power Apps and then converted to PDF for preview and submit. How can I save this submitted pdf file as an attachment of an item created in SP list (together with other details of the form), not a pdf file created in SP library? Thank you!

    • @RezaDorrani
      @RezaDorrani  6 місяців тому

      Thanks!
      How and where are you saving the pdf?
      You could use flow to attach as list item. This is not something I have tried though.

  • @jortemanss2826
    @jortemanss2826 Рік тому

    Can you also edit the size format of the pdf file? I have a power bi paginated report that doesn't fit horizontally in a normal pdf size.

    • @RezaDorrani
      @RezaDorrani  Рік тому

      Its limited in formatting options. Check documentation on pdf function.

  • @soulaimanhatim7838
    @soulaimanhatim7838 2 роки тому +1

    Dear Mr Dorrani, Thank you so much for your teaching. May i know if there is any way to generate powerpoint by template with power automate (without premium please, and using powerapps and sharepoint list/documents)?

    • @RezaDorrani
      @RezaDorrani  2 роки тому +1

      Thanks for watching the videos and liking the teaching style.
      I am not sure about ppt with flow. Look if there are any APIs for it or check on forums if anyone has done something similar powerusers.microsoft.com

    • @soulaimanhatim7838
      @soulaimanhatim7838 2 роки тому +1

      @@RezaDorrani ok thanks for your response

  • @mir3264
    @mir3264 2 роки тому

    I'm trying to send exported pdf of list item along with it's attachment in single approval email. So far I'm able to make them work individually, but can't figure out how to append attachments from multiple get items (Exported pdf and List attachments) into the Append to array variable. any tips would be appreciated. thanks.

    • @RezaDorrani
      @RezaDorrani  2 роки тому

      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