Create professional PDF in Power Automate using Office Scripts (Non Premium)

No video

Create professional PDF in Power Automate using Office Scripts (Non Premium)

Рет қаралды 7,830

Күн бұрын

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
support.microsoft.com/en-gb/o...
Download of Excel File, OfficeScript and Flow (unzip the File to get all 3 files)
github.com/DamoBird365/PowerA...
Watch more Office Script Demos
• Office Scripts Please buy me a coffee www.buymeacoffee.com/DamoBird365 ☕

Пікірлер: 17

@NeilHarper1 2 жыл бұрын

Thanks Damien. This is great. Very clear and concise. Literally ticks all the boxes I was looking for. (Excuse the pun) 😀

2 жыл бұрын

I really appreciate all your efforts spending to provide such detailed instructions about Power Platform and Office apps features. I lost my mobile iPhone in Aberdeen, 2 days later someone found it and called my emergency contact with Scottish accent (obviously), and I managed to get it back. Since then, I am happy to hear anything with Scottish accent. Sorry for the side note 👍🏻Kudos to you.

@DamoBird365 2 жыл бұрын

Glad you got your phone back 👍 and thanks for your kind words.

@moyura2 Жыл бұрын

Very useful, I'll try to create one. Thanks for sharing.

@almondjuliusquidato Жыл бұрын

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

@basehumax Жыл бұрын

Thank you so much Damion❤

@GregDolan 2 жыл бұрын

Great vidoe - I'm loving this stuff. Looking forward to more 🔥

@DamoBird365 2 жыл бұрын

Cheers Greg. Have you got any potential use cases or video requests?

@GregDolan 2 жыл бұрын

@@DamoBird365 Would love an addition to the send unique emails with HTML table from excel data video. I'd have a use case where I'd like to mirror the data as an excel attachment also. So the unique email would have the table but also an excel attachment with the same data 😁

@GregDolan 2 жыл бұрын

Also, I'd definitely be interested in a vidoe explaing the syntax and what things like expressions, strings and variables are, from the ground up kind of. And a walk through of things like 'apply to each', 'compose' and the other options available. That would help my understanding alot. Thanks for your vidoes, I think there gold ✨️