Populate your Excel templates dynamically using Office Scripts and Power Automate

preview_player
Показать описание
In this 15-minute all user-focused demo, Damien Bird steps through an automated invoice generation scenario using Excel scripts, Power Automate and no tables in Excel. Solution elements include 2 lists containing data and an Excel invoice template with scripts in SharePoint + a cloud flow in Power Automate. Flow actions pull data from lists, run script in template to populate an Excel file for each customer, creates pdf invoices. Excel invoices stored in document library, PDF files in OneDrive. This PnP Community demo is taken from the Office Add-ins community call – May 2021, recorded on May 12, 2021.

Demo Presenters:
• Damien Bird (DamoBird365) | @DamoBird365
• Nancy Wang (Microsoft) | @nancyatMSFT

Supporting documents:

Stay connected:
  1. Microsoft Community Learning
  2. SharePoint
  3. PnP
  4. Dev
  5. community
  6. open-source
Рекомендации по теме
Populate your Excel 0:15:13

Populate your Excel templates dynamically using Office Scripts and Power Automate

Populate Excel Template 0:19:17

Populate Excel Template using Power Automate and Office Script

Excel Office Script 0:10:04

Excel Office Script Tutorial - Populate an Excel File Dynamically from Power Automate

Create a new 0:14:06

Create a new Excel File in Power Automate and dynamically populate with a Table and Rows #Excel

How to populate 0:04:32

How to populate a word document with data from Excel Automatically

Document Merge Microsoft 0:07:08

Document Merge Microsoft Excel Template using Office Script & Power Automate #OfficeScripts

Power Automate Export 0:16:27

Power Automate Export to Excel | Dynamically create Table, Columns & Add Rows to Excel | Send Em...

Automatically Update Data 0:17:57

Automatically Update Data in Another Excel Worksheet or Workbook - 3 Methods

EASILY Make an 0:14:52

EASILY Make an Automated Data Entry Form in Excel

Excel Invoice Template 0:10:09

Excel Invoice Template that Adds New Lines Automatically

Dynamic Outlook email 0:05:36

Dynamic Outlook email template from Excel table

How to use 0:01:26

How to use an excel dropdown list and vlookup to auto-populate cells based on a selection

Auto-Populate Other Cells 0:08:04

Auto-Populate Other Cells When Selecting Values in Excel Drop-Down List | VLOOKUP to Auto-Populate

Dynamic Data Templates 0:09:32

Dynamic Data Templates in Excel 365

Power Automate - 0:05:03

Power Automate - How to create Excel table dynamically (Excel Formula)?

(1/2) Automating Word 0:04:37

(1/2) Automating Word Documents from Excel - No VBA

How To Automatically 0:06:15

How To Automatically Pull In New Report Data Into Excel Using PowerQuery

Inserting cell values 0:05:00

Inserting cell values into shapes in Excel - the 1st step to building dynamic dashboards

Create interactive excel 0:40:32

Create interactive excel dashboard in 5 simple steps #exceldashboard #exceltutorial #pivottable

How to Enter 0:01:03

How to Enter an Automatic Time Stamp into Microsoft Excel

Different ways to 0:07:51

Different ways to work with Microsoft Excel in Power BI (2023)

Modern Excel Data 0:10:20

Modern Excel Data Entry Work Form Tutorial

How to Automatically 0:01:54

How to Automatically Copy a Range of Data in Excel

SUPER EASY Excel 0:06:22

SUPER EASY Excel Data Entry Form (NO VBA)

Комментарии
Автор

if you deleted an item in the sharepoint, would it affect the created files???

susannafung
Автор

Wow this is so amazing. Exactly what I needed. Does Office Script require additional license outside O365 suite?

kittydoes
Автор

Can you update your links please? 404's

nocodecreative
Автор

That is so awesome!!! time to play with excel scripts.

rohanshaw
visit shbcf.ru