cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pdam
New Member

Google Sheets - deleting multiple rows

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!

1 ACCEPTED SOLUTION

Accepted Solutions
v-micsh-msft
Community Support
Community Support

Hi @Pdam,

 

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

23.PNG

 

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

Regards

 

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-micsh-msft
Community Support
Community Support

Hi @Pdam,

 

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

23.PNG

 

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

Regards

 

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

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:
LogicApp Google Sheets.png

 

 

My assumption was right!

You can solve the deletation issue by iterating backwards:

LogicApp Google Sheets For.png

 

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 🙂

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.

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
Users online (1,855)