web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Excel - Delete blank rows
Power Automate
Unanswered

Excel - Delete blank rows

(0) ShareShare
ReportReport
Posted on by

Hello,

 

My query is how to set up within flow an automated process that deletes blank rows from a table in excel?

 

I have set up a flow which takes an Excel attachment from an email and saves it into a Sharepoint location.

 

The attachment is a download from a website and as the number of rows returned is variable, I have set up the template to include a table with more rows than will be required. This excel file saves in the Sharepoint location succesfuly but now I want to add actions that remove the blank rows 

 

 

Categories:
I have the same question (0)
  • yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    Hi @raveendrana 

     

    Currently flow cannot detect for any null values to map further in the delete a row action for the excel connector. refer (https://powerusers.microsoft.com/t5/Building-Flows/Delete-empty-rows-in-excel-excel-online-connector/td-p/370005)

     

    To delete a row, you need to have atleast one column that has some value to be identified in the action power automate. 

     

    Hope this Helps!

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

  • DenmanRC Profile Picture
    2 on at

    Hello,

     

    Did you manage to solve this? I have the exact same issue. Thanks

     

    Rich

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard