Delete empty rows in excel (excel online connector)

(0) Share

Report

Posted on by CU20081036-0

181

Hi,

I have created a flow to copy current month's data from SharePoint list to Excel saved in OneDrive for business using Excel Online connector and send the file as an email attachment.

Everything works except for deleting empty rows from excel file. I can filter the empty rows from the excel table. However havent been able to figure out the "key Value" for the "Delete row" action. Can someone help me with this please?

Thanks,

Sunitha

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @sunithav

Please see this post

https://powerusers.microsoft.com/t5/Building-Flows/Deleting-Blank-Rows-from-Excel-with-a-Flow/td-p/334510

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
CU20081036-0 181 on at

Like (0)

Report

Abm,

Thanks for the link. Have seen the article. It talks about filtering the empty rows from excel. However deleting those rows from excel still remains unanswered.

Thanks,
SV

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi,

I am not sure you can you delete an empty row without a value? In my knowledge it is not possible.

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
v-litu-msft on at

Like (2)

Report

Hi @sunithav,

It is impossible to delete the row in which every column is blank because when Flow perform delete a row action could not find the key value of the key column, it like delete an item in a SharePoint list should get Item ID, it has no ID of the row, so it can be deleted.

As a workaround, you can create a new table (call it table 2) with the same columns as the original table (I call it table 1).

Table 1 - table need to process:

Table 2 - run result:

After process you can delete the table or keep it just you like, I hope it can help you.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No