getting specific value in the output of initialize variable

[Ahmed2]

Hello every one

   I have a flow, with severla steps, one of the actions is an initialize variablem which gives the below out put

{"__metadata":{"type":"SP.FieldUserValue"},"LookupId":6,"LookupValue":"Name of person","Email":"Email@domain.XXX.org"}

 i would like to =use a compose action to get the Lookup value, and anther for the email value. so i cna have them as a output and use as dynamic content in a send an email action.

is that possible with an expresison maybe?

thanks in advance for your help

[tom_riha]

Hello @Ahmed2 ,

also here you can access it with the JSON notation by defining the desired property as ['propertyName']

variables('yourVariableName')?['LookupValue']
variables('yourVariableName')?['Email']

[eric-cheng · Accepted solution]

Hi @Ahmed2 ,

You can use the Parse JSON action

To generate the schema, click on Generate from Sample and paste in the JSON from your earlier post.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[Ahmed2]

Hello

Thanks both. sorry i clicked accept as a solution by mistake

@eric-cheng 's Solution works just find,  but the issue is if the variable is null, it will fail the flow, is there a work around that?

also when i tried @tom_riha solution, I got the below msg even before i tested the flow

"

The inputs of workflow run action 'Compose_2' of type 'Compose' are not valid. The variable 'Initialize variable to hold value to be compared' must be initialized before it can be used inside action 'Compose_2'.

[eric-cheng]

Hi @Ahmed2 ,

Add a null in the type to make it nullable

https://powerusers.microsoft.com/t5/General-Power-Automate/Handling-NULL-in-Parse-JSON/td-p/40906

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[Ahmed2]

Hi @tom_riha 

apperantly its now giving me a msg

['LookupValue']' cannot be evaluated because property 'LookupValue' cannot be selected. Property selection is not supported on values of type 'String'.

do i need to use a different command?

thanks for all the help

[Ahmed2]

thanks @eric-cheng 

i tried thatm and add null to all the properties,

but i still get the msg

Required property 'content' expects a value but got null.

but i dont have a prpoperty called 'content', can you give advice on this?

below is the schema after adding null

{
    "type": [
        "string",
        "null"
    ],
    "properties": {
        "__metadata": {
            "type": [
                "object",
                "null"
            ],
            "properties": {
                "type": {
                    "type": [
                        "string",
                        "null"
                    ]
                }
            }
        },
        "LookupId": {
            "type": [
                "integer",
                "null"
            ]
        },
        "LookupValue": {
            "type": [
                "string",
                "null"
            ]
        },
        "Email": {
            "type": [
                "string",
                "null"
            ]
        }
    }
}

[eric-cheng]

Hi @Ahmed2 ,

Paste this directly into the action schema.  I have tested this with null and should be working.

{
"type": "object",
"properties": {
"__metadata": {
"type": "object",
"properties": {
"type": {

}
}
},
"LookupId": {

},
"LookupValue": {

},
"Email": {}
}
}

[Ahmed2]

Hi @eric-cheng 

Sorry i tires, and i am getting the same error, and i cant find the property 'content' 

Unable to process template language expressions in action 'Parse_JSON_2' inputs at line '1' and column '3360': 'Required property 'content' expects a value but got null. Path ''.'.

[eric-cheng]

Hi @Ahmed2 ,

Can you send me the example JSON payload you are failing with and a screenshot of the current flow

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn