Property doesn't exist in JSON (empty and equals don't work)

(0) Share

Report

Posted on by JefT1

Hi,

I have looked at this solution: JSON missing property

But I just can't seem to get to work it for my solution.

My flow is as follows:

HTTP GET

Parse JSON (Body)

Update row

In the update row I use objects from my retrieved JSON, however, in some cases some objects are not available. Therefore the flow gives the following error:

Unable to process template language expressions in action 'Update_a_row' inputs at line '0' and column '0': 'The template language expression 'if(empty(body('Parse_JSON')?['quotes']?[0]['industry']),' ',body('Parse_JSON')?['quotes']?[0]['industry'])' cannot be evaluated because property 'industry' doesn't exist, available properties are 'exchange, shortname, quoteType, symbol, index, score, typeDisp, longname, exchDisp, isYahooFinance'. Please see https://aka.ms/logicexpressions for usage details.'.

I have tried these expressions, but all do not work:

- if(equals(body('Parse_JSON')?['quotes']?[0]['industry'],null),' ',body('Parse_JSON')?['quotes']?[0]['industry'])

- if(empty(body('Parse_JSON')?['quotes']?[0]['industry']),' ',body('Parse_JSON')?['quotes']?[0]['industry'])

- if(empty(body('Parse_JSON')['quotes'][0]['industry']),' ',body('Parse_JSON')['quotes'][0]['industry'])

(The [0] is retrieve only the first item of the array in the JSON.)

Do I do something incorrectly with the question marks? Or is it something else?

Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

JefT1 7 on at

Like (0)

Report

I only found similar solutions to the link I put in my original post. However, I found this which makes much more sense: verifying json properties existing or not in json array
It works, however, in theory the word 'Industry' in my example could also be part of the values of course. That is the risk.

Was this reply helpful? Yes No
Verified answer

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (2)

Report

See also: How to query JSON data using JSON notation with Power Automate❔❔❓

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

Was this reply helpful? Yes No
JefT1 7 on at

Like (0)

Report

This example is exactly what I was looking for:
This way, it can't go wrong and I have only isolated the part of my JSON in the array of what I need.

Will accept it as solution.

Was this reply helpful? Yes No
3tsolutions 94 on at

Like (1)

Report

I wrote a solution to handle missing properties of an object, if it helps..
LINK

Was this reply helpful? Yes No
geficks 9 on at

Like (0)

Report

Thanks a lot! Very helpful

Was this reply helpful? Yes No