web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow creates record wh...
Power Automate
Unanswered

Flow creates record when one exists during automated Excel import

(0) ShareShare
ReportReport
Posted on by 28

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.

 

Armyrunner_0-1670874041339.png

Armyrunner_2-1670874396492.png

 

 

 

Categories:
I have the same question (0)
  • Amit_Sharma Profile Picture
    1,569 Super User 2024 Season 1 on at

    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.

     

  • Armyrunner Profile Picture
    28 on at

    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 

    Armyrunner_2-1671077167962.png

    As you can see here, the flow continues to create a new SharePoint record when one already exists for XX-12636.

    Armyrunner_8-1671078389018.png

     

    It should not create but rather update as the filter is based on the SharePoint field and Excel field with the same data value. 

    Armyrunner_3-1671077273899.png

    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.

    Armyrunner_10-1671078943580.png

     

    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. 

    Armyrunner_9-1671078617707.png

     

    The flow output shows it only updated the record:

    Armyrunner_7-1671078082937.png

     

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

     

  • Armyrunner Profile Picture
    28 on at

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

    4C7D9F0B-8A1E-4339-ABFD-D2FD64512B25.jpeg

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard