cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rs_it
Frequent Visitor

Flow is creating duplicate entries

I have created a flow that when a new item in a SharePoint list is created a row is added to an Excel spreadsheet.   Each time a new item is created it is creating duplicate or triplicate runs for this same new item.  The first run of the flow of course is expected, but the others that run seconds after for the same item are not expected. Below are screenshots of my flow.  Does anyone have any suggestions on how to resolve this, or a way to improve the flow?

https://imgur.com/P9KB3rn

https://imgur.com/F6vvOkZ

1 ACCEPTED SOLUTION

Accepted Solutions
v-bacao-msft
Community Support
Community Support

 

Hi @rs_it ,

 

Please try to refer to the following method:

119.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

11 REPLIES 11
efialttes
Super User III
Super User III

Hi
The trigger you are using is 'When an item is created or modified'. From your screenshots I see the trigger followed by two steps and then a condition, in the true branch the Excel related action Add a Row. Does your flow include more steps afterwords? If the answer is yes, is any of them an Update item? If so, you can enter a neverending loop unless you apply conditions in your trigger to avoid it.
Hope this helps


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



v-bacao-msft
Community Support
Community Support

 

Hi @rs_it ,

 

Please try to refer to the following method:

119.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Thank you for this suggestion @v-bacao-msft! I have tried that method, but it is still creating duplicates when an new item is created.  Do you have any other suggestions?

 

Thank you!

rs_it
Frequent Visitor

Hi @efialttes ,

 

I do not have any more steps after the true branch that adds the row in Excel.  Do you have any suggestions with this in mind?

 

Thank you for your help!

 

Hi @rs_it ,

 

Very strange, I checked the method I provided again, it will check if there are records with the same ID in the table, and only add new records when the result is 0.

When the item is changed, the condition judgment result is false, then no new record will be inserted.

 

Do you have other Flows that have similar logic to insert duplicate records into this table?

 

You can check the Flow run history and see if each step is as expected.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@rs_it 

Did you finally solve this issue?

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



I am adding entries the other way round, From excel to SharePoint and it’s doing the same thing.

 

imagine I have 150 items in an excel file and I add a new one.  It’s duplicates that new one 150 times.  

Hi!

Can you share a screenshot from your current flow design?

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



How do I upload images, it keeps asking me for the source but I don't have anywhere on line I can put them ?

Hi!

if you need to share a screenshot from Power User editor, make sure you are writing from a desktop browser client (I believe mobile browsers does not display this menu) and do the following:

 

Flow_UploadImage.png

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



I can’t do this as our company has blocked this option.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (960)