cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Excel delete row problem or bug?

I have a flow that was working fine for months,  but yesterday started to play up.  I do a list rows in table action then do a delete row action based on that result. The flow is then supposed to add some new rows,  but as it fails it stops. 

 

It was working fine until two days ago. Suddenly I get a fail based on my Key ID.  My Key IDs are unique and I get the error on an  ID no longer exits.  If I debug and scroll through the action  I find it is wanting to delete a row which was deleted some rows earlier.  Why would it suddenly bring it up again to delete?

 

I can no longer get past the problem as it happens nearly every time the flow is run even when IDs are a different set.  Is this a bug as it is pretty important the I work through this issue ASAP?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User
Super User

Re: Excel delete row problem or bug?

Ok,  for those that are interested I at least found a simpler work around to the delete row failure that made process one definitive loop.  Using two integer variables,  StartCount set to 0 and the other CountRows set to number of rows that are to be deleted

Then creating an action of Do Until based Variable Startcount to Equal CountRows.  Then put the Actions:

1. List Rows present in Table
2. Delete rows based on the list
3. Set Variable countrows to equal the new number of rows in the Table at the end of the Delete.  

When the countrows variable equals 0 then the table is empty

This effectively meant that when the Delete rows met with an inability to delete a row,  the loop started again.  I no longer need to have any process based on failure.

View solution in original post

Highlighted
Advocate I
Advocate I

Re: Excel delete row problem or bug?

1. Get the Row Code of the Excel sheet at the start

2019-10-24 10_40_40-PowerApps.png

 

2. Loop through the excel sheet until each row has been deleted

If there's a failure or timeout, try again until the Row Count is zero 


2019-10-24 10_41_48-PowerApps.png

 

View solution in original post

12 REPLIES 12
Highlighted
Dual Super User III
Dual Super User III

Re: Excel delete row problem or bug?

Can you post a copy of the Flow so we can see how it works.  Then we can try to figure out what is going on.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Super User
Super User

Re: Excel delete row problem or bug?

Not really as there are many steps and I am modifying to try and get something workinq

 

But steps are:

 

1. Schedule run  once a day

2. List rows in Table - get data in the template

3. Delay (built in to allow Excel to release file)

4. Delete Rows  based on Two - using KEY ID column which is a unique ID.  The fails regularly now.  When I get it down to a few row it will work.

5. Get my sites from Sharepoint

6. Apply to each - The loops the flow through each of my 29 sites

7. Redo steps 2 and 3 - (delete row action also sometimes fails here if there are too many records)

8. Another delay

9. Add Rows to table

10. Another Delay

11. Get File content of the excel file

12. Send email to site with excel file attached

 

So - have had no issue for many month even when some rowws are greater than 1000

Now in teh last two days it is failing all the time.  I am assuming some sort of change by developers or some sort of issue with one drive now

 

Highlighted
Dual Super User III
Dual Super User III

Re: Excel delete row problem or bug?

There have been some timing issues in FLOW lately due to increases in load.  It could be that the delay in #3 is causing issues.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Super User
Super User

Re: Excel delete row problem or bug?

Must be something like that.  I successfully got it to run,  but had to manage this issue with a work around of at least 6 Configure To run after on fail.  In most cases my loop did not need any is the row number was under 20 but in my larger sites where rows were 200 to 1220 it varied from 1 fail to using all 6.

Highlighted
Super User
Super User

Re: Excel delete row problem or bug?

This problem is now replicating acros my other Flows that do delete rows in Excel on one drive.  Seems something has changed.

Highlighted
Super User
Super User

Re: Excel delete row problem or bug?

This problem is a real pain and now appears to be getting worse.  It was ok for months.  I now have up to 10 list rows and delete actiosn as a work around

Highlighted
Super User
Super User

Re: Excel delete row problem or bug?

Ok,  for those that are interested I at least found a simpler work around to the delete row failure that made process one definitive loop.  Using two integer variables,  StartCount set to 0 and the other CountRows set to number of rows that are to be deleted

Then creating an action of Do Until based Variable Startcount to Equal CountRows.  Then put the Actions:

1. List Rows present in Table
2. Delete rows based on the list
3. Set Variable countrows to equal the new number of rows in the Table at the end of the Delete.  

When the countrows variable equals 0 then the table is empty

This effectively meant that when the Delete rows met with an inability to delete a row,  the loop started again.  I no longer need to have any process based on failure.

View solution in original post

Highlighted
Advocate I
Advocate I

Re: Excel delete row problem or bug?

we're encountering the same issue

after deleting a few rows from the excel sheet, it throws a "The argument is invalid or missing or has an incorrect format"  error

Highlighted
Advocate I
Advocate I

Re: Excel delete row problem or bug?

how do you count the number of rows in the table? 

can you please share the screenshot of your flow? 

Highlighted
Super User
Super User

Re: Excel delete row problem or bug?

I used a simple list rows in table then have a intger variable to is set to Length() of the List rows.

 

Since I start do the Do Until action all my flows work,  but I hav enoted that without this I would be in real trouble.  The process I posted earlier did need modifications to:

 

Do Until Variable1 eq var2   - Variable1 is set to 0 and Var2 is set to list count of the sharepoint list I filter for this

 

Then the steps in are:

 

1. ListRows in table

2. Delete a row based on step one so creates a for each

3. ListRows in table again - Set it to run if 2 fails and run if 2 is successful

4. Set Var2 to be the length of the 3

 

Basically Var2 reduces each time till it eaquals 0 which is Var1

 

You probelm might also be different in do you use a unique value for the key Column?  

 

Highlighted
Advocate I
Advocate I

Re: Excel delete row problem or bug?

1. Get the Row Code of the Excel sheet at the start

2019-10-24 10_40_40-PowerApps.png

 

2. Loop through the excel sheet until each row has been deleted

If there's a failure or timeout, try again until the Row Count is zero 


2019-10-24 10_41_48-PowerApps.png

 

View solution in original post

Highlighted
Anonymous
Not applicable

Re: Excel delete row problem or bug?

Thanks, this seems very useful in fixing an issue I'm having at the moment with deleting rows. 

 

Can I please confirm the expression for the value of the variable CountRows? 

Is it the following: 

 

 

length(body('List_rows_present_in_a_table')?['value'])

 

 

Currently, my flow seems to delete the table rows fine, but then won't stop running. I'm guessing that countRows isn't reducing to zero for whatever reason? 

 

Also, just out of interest, why set the condition for 'do until' to be equal to a variable, StartCount? Why not just set it to 'do until equal to 0', and do away with the variable? 

 

Thanks 🙂

 

Thanks. 

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

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