Power Platform Community Forum Thread Details

Hi,

I have 2 excel files. I read the data from first excel sheet in data table. Second file i will use as template to write data. I want to write data to specific rows starting from row 18.

Problem: There is end line in second file that i want to maintain. if there is less rows from first file the empty rows between end line need to be deleted from second file, if the number of rows with data from first sheet more then when inserting the rows, end line and data in template file need to be move down maintaining the template. then saved the sheet as copy.

Thanks