Delete a row in Excel (Online) when a field is null

[ebic]

Deleting a row in a table in excel based on the Key Value of a field works when there is content, however, the action fails every time when trying to delete rows that have null value.  Please provide a solution if you have one.

Here is an image of my flow:

[abm]

Try adding an IF condition and check the length (using expression) greater than 0 then delete the row.

[abm]

Hi @ebic 

Do you need any further help in this?

[ebic]

@abm,
Yes I still need help. This idea did not work but it spurred ideas too like updating the row so it is not null and them removing it, etc. but none of them worked either.

[ebic]

Do you have an example you can post?

[123213123]

hi ABM, i have the same issue at the moment, can you post an example of the IF condition with screenshot?

[abm]

Hi @123213123 

Try the below

Expression I used above is

length(trim(items('Apply_to_each')?['Age']))

Thanks