How to extract a specific name/value from JSON using Flow Designer utilities

[gjz]

Hello,

I need some help understanding how to extract one name/value pair from a JSON object in Flow Designer.

My flow is using the Active Directory AD v2 spoke "Look up Objects by Filter".  When it finds the object, I want to extract just the value returned in the 'samaccountname', not all the other fields.  I thought I could accomplish this using the utility function "Get item from Name/Values" but it doesn't work.

Here is the object that is returned from the Spoke, I want to retrieve the value "TotalNewR" to use in a later step:

This is the output data from the spoke:

Here's how I configured the function - for now I just want to display it in a log until I get it working.

Is this possible to retrieve the data this way or do I have to write a custom action to parse the JSON object returned from the spoke?

[skelchie]

Hi gjz,

please be aware, that you are looking up objects witch your previous flow step. Hence you are receiving an array containing the object where you want your "Get Item from Name/Values" transformation to work. Consider to first to a "Get Item from Array" transformation first, i assume this will solve your problem.