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?
@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?
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
My expressions looks like this:
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Look out for new contribution recognition badges coming SOON!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
The top training and networking event across the globe for Microsoft Business Applications