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?
Have you checked the output of one of your runs to verify that anything is actually being returned for you to parse?
@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:
@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.
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.
HTTP REQUEST OUTPUT:
COMPOSE- RAW OUTPUT SCREENSHOT
PURCHASE INVOICE PARSE
EMAIL INPUT- NO VALUE PASSED THROUGH- THIS IS WHERE IT ERRORS
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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.
The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.