How to trigger Excel AutoFill using power Automate

0 votes
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 (let's say at column 4 and then I have a function there - let's assume it "=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?
Sep 27, 2022 in Others by Kithuzzz
 • 38,000 points • 1,235 views

1 answer to this question.

0 votes
In PAD you may want copy the cell from 1st row and paste to remaining range, might need to use send key ctrl-v.
answered Sep 29, 2022 by narikkadan
 • 86,360 points

Related Questions In Others

0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16, 2022 in Others by Edureka
 • 13,690 points • 1,559 views
0 votes
1 answer

How to convert data from txt files to Excel files using python

Hi , there are few steps to ...READ MORE

answered Feb 16, 2022 in Others by Edureka
 • 13,690 points • 14,675 views
0 votes
1 answer

How to create and download excel document using asp.net

First, download the Open XML Format SDK 2.0. It comes ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
 • 86,360 points • 3,362 views
0 votes
1 answer

How to create Dropdown list in excel using php

Try this: $objValidation = $objPHPExcel->getActiveSheet()->getCell('B'.$i)->getDataValidation(); $objValidation->setType( PHPExcel_Cell_DataValidation::TYPE_LIST ); $objValidation->setErrorStyle( PHPExcel_Cell_DataValidation::STYLE_INFORMATION ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
 • 86,360 points • 3,223 views
0 votes
1 answer

Getting subtraction wrong in excel

Solution: If your values are a result of ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
 • 86,360 points • 2,275 views
0 votes
1 answer

How to make lambda function working on excel365?

Use this: =BYROW(SEQUENCE(5),LAMBDA(b,TEXTJOIN(",",,SEQUENCE(1,5,b)))) The second sequence is changed from ...READ MORE

answered Jan 9, 2023 in Others by narikkadan
 • 86,360 points • 788 views
0 votes
1 answer

Generate number by using Dynamic array (w/o VBA)

Try: The formula in F2: =IFERROR(REDUCE(HSTACK("Name",SEQUENCE(,MAX(D2#))),UNIQUE(A2#),LAMBDA(a,b,LET(c,BYROW(HSTACK(C2#,D2#),LAMBDA(d,MIN(d))),e,FILTER(HSTACK(B2#,B2#&"-"&c,D2#),A2#=b),VSTACK(a,HSTACK(b,XLOOKUP(SEQUENCE(,MAX(DROP(e,,2)))-1,TAKE(e,,1),INDEX(e,,2),0,1)))))),"") If you really happen to ...READ MORE

answered Feb 10, 2023 in Others by narikkadan
 • 86,360 points • 612 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
 • 26,740 points • 1,854 views
0 votes
1 answer

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

answered Sep 24, 2022 in Others by narikkadan
 • 86,360 points • 1,922 views
0 votes
1 answer

How to lock data in excel sheet using POI, leaving cells without any data / the rest of the sheet unlocked

If the cells in a row have ...READ MORE

answered Sep 24, 2022 in Others by narikkadan
 • 86,360 points • 4,300 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.