Unanswered

Deleting Specific Rows in Excel using power automate

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

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

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
SH-21101628-0 12 on at

Like (0)

Report
Copy link

Link copied!

@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!

Was this reply helpful? Yes No