Power Platform Community Forum Thread Details

I've seen posts from @AJA21 & @Sunshine Gu with no resolution? So asking for my situation:

I have a flow that adds rows to an excel file - a template that will be reused and therefore needs to have rows deleted in the flow before adding.

Is there an action to perform that will delete rows from a table?

Caveat - my table starts @ row 6 (headers) and I want to delete any rows after row 7. Row 7 contains a data validation list that I don't want to lose.

Thank you in advance!

Categories:

Building flows

I would add a column to your spreadsheet named Row that contains this expression: =ROW(). This returns the current row number.
You can then use the List rows present in a table action and add a filter query to where Row gt 7.
Add an Apply to each action set to the data from step 2.
In the Apply to each, add a Delete a row action and set the Key to Row and the value to the Row value of the current item

If the spreadsheet could have more than 250 rows, you'll need to enable pagination.

When posting questions, you need to realize that virtually nobody will know who you are referring to when you include this in your post: "I've seen posts from @AJA21 & @Sunshine Gu with no resolution?" Just post your question and provide screen shots of your flow along with any error messages instead.