Create a PDF from SharePoint Data using Power Apps and Power Automate flow for free

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

[MichaelDeBlasis]

You're the MAN Shane! I took your advice and watched this. Then I got on chat GPT 4 and uploaded an existing PDF template, asked it to make it into HTML, and a few cleanup prompts later I had a working HTML template complete with place holders for my dynamic client data. AMAZING! now I just need to make the flow to convert and save it. The easy part.

[MichaelDeBlasis]

I studied HTML code all week and I finally got this working Shane! TY Again! one more thing crossed off.

[SharleneLe]

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!

[dacsch]

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!

[heylergalvez]

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.

[pamsmith]

Yes! Got it to work! Now I need to see about using one of the third party converters because I really need it to be landscape. Awesome video!

[matthewv]

Hi Shane, if you connect this with a form you can also pull all the attachments through and attach to the email if you pass through the List ID to flow from PowerApps.

Also I create the new file in SharePoint add metadata to the file and then attach a copy of the file to the list item tying it all together with a GUID()

[oluwatobiyusuf]

Thanks for another great video. I will definitely try out the image part

[putriayunurbayti]

Thank you for your new lesson.. that was awesome !!

[jesugiovanny]

Thanks Shane, please continue share your knowleadge. Rgds

[PieceFairy]

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!

[lukewolton]

Great video, this might just solve two issues/requirements I currently have with one apps.

[pepex]

I love Power Apps. I hope back to Power Apps sometime. Greetings from Chile 🇨🇱

[dankirchner]

Hey Shane. Awesome video. Thanks for showing the conversion process with the power apps V2. Quick question. Is there a way to show the file size limit before the user exports to PDF. That way they know if the amount of information they are taking out is too much and they need to cut down their selection?

[Worrelpa]

Thanks Shane

Another one of those common asks. Glad you covered the limits at the end to. As that trips up a lot of people.

Some times I wonder if one day things like thos would be easier and that certain features supported the same html rules. I can only dream I guess.

[EdSalinas-]

Good job pretty much anticipating all of the questions I was going to ask: first off if there's a way to do it without One Drive for Business and instead creating the html file in a Sharepoint Library and then converting it to PDF. Second was the landscape question since I want to ultimately create a shipping label for our Logistics Department. It's been a year since this video so maybe there's a more updated solution, but thanks for the video!

[yacobmusic]

Thanks Shane, you're the master!

[vinosuresh]

Shane, Thanks for the useful videos. Request you to share a video about the Indian Rupee comma format

[jonathanlucas]

Another awesome video, thanks! Do you have a video on how to make the file name dynamic?

[fernandoruelasv]

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 :(