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:

Using connectors

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-micsh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Pdam 5 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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:

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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 🙂

Was this reply helpful? Yes No