cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MT090511
Frequent Visitor

Parsed Json hhas Null Value

I am creating an approval flow.  I have the standard trigger of when a purchase invoice approval is requested, get details, HTTP request for the order lines, and dimensions, then parse json. Any trigger, action I try where I use a parsed value, I get NULL Value error.  One else have this?

6 REPLIES 6
ScottShearer
Super User III
Super User III

@MT090511 

Have you checked the output of one of your runs to verify that anything is actually being returned for you to parse?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
JimmyWork
Power Participant
Power Participant

@MT090511 Check the output to see if there is a value in it like @ScottShearer says.
If there is a value then it fails on a specific value in the JSON then add next to type: ["Null", "String"],
This allows you to receive a string or null value, flow fails if a Null value is received when excepting a string.

How do I write that out exactly? my error says that the dimension set lines is coming back null, So I think I need to put this ["Null", "String"] next to it on type:

 

 

"dimensionSetLines": {
                    "type": ["Null", "String"],
        
And get an error message saying the syntax isn't right.MT090511_0-1617527713199.png

 



@MT090511 If it's an array try ["Null, "array"],

This will allow it to get both null and array value, but please post the error message and check the output also so it actually do contain data in the other fields.

MT090511
Frequent Visitor

The basic error message I am getting is "Null" and any thing I want to do where I am trying to use the composed/parsed json values as dynamic content fails. It comes up in the raw output for that step, but doesn't pass the value on to the next. 

MT090511_0-1617614400244.png

 

 

FLOW OUTLINE

MT090511_1-1617614462495.png

 

HTTP REQUEST OUTPUT:

MT090511_4-1617614599039.png

 

 

COMPOSE- RAW OUTPUT SCREENSHOT

MT090511_2-1617614492989.png

PURCHASE INVOICE PARSE

MT090511_3-1617614516447.png

 

EMAIL INPUT- NO VALUE PASSED THROUGH- THIS IS WHERE IT ERRORS

MT090511_5-1617614656507.png

 

 

 

 

 

@MT090511 

Can u try this.
Initiate Variable String, put displayName as value. Run flow and see if the value shows up in the variable, if yes, try using the variable in Subject.

 

Also try something like this as value maybe. 

@body('Querey Purchase Invoices')?['Value']?['displayName']

 

I'm sure someone with more expertise can easily solve this for you, I new at this myself but i do believe the data you trying to get is maybe the wrong type for subject.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (3,153)