cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Community Support
Community Support

Re: Flow is creating duplicate entries

 

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
Highlighted
Dual Super User III
Dual Super User III

Re: Flow is creating duplicate entries

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!



Highlighted
Community Support
Community Support

Re: Flow is creating duplicate entries

 

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

Highlighted
Frequent Visitor

Re: Flow is creating duplicate entries

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!

Highlighted
Frequent Visitor

Re: Flow is creating duplicate entries

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!

Highlighted
Community Support
Community Support

Re: Flow is creating duplicate entries

 

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.
Highlighted
Dual Super User III
Dual Super User III

Re: Flow is creating duplicate entries

@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!



Highlighted
Regular Visitor

Re: Flow is creating duplicate entries

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.  

Highlighted
Dual Super User III
Dual Super User III

Re: Flow is creating duplicate entries

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!



Highlighted
Regular Visitor

Re: Flow is creating duplicate entries

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

Highlighted
Dual Super User III
Dual Super User III

Re: Flow is creating duplicate entries

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!



Highlighted
Regular Visitor

Re: Flow is creating duplicate entries

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

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,826)