Power Platform Community Forum Thread Details

In Excel,

Value of first row is "a", and the next subsequent rows are empty, those needs to be filled with the value same as the first row i.e "a" until it encounters other value. The moment it gets the value "d" the next rows after "d " should be "d" replacing the empty values and so on irrspective of number of rows below it.

For Eg: The input is,

and the Desired output should be,

Categories:

Power Automate Desktop

Hi @Swatiba ,

Here is a sample flow logic. if required customize it as per your need.

Copy & Paste to flow designer

Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''D:\\Fill Excel\\Sample Data.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.GetFirstFreeRowOnColumn Instance: ExcelInstance Column: $'''H''' FirstFreeRowOnColumn=> FirstFreeRowOnColumn
LOOP LoopIndex FROM 2 TO FirstFreeRowOnColumn STEP 1
Excel.ReadFromExcel.ReadCell Instance: ExcelInstance StartColumn: $'''H''' StartRow: LoopIndex - 1 ReadAsText: False CellValue=> ExcelData1
Excel.ReadFromExcel.ReadCell Instance: ExcelInstance StartColumn: $'''H''' StartRow: LoopIndex ReadAsText: False CellValue=> ExcelData2
IF ExcelData2 = $'''%''%''' THEN
Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: ExcelData1 Column: $'''H''' Row: LoopIndex
END
END

If I have answered your question, please mark my post as Solved.

If you like my response, please give it a Thumbs Up.

Regards

Kaif