Learn how to build a PDF from your SharePoint data by using Power Apps and Power Automate flow. No premium license, no 3rd party connectors, just simple actions put together smartly. Includes previewing the PDF in Power Apps, dynamic data including images, examples of more complex solutions and even some common errors and questions are covered. If you want to turn your data into PDFs then this is your video. Also, includes a look at the new flow connector in powerapps and the Power Apps v2 flow trigger in Power Automate.
0:00 It Starts
1:04 Demo of PowerApps app for creating a PDF from SharePoint Data
3:08 Connect to our data and view it in a gallery to get started
3:26 Add an HTML Text Control to visualize the HTML for the PDF
3:50 Walk through the process of creating a PDF using Power Apps and Power Automate Flow
5:08 Using w3schools to create HTML
8:50 Using an HTML unordered list in your PDF
11:33 Getting an error when copying and pasting HTML with ” instead of ‘
13:56 Using a Text function in your HTML Body to view a number as currency
15:26 Adding a dynamic image into your HTML for the PDF as base64 img src style width height
16:35 getting the base64 of an image control by using the JSON function
18:32 Creating the Power Automate Flow with the Power Apps v2 trigger to create a PDF using OneDrive for Business Create file and OneDrive for Business Convert File
22:25 Adding the flow to your Power Apps
25:13 Common questions and errors I get about creating a PDF
26:22 A couple of example of complex structures
Power Apps Consulting and training at …(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
I can't seem to be able to avoid using OneDrive. In my Teams environment some of the users have guest status and have access to Sharepoint but not to OneDrive. Once I connect the flow using OneDrive these users loose access to the created app. Is there any way to get PDF to a Sharepoint folder without having to use OneDrive??
thank you for your help that is exactly what I'm looking for ..but I have a question how do you link the icon of the pdf in the items to the html page that you want to generate.. so what I meant is how it generate the exact item data I need!!
Hi Shane, Nice video clears basic concept. But would you have or can you make a video similar to this but instead of using HTML codes to create pdf file it should call a flow which fills up my predesigned word or pdf file.
can you explain about how to create pdf without using one drive or any third-party participation in power automate
Thank you Shane! I have a technical test for a new job I'm applying for, your video helped me a lot. Greetings from Central America.
Anyone have an issue of random instances where the pdf has "show your html text here" it seems that power app sometimes fails to send flow information.
Hi . . . I'm looking to use the HTML box, but without the Gallery. I've been able to display fields correctly with just the DataCardValue.Text working. However, I can't get a people picker field to display correctly. I've tried many things like DataCardValue.DisplayName, but nothing is working. I'm surprised it isn't the same as with the Gallery syntax, like DataCardValue.'People Field'.DisplayName or something similar. Any insight is appreciated. Thank you for all your great videos.
Excellent video!! Thank you!. How would you change the hello.html/hello.pdf to save it under the name of the record. IE in this example under Greg's name ?
Thank you.
Hi Shane, great video, if it's possible I have a question for you, is it possible to rename the PDF file name dynamically?, for example using the employee's last name or another gallery field? tks in advance
Hola! Muchas gracias por sus videos!!! Le saludo desde Guatemala! Con una consulta, cómo se puede adjuntar varios archivos con html? Desde ya muchas gracias
Hi there Shane
Your videos are always insightful and great to watch
Hope you could help with this one with there being no information about this.
I am trying to grab a SharePoint PDF attachment convert it to code 64 in order to send it in a response via HTTP
Think you could figure this one out?
Cheers Shane for another great video. Just wanted to know if there was a method to include multiple images, as opposed to just a single. I've got a Sharepoint gallery, and need to attach up to 20 photos to the required PDF, from a single record in said gallery. Would the method be similar to your video: https://www.youtube.com/watch?v=K74UFYgrKB4? Thanks
AMAZING!!! I've been struggling for days now trying to find an easy free way to accomplish what you just showed us. Thank you Shane!
Another awesome video, thanks! Do you have a video on how to make the file name dynamic?
Hi @ShaneYoung, I want to get the export of all the gallery Items and including their attachments of those gallery records and create a PDF just like you having all the records appended.
I am confused any idea?
Hi Shane,I watched many of your video and they helped me lot❤, but we find out one problem for the PDF generated , the line will be separated if the PDF is over one page. One line will be separated into two part , half of them in the first page , another half in another page. How this can be resolved? We also tried find out some resolution but failed.
Hi Shane, great video, say you wanted to select 3 of the Employees from the Gallery and print their details in an ordered or unordered list how do you do that? add them to a collection then put the collection info into the HTML code for HTMLtext box? I can't seem to get the syntax right!!
Hi Shane, Great Video…big fan from India….
I have two issues where i need your help:
1. How to do for SharePoint list with image attachments (or multiple images)
2. I have copied exactly how you did, but my flow error is occurring in the last two steps of the flow, The flow test is successful but when i run the PowerApp the flow is getting failed..
Thanks in Advance
how many pdf can i save in a Sharepoint list?
Good video and great explanation.
But tell me one thing that how can I download this pdf file directly in my local system from powerapps
So, this is the 5th PowerApps911 video that I have watched today. I am focusing on components and making pdfs. They all have been extremely helpful and have saved me time. Thanks!
Great video, Shane! Thank you for this! I wanted to make use of that laying two images on top of each other. However, even though the HTML looks perfectly fine, the images display one after the other in the PDF after the conversion process. Is this also due to the restrictions of the free integretated PDF converter or did you manage to do this with your presented method? Thanks again for your videos, they are very helpful!
Hi Shane great video again. I am using choices in my form. How do I get that value to appear?
Is it possible in Powerapps, to have a button that takes a screen shot of the final screen in an app, and make it a pdf to store in a OneDrive folder?
Is it possible to just take a file, convert it and save it to SP. I'm getting "Conversion of this file to PDF is not supported." It seems they broke Convert File in 2018 and no solution seems to work. I don't wanna go to power apps, convert to html, save the file, convert it again to pdf etc
Hello Shane; thanks for this awesome video!!! There is any way to generate powerpoint from template in sharepoint list or lib with power automate; whitout premium?
Hi Shane, great video as usual. In my HTML text I'm attempting to pull data from multiple galleries which are linked to multiple SharePoint lists. In SharePoint I have a primary list using its ID as a primary key and foreign key to my other lists. In my HTML text when I filter to get multiple items where my primary key is foreign then I get Invalid number of arguments: received 1, expecting 2 or more…. here is my filter: Filter(Transport.travel_request_id = selectedID), where Transport is my list and travel_request_id is my foreign key and selectedID is a variable set to my primary key. Please help, thank you.
Hi Shane. I am very grateful for your videos. You're my hero. Just one question: how do I make the email go to an account that is in the gallery?
Dear Shane
Can you please add a video on how to add a footer to pdf document generated in this video , I did generate a pdf with a logo but failed to add fixed position footer to my doc . Can you please help me with this.
Hello Shane! Thanks for putting so much information for us about PowerApps. I wanted to ask bout using SharePointIntegration instead of Gallery1.Selected. I have tried a way to use the SharePoint integration to use dynamic information based on selected itmes but cant get it to work 🙁
This is a great video. How would you dynamically compute the file name and also how would you pull other information from the gallery over so you can use it it in the rest of the flow, such as email addresses that you have within the gallery. thanks.