Learn how to dynamically populate a bespoke Excel template file using Office Scripts, how to use the recording tool, create a PDF without using premium actions and some tips on creating your Excel File template. Excel Office Scripts are included as part of One Drive for Business and allow you to create a bespoke script using Typescript BUT do not worry if you are not a programmer – neither am I. The recording tool will write most of the script for you and I will share my solution below to download and try for yourself. Create professional looking PDFs using Excel as a template.
With the provided solution you can create PDFs from Power Apps, Microsoft Forms or List Items on a Microsoft List.
00:00 Intro
00:50 A quick look at the template
01:19 A look at the flow
03:40 Email arrives with PDF attachment
04:18 How to record an Office Script
15:53 A look at my finished Office Script
18:59 Excel Template Tips
20:57 Outro
Office Scripts
Download of Excel File, OfficeScript and Flow (unzip the File to get all 3 files)
Watch more Office Script Demos
…(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
Thanks Damien! exactly the function I'm looking for right now. At least, remaining challenge is how to connect this to capture data once a row is added from a separate sheet 🙂
How do you keep the page breaks you set in Excel in the PDF file?
Thank you so much Damion❤
Hey Damien thanks for sharing this, would love to know if there is a way to add an image to the form whilst keeping aspect ratio correct.
What could be your approach for similar template in MS Word. How would you convert it to PDF?
Is it possible to add attachment as well?