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 –
Download the flows –
OneDrive for Business connector documentation –
Download a file in another format –
w3 Schools 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…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
As usual, distinguished in choosing topics, really a smart way, thanks for sharing
Can you please share a video on how to export to Datatable in PowerApps to CSV file.
Hi Reza, thanks for your video. It helps me a lot. I have a question if you can give me some advice. There are some Chinese in my html and when it was converted, it showed disorderly code in the pdf. I 've already add charset=UFT-8 in my html head, but it didn't work. How can I solve the problem? Thanks in advance.
Only a 2mb conversation limit is a killer though
Raza, I cannot map the first compose do you have an idea why?
Dear Reza , first of all thank very much for this video, but i have a question 🙂 , do you think the PDF format keep the same format Of HTML after conversation ?? . thank you
sir I have an error in 3rd flow which filter the dropdown
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
Hi Reza, Can we add a header & footer in PDF converting using OneDrive? If, Yes then please create a video to show.
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
hi can u help me with..Create a Flow of your choice. It should have 2 actions including a condition for yes and no.
Thanks Reza, I have a question can this pdf include attachments? and could we download it when clicking on it in exported pdf?
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.
Again superb and informative video.
I just have a question. Is it possible to insert the attachment/images in a html table. Column 1 could be the description and column 2 is the pictures.
You are my hero! Keep up the good work! ❤
ExportPDFPowerApps Data flow is not available for download
it does not allow me to map, the headers of my sharepoint list do not appear,
I actually, want to have a PDF of gallery items, 1 by 1 and with their attachment photos as you have only exported single record.
I want to export multiple records like that.. how to edit the flow according to that please help?
I actually, want to have a PDF of gallery items, 1 by 1 and with their attachment photos as you have only exported single record.
I want to export multiple records like that.. how to edit the flow according to that please help?
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
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?
Is it possible to use file located at SharePoint?
Hi Reza, How do I use MS Dynamics 365 CRM, Say If I want to get the Data from the Contact record Form Data to an Pdf file and to email this to the Customer, Please advices
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?
Hi Reza,
When I do the exact same as you do in "Export POwer Apps Data to PDF & include tables" I get the error message: The file id '/Permit.html' is not valid. This happens in the action step "convert file".
Any tips?
Thanks!
Thanks so much for all contents u share on powerapps !
Hi Reza. Great film. Last day I tried to replay your work from this video, but I have one problem. I do not know how you add command to
Run this button in Power App. I think about last step Export Power
Apps data to PDF including Images – ExportInspectionReporttoPDF. On
this step you do not show how you did it. Anyone could help me?
When you create the first parameter, which is Compose the "UserEmail", you inform "UserEmail_Outputs". But when I try to link the flow in Power Apps, it doesn't identify. I'm not understanding how you created the variable in "UserEmail".
Rez- Great video – one question though – how do i call the contents of the array in the select step that we mapped , so I can use that in html rather than using an html table – as you did in your inspection report ( The title , notes et)
I need to export to PDF a filtered table between two Date and two Comboboxes. Please, can you help me. I'm New in Power Apps and Power Atomate
It was working fine and suddenly I am getting bad gateway error for "convert file"
Is there a way to do this without one drive for business, i dont have an account for them.
How to create Word document
Hi Reza. Amazing video. Could you explain what command you need to add to run the flow in the powerapps? what is the itemID.
Hi Reza Dorrani can you please help on "how to get html file content with css from dataverse"
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)?
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.
Hi Reza, at 18:09 I can't Map automatically/dynamically the ID and Title. Am I missing a step?
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?
Good morning,
I made a stream that directs to my email. But what I wanted was to have a Button in PowerApps for the user to enter their email and send the PDF to their email. How can I do?
Thanks for your help.
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.
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.
Amazing content as always Reza. What about if I have a gallery with data from SQL? Is it possible to do this?
Hi Reza, From the video, successfully sent the pdf file to my email. However, unable to create a HTML code from my existing PDF template. Do you able to advise how to create htmlcode using the PDF template? Is there any specific software that i should use to convert it.
Thanks
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
Hi Reza, great content! I am making similar tool for personalized certificates so wanted to ask you for the source of HTML you used in this case for the certificate.
I tried to search on the internet but I haven’t found any suitable for me. Can you provide me the source where I can get html? Thank you very much !!!!
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?