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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (2,038)