Power Automate

Check if value exist in Json

(1) Share

Report

Posted on by aitorNAV

Hi all,

I'm new with flows. This is how the first part look like:

I'm getting the job list from BC, and for each project, I must find it in the json I'm getting from the HTTP call. In the check action I'm always getting false, I'm not capable to find the correct way to do it. Probably it's a stupid thing, but I'm getting mad...

Thank you all

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,452 Super User 2025 Season 2 on at

Like (1)

Report

Hi

Need more information as I dont see any details related to the data.

1) Please show the JSOn Data

2) please show your Condition details so we can compare them to the JSON to tell you why its false each time.

Was this reply helpful? Yes No
aitorNAV 28 on at

Like (0)

Report
Thanks for your answer. The body of the output json of the HTTP call is this:
{ "data": [ { "value_id": 311, "position": 0, "is_enabled": 1, "is_default": 0, "value": "JOB00010 - Remodelación de área de recepción" }, { "value_id": 312, "position": 1, "is_enabled": 1, "is_default": 0, "value": "JOB00020 - Decorar sala de conferencias" }, { "value_id": 313, "position": 2, "is_enabled": 1, "is_default": 0, "value": "JOB00030 - Muebles de oficina nuevos" } ] }

And the condition I'm using for comparing is

"type": "If",

"expression": {

"and": [

{

"contains": [

"@body('HTTP_-_BusinessMap_Custom_Field_Allowed_Values')['data']",

"@items('Bucle_proyectos_en_BC')"

]

}

]

}

Thank you

Was this reply helpful? Yes No