Answered

filter array if item is empty OR " "

(0) Share

Report

Posted on by JD-03091828-0

I am looking to do a filter array in my power automate flow to remove empty list items. The problem I am running into is this: the flow is not recognizing " " as being empty:

Before Filter Array:

After Filter Array:

Expression that I am using for the filter array is this:

My question is how do I write a Filter Array expression to filter out empty OR " " items? I'm trying a number of different things and nothing is working. Any guidance would be much appreciated. Thanks!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Building with Why 351 Moderator on at

Like (0)

Report
Copy link

Link copied!

Your current expression filters out empty, but string(' ') is not an empty value.

Have you tried equals(item(), string(' '))?

If so what other options have you tried? If not and that expression works, please mark my reply as answered.

Was this reply helpful? Yes No
JD-03091828-0 75 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the suggestion. How would I combine these statements to check for both empty AND " "? It is possible that in my flow, both situations may arise. Thank you!

Was this reply helpful? Yes No
Suggested answer

chiaraalina 1,851 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi

Please try this: @and(not(empty(item())), not(equals(item(), ' ')))

Was this reply helpful? Yes No
JD-03091828-0 75 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the suggestion! When I entered this formula into the Filter Array:

I received the following error:

Was this reply helpful? Yes No
chiaraalina 1,851 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi

Is this error related to the Filter array step?

Can you screenshot the steps before the filtering?

Was this reply helpful? Yes No
Verified answer

Chriddle 8,672 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Use function trim() to remove whitespace before check if empty:

empty(trim(item()))

is equal to

false

Was this reply helpful? Yes No
JD-03091828-0 75 on at

Like (0)

Report
Copy link

Link copied!

This worked beautifully - thank you!

Was this reply helpful? Yes No