Unanswered

Extract value from an object

(1) Share

Report

Posted on by Community Power Pla...

Dear all,

I am building a flow where I want to extract a specific information from a specific object which is inside an array. So far I have done:

1. Filter the array to only have the object I am interested on. (I used "Filter array" action)

2. Remove all the information of the object except the one I am interested on. (I used "Select" action)

3. I have extracted that object from the array. (I used "First(body('Select'))").

Now I have an object as simple as below. BUT I don't know how to extract the value "10" (on this example is 10, but it is a variable and on each run of the flow it will change).

{
 "ID": "10"
}

To add more information. I am looking for an specific file on my SharePoint Document Library, using another property of the file to find it (I am using the barcode value, so I'm sure there is only one. This is the information I used on the Filter array action). So, to find and extract this file on flow, I need the ID number. but so far I am locked on the step I mentioned below.

I hope someone can support on this.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (2)

Verified answer

InterestedBloke 64 on at

Like (3)

Report

Hey Barbarur,

It sounds like you're looking for the Parse JSON Action - it'll translate the Object you're getting into specific fields you can target and drop in as dynamic content in other actions after that.

To tell the Parse JSON action how to interpret your object, you can click the Generate Schema button and paste the content you'll get from that object.
It'll then create a schema automatically and translate any future input.

With this, you might even be able to skip some of the filtering actions earlier.

Hope this helps!

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (10)

Report

Hi @Anonymous ,

You could store this object in a Compose or an object variable, and then use an expression to extract the value.

If you are using compose, then you can use the following expression:

If you are using variables, then you can use the following expression:

Best Regards,

1 people found this reply helpful.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi InterestedBloke and v-bacao-msft, The three options worked perfectly. Thank you very much!

Was this reply helpful? Yes No
FreddieV 157 on at

Like (0)

Report

I am trying to do the same thing, but I am using the outputs from the 'Search user v2' O365 card, but I can't translate this into selecting the individual components of the outputs. Screenshot below:

Does anyone have any ideas about how the expression would look?

Was this reply helpful? Yes No
BKCLabs 2 on at

Like (0)

Report

My very beginner guess would be to make a new step directly after the search, as an "initialize variable" set to an object type, and put the initial value as the output of the "search users" action. This may then let you do the same steps above as the OP was able to do. Of course this will only work if the results of the Search is 1 object. If it will be multiple users, then you will need to make an array variable, and use other actions to pull out the particular object you want.

Was this reply helpful? Yes No
ninjaryder1st 234 on at

Like (1)

Report

How do we separate 3 objects that are not within an array identified with square brackets [ ] ?

The outputs?(Create_a_Teams_meeting)?['body]?['value']?['propertyName']?['joinUrl'}?['value]
has 3 objects 1) a joinUrl, 2) a tollnumber, and 3) meetingID.

I want to use each of those objects separately (create dynamic content to use later).
But parse JSON action doesn't work as they are all within { } curly brackets, and are not arrays identified with [ ] square ones and cannot be parsed (creates an error)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Nin I have the same issue. Any luck?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@FreddieV I have the same issue. Did you get your answer to this?

Was this reply helpful? Yes No
richardxp 2 on at

Like (0)

Report

you can use json() function to convert string to object, then extract ID property like
json(First(body('Select')))['ID']

Was this reply helpful? Yes No
ninjaryder1st 234 on at

Like (0)

Report

Thanks Richardxp.. is the Json() function you referred to a selectable step in building the flow, or a f(x) function we need to write "low code" for? I'm still fairly new to this so I need a more literal step by step instruction of the tool/step used to convert string to object and then how to extract ID property. Appreciate you!

Was this reply helpful? Yes No