Unanswered

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

(0) Share

Report

Posted on by Community Power Pla...

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?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

@Anonymous

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

-Ed

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

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

Add a compose shape for each column in your TableUse 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

Was this reply helpful? Yes No