In this video, I will show you how to automate Microsoft Excel repetitive work using an Office Script with Power Automate.

What is Office Scripts:

Office Scripts in Excel on the web let you automate your day-to-day tasks. You can record your Excel actions with the Action Recorder, which creates a TypeScript language script.

You can also create and edit scripts with the Code Editor. Your scripts can then be shared across your organization so your coworkers can also automate their workflows.

You will learn:

1) Apply formatting to excel data

2) Add dynamic formulas

3) Pass data from Power Automate to excel and use it in excel formulas

4) Pass data from Excel to Power Automate

Thank you for watching.