cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
venseben
Helper V
Helper V

Filter array with blank values

Hi all. I have an Excel table, where I need to filter away all the rows where the field "Admin" is empty. I have made the filter this way:

FilterArray2.png

But when I have a look at the body all the rows with blank admins is still present. Can anyone tell me what I am doing wrong? 

FilterArray.png

Thanks in advance

 

/Frank

1 ACCEPTED SOLUTION

Accepted Solutions

Please use the is not equal to condition:

 

Snag_a7841ff.png

 

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

4 REPLIES 4
ekarim2020
Super User
Super User

Hi @venseben ,

 

Please try the following to see if this gets the results you need:

Snag_a067c24.png


Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

mobashee
Community Support
Community Support

Dear Partner,

 

Created Excel with blank Name 

mobashee_0-1662392420096.png

Added filter array

mobashee_1-1662392444853.png

Result:

+++++++++++++

I am able to fetch only the blank values 

mobashee_3-1662392535771.png

 

 

 

 

Did I answer your question? Please consider to mark my post as a solution to help others.

 

Regards,

Mohamed Sanuj Basheer

Please use the is not equal to condition:

 

Snag_a7841ff.png

 

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Jesus Christ - was it that simple??? How embarrassing 😐🙄

Thank you SO much

/Frank

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.

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.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,411)