cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ebic
New Member

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

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:

 

2019-11-06_12-03-09.png

6 REPLIES 6
abm
Super User
Super User

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi @ebic 

 

Do you need any further help in this?



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

@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.

Do you have an example you can post?

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

Hi @123213123 

 

Try the below

 

image.png

 

 

Expression I used above is

 

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


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,355)