cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SumoTechSimon
Frequent Visitor

Deleting Specific Rows in Excel using power automate

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

2 REPLIES 2
StalinPonnusamy
Community Champion
Community Champion

Hi @SumoTechSimon 

 

Overall Steps

StalinPonnusamy_1-1635002024770.png

 

Step by step (Focus)

StalinPonnusamy_2-1635002051606.png

 

StalinPonnusamy_3-1635002099679.png

 

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

 

 

 

StalinPonnusamy_4-1635002122167.png

 

Result (Empty rows not deleted)

StalinPonnusamy_5-1635002212632.png

 

StalinPonnusamy_0-1635001988850.png


Thanks,
Stalin - Learn To Illuminate

 

StalinPonnusamy
Community Champion
Community Champion

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,897)