Unanswered

Deleting Specific Rows in Excel using power automate

Like (0) Share

Report

Posted on 23 Oct 2021 11:58:36 by SumoTechSimon

I have an flow that allows me to add rows to a table and it works great with lots of funky formulas in excel being applied once the data is there. The logic I use is:

RMAXXXXXXXX.Run(ThisItem.Company, ThisItem.Company, ThisItem.RMAAutoNo, ThisItem.Product, ThisItem.'Serial #', Today(), ThisItem.'Product Description')

However, at the point I run this flow again I want to first clear all the rows APART FROM a blank row which contains the funky formulas.

So my question is: How do I delete those rows in a table in Excel that are not blank using my flow as my blank row contains my formulas. I have tried putting my formula in variables in the flow but Excel doesn't like this.

Be grateful for any help you can give.

Simon

Categories:

Dataflows

All responses (3)

Answers (0)

SH-21101628-0 12 on 11 Nov 2024 at 14:26:16

Like (0)

Report

Deleting Specific Rows in Excel using power automate

@StalinPonnusamy -

I've tried this with my flow and the flow succeeds, but the file is not clean.

What detail am I missing?

Caveat - my table starts @ row 6 (headers) and I want to delete any rows after row 7

Thank you in advance!
StalinPonnusamy Super User 2024 Season 1 on 26 Oct 2021 at 01:04:26

Like (0)

Report

Re: Deleting Specific Rows in Excel using power automate

Hi @SumoTechSimon

Please let us know if anything needs on your post. We can help with this.

Please mark the post as Solved If I have answered your question.
Please give it a Thumbs Up if you find the suggestion helpful

Thanks,
Stalin - Learn To Illuminate
StalinPonnusamy Super User 2024 Season 1 on 23 Oct 2021 at 15:17:19

Like (0)

Report
Re: Deleting Specific Rows in Excel using power automate

Hi @SumoTechSimon

Overall Steps

Step by step (Focus)

length(items('Apply_to_each')?['TASK_ID'])

Result (Empty rows not deleted)

Thanks,
Stalin - Learn To Illuminate