cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pwrappr01
Level: Powered On

How can I delete all blank rows from an Excel table?

I am creating an Excel table in a workbook I upload and am wanting to delete the blank rows from inside of it. I cannot figure out how to filter the table to just the blanks before doing an "apply to each" that deletes all blanks. Any suggestions?

4 REPLIES 4
Super User
Super User

Re: How can I delete all blank rows from an Excel table?

@pwrappr01 

Is this a one-time thing? Or something you want to do a bunch automatically?

 

-Ed

pwrappr01
Level: Powered On

Re: How can I delete all blank rows from an Excel table?

@edgonzales, this will apply when the file is first uploaded but not have to occur in the future.

Super User
Super User

Re: How can I delete all blank rows from an Excel table?

@pwrappr01 - OK, probably best to do that before the file is uploaded, but assuming that's not an option there might be other things to do depending on what is happening next.  Can you give some context as to what the rest of the flow looks like, and what you're trying to do?

 

Thanks!

-Ed

Jcook
Level 10

Re: How can I delete all blank rows from an Excel table?

@pwrappr01  Hello,

 

How many columns do you have? If it is not too many follow my instructions below.

 

The only requirement is that there is a ID column

 

pic1.pngAdd a compose shape for each column in your Tablepic2.pngUse a Condition and use the 'empty' expression for each of the columns..

 

My expressions looks like this:

empty(outputs('Firstname'))
empty(outputs('lastname'))
empty(outputs('title'))
 
This will return true if all those fields are empty within the record/row
 

--Josh

 

If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

 

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,614)