I hope everyone is having a good day, i needy your help,
I am using append range activity to append the values in excel.
To write a data to the excel i have template on it. before i am using append range activity i have to clear the data in that sheet without header (header is the template).
I Used the below flow
clear sheet/range/table activity to clear data
2.read range
for each row in a data table
process data
add data row
append range activity
while using clear range it did cleared the data on it, but in append range it write it from the last row which is empty.
in clear range we have to give full row not liek A2:H11 but like 2:11
also instead of clearing and using always…have a template and copy that and use it whenever you need…thsi way the template is fresh and extra steps of clearing all all would not be there