Filter array not working

(0) Share

Report

Posted on by DO-17010024-0

Hi,

I am trying to find out why my filter array is not working (likely an easy fix). I have created the example below to outline what I am trying to do.

Where 'Get Items' has been set up like this

An the filter array like this

However, no matter what I do, the outputs are always blank (no outputs)

Can you help?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

rzaneti 4,379 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

By any chance, is your filed_5 a Choice type column? If yes, make sure to select the dynamic content of field_5 Value rather than field_5 when populating the filter query. If the dynamic content is not displayed for some reason, you can simply use the expression item()['field_5/value'].

It happens because the choice fields are objects, and its label (what we see in the List) is allocated in the value property of this object.

For example, this list:

When filtered by Course Type Value:

Returns these outputs (no Type 2 found, but a few Type 1):

However, if I filter it by Course type only:

I get no results:

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Accepted Answer.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/

Was this reply helpful? Yes No
DO-17010024-0 2 on at

Like (0)

Report
Copy link

Link copied!

Hi mate,

Appreciate the response but still no Outputs. See it below.

These are the inputs. You can see "field_5" there.

And here is the source and criteria.

Cheers

Was this reply helpful? Yes No
rzaneti 4,379 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I'm not sure if you used the exact same expression that I recommended in the previous message, but it contains a small error: the value is in lowercase, while the V should be in uppercase. This is the corrected expression: item()['field_5/Value'].

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Accepted Answer.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

item()['field_5/Value']

but not item()['field_5/value']

Was this reply helpful? Yes No