Google Sheets - deleting multiple rows

[Pdam]

I am having trouble deleting rows in a Google aheet using Flow. I can "get rows" successdully, but the flow errors on the next step of "delete row" (for each) ... I can't figure out what to put in row Id so that it doesn't error. Any pointers appreciated!

[v-micsh-msft · Accepted solution]

Hi @Pdam,

For the Row ID field, input the dynamic content "PowerApps id" in this field should work.

If you have any further questions on this issue, please post back.

Regards

[Pdam]

Thank you for the assist - this worked a treat! I am just dipping my toes into Flow and it has the makings of a great business user tool and a quick and simple integration widget.

[Thomas]

That doesn´t work with more then ~10-20 rows!

It seems that the ID´s were changed during the deletation. Or some caching mechanisms took place.

The FOREACH-Loop starts with the first row, which is in general a bad idea. All further lines will now move up a row.

Having 220 rows to delete, will create errors on line: 22, 25, 29, 41, 43, 44, 47, 52, 61, 62, 63, 66, 73, 78, 84,..... and so on.

{ "status": 404, "message": "The line with the key \"824b9845d6294096828b1fb9e848e550,85\" was not found.\r\nclientRequestId: 8df6361b-fd32-44b1-8d49-b148761c444e", "error": { "message": "The line with the key \"824b9845d6294096828b1fb9e848e550,85\" was not found." }, "source": "googledrive-we.azconn-we-01.p.azurewebsites.net" } 

I´ve alternatively tried to delete and create a new sheet, but that is not possible due to the lack of connectors.

Currently, I have not found a suitable solution to copy all rows from an Excel-Sheet on a OneDrive 4 Business

to a Google Sheet.

 

It doesn´t matter using a Flow or a LogicApp, tried both.

 

It´s simple as that:

[Thomas]

My assumption was right!

You can solve the deletation issue by iterating backwards:

Declare two variables: The maximum number of rows and the current row.

Set the max row -1 to the current row.

Use an Until-repeater where the current row equals zero.

Then delete this very row and reduce the current row counter.

body('Zeilen_abrufen')?['value'][variables('RowCounter')]?['__PowerAppsId__']

That´s it!

Now you have to keep an eye on the max. amount of calls to the Google Sheets-Connector. It might happen, that you have to wait for several seconds after a couple hundred calls (Deleting and adding combined).
But that is another topic 🙂