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
Super User

@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
Super User
Super User

@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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (4,317)