Skip to main content

Notifications

Power Automate - Using Flows
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

 

 

 

  • Armyrunner Profile Picture
    Armyrunner 28 on at
    Re: Flow creates record when one exists during automated Excel import

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

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

  • Armyrunner Profile Picture
    Armyrunner 28 on at
    Re: Flow creates record when one exists during automated Excel import

    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. 

     

  • Amit_Sharma Profile Picture
    Amit_Sharma 1,569 on at
    Re: Flow creates record when one exists during automated Excel import

    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.

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard

Featured topics

Restore a deleted flow