Find value inside Json

(1) Share

Report

Posted on by aitorNAV

Hello,

We have an action with this json as an output:

{
  "data": [
    {
      "value_id": 311,
      "position": 0,
      "is_enabled": 0,
      "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"
    },
    {
      "value_id": 314,
      "position": 3,
      "is_enabled": 0,
      "is_default": 0,
      "value": "TST - aitor"
    },
    {
      "value_id": 315,
      "position": 4,
      "is_enabled": 0,
      "is_default": 0,
      "value": "BETEA - BEETA"
    },
    {
      "value_id": 316,
      "position": 5,
      "is_enabled": 1,
      "is_default": 0,
      "value": "ABIERTO - abierto"
    },
    {
      "value_id": 317,
      "position": 6,
      "is_enabled": 0,
      "is_default": 0,
      "value": "CERRADO - cerrado"
    }
  ]
}

We need to get the value_id for a certaing bloc, for example, the value_id where value is "JOB00010 - Remodelación de área de recepción". Sure it's something really easy, but I'm new on creating flows and I don't have that mentality...

Thank you all

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (2)

Report

Hey,

you can use the Parse JSon action to make a normal table out of your Json. you just need to create the schema from the example that you've posted here.

the you can use the Filter array action to filter for the record you want.

If this solved your problem please accept it as solution so others can find it as well.

If it helped in any other way consider liking it so we can keep supporting each other.

Was this reply helpful? Yes No
Suggested answer

CFernandes 8,402 Most Valuable Professional on at

Like (3)

Report

Hey Mate,

This is a simple example, I have Initialized a variable with your value...

I have added a Filter Array action to filter the "data" array where "value" is equal to "JOB00010 - Remodelación de área de recepción". with condition

item()?['value'] is equal to "JOB00010 - Remodelación de área de recepción"

This will be return a value that you need.... See the Test Run below....

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
aitorNAV 28 on at

Like (1)

Report
Thanks for for your answers. CFernades, I'm trying to follow your steps. We must tak into account that the json file as the "data" node. I'm quitting 'data', with this definition of the filter:
{ "type": "Query", "inputs": { "from": "@body('HTTP_-_BusinessMap_Custom_Field_Allowed_Values')['data']", "where": "@equals('value',variables('ProjectBC'))" }, "runAfter": { "Set_variable_BCStatus": [ "Succeeded" ] } }

But I get a blank output:

ProjectBC variable has this value:

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (1)

Report

Hey Mate, Can you share the screenshot of the "Condition" you are trying to use?

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
aitorNAV 28 on at

Like (1)

Report

Hi,

Hi wasn't applying correctly the filter item()?['value'], now it works perfectly. And how can I get the "value_id" value for using it?

I need to use it into an URL for doing an HTTP call, and I get this error:

Was this reply helpful? Yes No
Verified answer

CFernandes 8,402 Most Valuable Professional on at

Like (1)

Report

After filtering, you can use a Compose action to extract the value_id from the filtered array using an expression

body('Filter_array')[0]?['value_id']

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
aitorNAV 28 on at

Like (2)

Report

Got it, thank you again!

Was this reply helpful? Yes No
Suggested answer

saikrishnask1 12 on at

Like (2)

Report

You can achive this in Power automate desktop. Try this the solution can help you

Was this reply helpful? Yes No