Power Automate - Filter array on string value

Question

In Power Automate I have a Filter array data operation which retrieves the following JSON Input:

[
  {
    "id": "123",
    "email": "[email protected]",
    "mobilePhone": "",
    "countryCode": "TR",
    "preferences": {
      "acceptsEmail": "true"
    }
  },
  {
    "id": "1234",
    "email": "[email protected]",
    "mobilePhone": "",
    "countryCode": "BE",
    "preferences": {
      "acceptsEmail": "false"
    }
  }
]

Notice that the value of the acceptsEmail key is a "true" or "false" string and not a boolean.

Im trying to do the following to filter out all occurences of "preferences": { "acceptsEmail": "false" }

In the filter query i use item()?['preferences']?['acceptsEmail'] in the first field, is equal to in the second field, and false in the third field. When I run the flow the output body is empty and I cant seem to understand why, but im guessing its due to the string values of "true"/"false" not being found by my query.

Update/edit your question to include the Code Peek for that action. In the meantime, for the third field, enter 'false' as an Expression to ensure it is set as a string. — Sam Nseir
– Sam Nseir, Commented Feb 19 at 14:24

frue · Accepted Answer · 2025-02-19 14:57:43Z

2

update the third field as expression string('false') to convert it as a string and be able to filter properly

output:

answered Feb 19 at 14:57

frue

862 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Power Automate - Filter array on string value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related