Append New Rows in Bulk, Always Adding

[Mitchel_Laman]

I have a flow that is using the Append new rows in bulk import from the Marketplace. It is writing data to a shared Excel file in a SharePoint library. An issue that I am experiencing is that rows always seem to be added to the bottom of the document, regardless of the setting in the fields:

• Column to find existing rows
• Source record field to find existing rows

If I run the job and it writes 1,200 records. The next time I run it, there will be 2,400. As if it's not finding and appending, only adding new records to the list.

I've tried using the formats:

• employeeNumber
• $.employeeNumber

Neither option seems to work.

I was hoping the field entry would be a dropdown list that would read the contents of the record, but it seems to be free-form.

I'm thinking my field is labeled incorrectly. The help text does not indicate what the format of the fields should be.

Any thoughts on what I might be missing here?

Thanks as always for the assistance,

-mitchel

[tylerlamparter]

I've removed those 2 fields from the "Append new rows in bulk" flow step as they weren't needed and were confusing. This flow step will only add new rows and it will do it very efficiently. The other options for "adding/updating", require lots of background processing and can be slow. The Excel apis aren't the best to work with.