I have an excel sheet that I am creating using Power Automate.

The sheet is populated with some data from the web and at some point I add a column (lets say at column 4 and then I have a function there - lets assume its "=B2 C2" - now I want to automate the equivalent of double clicking the bottom right corner of the D2 cell (with said formula) to cause it to auto fill downwards... Can this be done with Power Automate ?

(I know I can get the first free row and then loop and insert the above formula to all the cells - but that is way slower than doing an autofill...)

CodePudding user response：

In PAD you may want copy the cell from 1st row and paste to remaining range, might need to use send key ctrl-v