Automate Excel with Office Scripts and Power Automate

Office Scripts can be created with a few clicks to help with repetitive actions in Excel. Add Power Automate into the mix and you can automate almost anything in Excel.
Learn More: aka.ms/globalexcelsummit/offi...

[@jonsteen]

This is exactly what I needed. I'll be implementing it tomorrow. Thanks.

[@AprilDunnam]

Awesome!

[@gastondemundo9822]

@@AprilDunnam with version of office have the Automate tab?

[@abhijeetrajput6417]

Super awesome.

[@AprilDunnam]

Thank you! Cheers!

[@DoubleBarrelRiot]

Does this only work for the lines that the recording predetermined? Or is it able to sense if there are hundreds of entries in Column B and C and add the formula in as far down as the data goes?

[@journeyonthewheels2317]

Is this automate option available in office 2019?

[@Shankyrana22]

Wonderful 👍

[@AprilDunnam]

Thank you! Cheers!

[@Lahmeinthehouse]

What if you have one excel sheet that you want to use for lookups, based on another file in power automate ?

[@uartim]

You can write a function in your script use 'Run the script through Power Automate' to add your input, which maybe your result from another excel file.

[@reginaldphillips7615]

You’ve been to do this with VBA for decades

[@AprilDunnam]

Ah, VBA, the timeless classic.... It's like the grandpa of low code programming languages