Parse Json has a value, but it is passing back null

[lardo5150]

I have a power app that is passing data back to Power Automate.

I can clearly see in the Parse Json, that a specific field has data.

This field though is passing null.

To verify this, I created a set variable right after to assign the value of that field to a variable, and confirmed that even though Parse Json shows a value, it is passing null.

I have tried a 1000 things, including how I am passing the data back from Power Apps, but I can't figure this out.

All the other values come over, except for EngineerDisplayName.

[lardo5150]

I removed the flow from the app.

Created a new copy of the flow

Deleted the old one.

Added the new one to the app

Same thing, I can see the value in the Parse Json, but when I pull it out, it is always null?

Does not make sense.

[David_MA]

I am pretty sure this is happening because the data you want is in an array within the array that you are parsing. You will need to add another Parse JSON action and when you go to generate it from sample data, just paste in the section from the body you highlighted in you screen shot (the data below may work if I read the image correctly:

[
{
"CaseNumber": "123456",
"EngineerDisplayname": "nameofperson",
"EngineeringUPD": "upnname",
"EngineerAlias": "aliasname",
"ID": "12345"
}
]

[lardo5150]

I am not sure I am following.

So for the Parse Json, I can pull out each individual piece

CaseNumber

EngineerUPN

EngineerAlias

ID

This all works.

But when I pick EngineerDisplayname, it is null.

Are you saying that EngineerDisplayname is an array?

if so, I put in an initialize variable as an array.

I then set the variable with the ParseJson EngineerDisplayname, and it still came back null.

[lardo5150]

This is my ParseJson

{

    "type": "object",

    "properties": {

        "CaseNumber": {

            "type": "string"

        },

        "Engineeralias": {

            "type": "string"

        },

        "ID": {

            "type": "integer"

        },

        "EngineerUPN": {

            "type": "string"

        },

        "EngineerDisplayname": {

            "type": "string"

        },

        "DNA": {

            "type": "string"

        }

    }

}

[David_MA]

How are you setting your variable and where is the data coming from?

[lardo5150]

PowerApp

Here is what I am passing back from PowerApps

'V2-Backlog-DNA'.Run

( JSON

( { CaseNumber: Case_Number_DNA.Text,

DNA: DNA_Type.SelectedText.Value,

//Severity: Severity_Input.SelectedText.Value,

Engineeralias: global_appMailNickName,

//IssueType: Issue_Type_Input.SelectedText.Value,

ID: global_engineer.ID,

//AssignTime: submit_time

, //AR: AR_Input.Value,

//Offering: Customer_Type_Input.SelectedText.Value,

EngineerUPN: global_engineer.UPN,

EngineeerDisplayname: global_engineer.Engineer.DisplayName 

So this piece:

EngineeerDisplayname: global_engineer.Engineer.DisplayName

Here we are pulling back from a lookup column in SPO, Engineer.  We are grabbing the displayname.

PowerAutomate:

in PowerAutomate, my Json is this:

{ "type": "object",

"properties": {

"CaseNumber": { "type": "string" },

"Engineeralias": { "type": "string" },

"ID": { "type": "integer" },

"EngineerUPN": { "type": "string" },

"DNA": { "type": "string" },

"EngineerDisplayname": { "type": "string" } } } 

You can see I am expecting a STRING for engineerdisplayname.

if it was an array, I would receive an error would I not?

When I run this, here is the Json:

{ "CaseNumber": "123456",

"DNA": "Assign No Cases",

"EngineeerDisplayname": "Displaynamebot",

"EngineerUPN": "UPN@something.com",

"Engineeralias": "bot", "ID": 1253 } 

So you can see it is excepting the String, and it is passing back the Displayname.

The problem is with the rest of the flow, when I call the Displayname it is Null 

Here is the flow I am calling the displayname from Json into a Teams Chat.  You can see it passes back null here also.  

So the value is passed from PowerApps to Power Automate.

The value is there, clear as day in the Json, but I can't pull that value out.

ALL other values work just fine.

I ahve done this a ton of times with Json, and never had this issue.

[grantjenkins · Accepted solution]

In your data sent from Power Apps you are using EngineeerDisplayname. However, in your Parse JSON schema you are using EngineerDisplayname.

EngineeerDisplayname

EngineerDisplayname