I have existing file that i want to update

[mint (Mintoo)]

i have existing sharepoint file that i want to update i.e its few row of data that is used and get few more details now i want to add data in same row that is alredy there for that data

ex.

alredy created data :

data row 1 : tsk , TC1, KMP

using add data row appends data now post process i got status as done

data row1 : tsk , TC1, KMP , done

want to add done in same row

[ashokkarale]

@mint,

Use Office 365 Integration or Classic Scope.

Use For Each Row in Workbook activity to iterate over all the rows available in the file.

Use if condition to check if the current row is the desired one or not. If desired, use write cel activity to update status.

Thanks,
Ashok

[SorenB (Søren Schytz Birk)]

Hello @mint

You could add a new data column for your status (named ‘status’).
Then you could use a For Each Row in Data Tabel and simply assign a value to the column.

Assign CurrentRow("status") = "done"

Regards,
Soren