Append new rows to my excel output file

[andrew.haworth]

Hi there,

I have created an activity to copy patient demographics into a web form. If there are missing data fields in my web form, I wish for the name of the patient to be written into an error file in an Excel sheet.
My flow is as follows

• Read source file & write to data table (with headers)
• For each row in data table, write each field into web form (first two characters of surname, first name, and date of birth)
• Get value: evaluate each field is populated
• If value is null check data table and set text
• If the value is null in the data table - write the patient name in the Excel output file

My question is, how do I append each errored patient as a new row to my excel file? In my testing, the first row is being overwritten as each error is found

Andrew

[omer.ozturk (Ömer Öztürk)]

Hi @andrew.haworth,

You can use Append Range activity. This activity wont override the values. Add it to the next row.

Kindly check the docs.

Append Range

Regards.
Ömer