Excel - Delete blank rows

(0) Share

Report

Posted on by raveendrana

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:

General topics

I have the same question (0)

All responses (2)

Answers (0)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
DenmanRC 2 on at

Like (0)

Report

Hello,

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

Rich

Was this reply helpful? Yes No