Answered

Google Sheets - deleting multiple rows

(0) Share

Report

Posted on by 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!

Categories:

Connecting to Data

All responses (4)

Answers (1)

Community Power Pla... on at

Like (0)

Report
Re: Google Sheets - deleting multiple rows

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 🙂
Community Power Pla... on at

Like (0)

Report
Re: Google Sheets - deleting multiple rows

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:
Pdam 5 on at

Like (0)

Report

Re: Google Sheets - deleting multiple rows

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.
Verified answer

v-micsh-msft on at

Like (1)

Report

Re: Google Sheets - deleting multiple rows

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