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
• 27,740 points
203 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
• 51,240 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,640 points
281 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,640 points
7,412 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
• 51,240 points
492 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
• 51,240 points
284 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
• 51,240 points
106 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 in Others by narikkadan
• 51,240 points
27 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
523 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
470 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
• 51,240 points
226 views
0 votes
1 answer
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