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

Problem: Add a row to table in my spreadsheet occasionally creates a duplicate row

Add a row to table in my spreadsheet occasionally, not always, creates a duplicate row.

My flow collects data from a Snapform, processes some of the data then saves it as a row in a spreadsheet table. It often works fine. But from time to time I notice I have a duplicate row of identical data. In checking back I confirm the flow has run only once however in the times that I get the duplicates I see that there has been 1 retry in the Add a row into table step:

KarlInOz1_0-1624506173913.png

When I click the View button I see:

KarlInOz1_1-1624506229676.png

However, it seems both the original and the retried entry are made into the spreadsheet. 

The spreadsheet is stored in a SharePoint location.

When I click on the Show raw inputs link, the head part of the info is:

KarlInOz1_2-1624506379305.png

Can anyone give me a heads-up as to where to go next in troubleshooting this?

3 REPLIES 3
DavidZG
Regular Visitor

I also have this exact same behavior on adding a row in excel though it happens more often than I'd like.  Did you have any solutions?  The only option I see to solve it is by directly using the Graph API method found here: https://sharepains.com/2020/06/08/super-fast-update-excel-using-power-automate/ which may work for you but it does involve Azure AD Admin access to generate an Azure AD app and I do not have that ability.  Otherwise it seems like there is an issue with the request timeout of a single request and it being around the 30 second mark.

@DavidZG No, I never found a resolution. It was getting more and more frequent up to around mid-July, with probably every 2nd or so entry doubling up. But the last 10 entries have gone in without a glitch. I agree that it could be a timing/time-out issue. I suspect Azure AD apps will mean extra licencing so I don't really want to go down that path. For now, I'm just monitoring it and I guess I'll need to deal with it again when it shows up. 

DavidZG
Regular Visitor

@KarlInOz1 Just to close the loop on this, I went through the process of getting admins to help set up an Azure app and went through the process of interacting with the Graph API directly using an HTTP call, and long story short for me it seemed to take what looks like the same amount of time and I still got retries and thus duplicates in the excel sheet, I continued hunting to find some articles online that talk about the time taken to add a row (at least when using the Graph API) is related to formula's in the table (and other tables that reference the table) you are adding rows to.  If you reduce the amount of formula's or remove them the then time taken to actually add the row reduces, likely to a point that is reliably below that 30 second timeout that we seem to be hitting.  I tested this by removing the formula's I could and keeping the remaining ones that I couldn't and the add row processing time went from 27 to 40 seconds down to 7 seconds of processing time using the Graph API directly.  So formula's might be something you look at if it becomes an issue for you.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (3,166)