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

(0) Share

Report

Posted on by lardo5150 Microsoft Employee

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.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

lardo5150 Microsoft Employee on at

Like (0)

Report

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.

Was this reply helpful? Yes No
David_MA 12,966 Super User 2025 Season 2 on at

Like (1)

Report
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" } ]

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like (0)

Report

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.

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like (0)

Report

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"
        }
    }
}

Was this reply helpful? Yes No
David_MA 12,966 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (0)

Report

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

EngineeerDisplayname

EngineerDisplayname

Was this reply helpful? Yes No