Unanswered

Flow creates record when one exists during automated Excel import

(0) Share

Report

Posted on by Armyrunner

I have created a flow that imports and updates my SharePoint list from an Excel file. As data is added or updated in the Excel file the SharePoint data is updated or new record is created.

I have created the same flow for multiple SharePoint list importing from Excel and they work fine.

I have one flow that seems to be creating new records when one exists, and I cannot figure out what is wrong. I have verified the Excel column value is the same as the SharePoint value when a new record is created which is the test for update or create. The value is two characters followed by a hyphen then five digits. (XX-12345)

I am looking for some assistance and appreciate your time. Below is my flow in detail.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Armyrunner,
Please Confirm the Get Items Action Return any value or not if it does not return any value so I think the problem in Filter Query filed of, Get Items Action So you have use correct Internal column name of SharePoint list For Filter Query.

-------------------------------------------------------------------------
If I have answered your question, please mark post as Solved.
If you like my response, please give it a Thumbs Up.

Otherwise clarify more on requirement If I misunderstood the requirement.

Was this reply helpful? Yes No
Armyrunner 28 on at

Like (0)

Report

Thank you for your reply. Here is what I have done since to identify what is happening.

I deleted the flow and recreated it again hoping it would perform different simply because it is acting very strange. I am getting the same result.

The duplication appears to only be happening on the scheduled run not the test or manual run. I am still testing this theory to prove.

I am confident that I am using the correct internal SharePoint field name
As you can see here, the flow continues to create a new SharePoint record when one already exists for XX-12636.

It should not create but rather update as the filter is based on the SharePoint field and Excel field with the same data value.
I noticed the output shows it created a new record then updated the existing and new record. I proved this by adding 2 new SharePoint columns and entered values in the flow for created and update, so I know how the flow is behaving.

The records in SharePoint prove it appears to be creating and updating at the same time. Here is what is shown after one run of the flow.

The flow output shows it only updated the record:

Any thoughts??? I am lost on this one.

Was this reply helpful? Yes No
Armyrunner 28 on at

Like (0)

Report

Anyone have an idea why this flow duplicates creation of records? I keep deleting the duplicates.

Was this reply helpful? Yes No