Skip to main content

12 posts tagged with "Office Scripts"

Office Scripts for Excel, Written in TypeScript and Run from Excel or Power Automate

View All Tags

Build an Overtime Timesheet App in Power Apps — Part 13: Create the Monthly Payroll Workbook with Office Scripts

· 38 min read
Jagdish Kumawat
Founder @ Dewiride

Payroll pays overtime from a spreadsheet, so on the 1st of every month they get one: an Excel workbook of the month's approved overtime, entry by entry and person by person, saved in a library only they can open, with a link in their inbox. This part builds it with an Excel template, an Office Script and two flows.

How to Pass a List of Records to an Office Script from Power Automate

· 7 min read
Jagdish Kumawat
Founder @ Dewiride

To put many rows into a workbook from a flow, don't run a script once per row: pass the whole list to one script call. The script declares what a record looks like and takes an array of them, and the Run script action takes the flow's array in one piece once you select Switch to input entire array.