# Append New Rows in Bulk, Always Adding

**URL:** <https://connective.celigo.com/t/append-new-rows-in-bulk-always-adding/4684>\
**Category:** Integrator.io\
**Tags:** microsoft-excel-online, microsoft-sharepoint\
**Created:** [May 29, 2025, 7:53pm UTC](https://connective.celigo.com/t/append-new-rows-in-bulk-always-adding/4684 "2025-05-29T19:53:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mitchel\_Laman](https://avatars.discourse-cdn.com/v4/letter/m/7bcc69/32.png) [@Mitchel\_Laman](https://connective.celigo.com/u/Mitchel_Laman)\
**Post date:** [May 29, 2025, 7:53pm UTC](https://connective.celigo.com/t/append-new-rows-in-bulk-always-adding/4684/1 "2025-05-29T19:53:00Z")

</div>

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.

 ![Screenshot 2025-05-29 at 3.51.00 PM](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/1/10a4170acf598c630a03d8da317891ebb0c1a521.png)  
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

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [May 30, 2025, 1:59am UTC](https://connective.celigo.com/t/append-new-rows-in-bulk-always-adding/4684/2 "2025-05-30T01:59:11Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Mitchel\_Laman](https://avatars.discourse-cdn.com/v4/letter/m/7bcc69/32.png) [@Mitchel\_Laman](https://connective.celigo.com/u/Mitchel_Laman)\
**Post date:** [June 4, 2025, 8:04pm UTC](https://connective.celigo.com/t/append-new-rows-in-bulk-always-adding/4684/3 "2025-06-04T20:04:41Z")

</div>

> [@tylerlamparter](#):
>
> adding/updating", require lots of background processing and can be slow. The

Copy that, Tyler. Thank you for the details. We can work within these constraints and adjust our process accordingly.

-mitchel