Check if a property/key exists in JSON output

(0) Share

Report

Posted on by CU20081036-0

183

I'm using "Invoke HTTP Trigger" action in my flow. Sometimes, this action returns JSON response without some keys.

Could someone help on how to check if keys like locationUri, locationType exist in the JSON response.

Condition contains(outputs('Invoke_an_HTTP_request'),'locationUri') did not help.

JSON Response

"location": {
"displayName": "",
"locationUri": "",
"locationType": "conferenceRoom",
"uniqueId": "",
"uniqueIdType": "directory",
"address": {
"street": "",
"city": "",
"state": "",
"countryOrRegion": "",
"postalCode": ""
},
"coordinates": {}
},
"locations": [
{
"displayName": "",
"locationUri": "",
"locationType": "conferenceRoom",
"uniqueId": "",
"uniqueIdType": "directory",
"address": {
"street": "",
"city": "",
"state": "",
"countryOrRegion": "",
"postalCode": ""
},
"coordinates": {}
}
],

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (1)

djc998 16 on at

Like (0)

Report
Copy link

Link copied!

I have this same problem. How do we handle if a property does not exist? In my example, I always get this error.

InvalidTemplate. Unable to process template language expressions in action 'CurrentHealth' inputs at line '1' and column '2931': 'The template language expression 'if(empty(variables('trackerRows').cells[9].value),variables('trackerRows').cells[9].value,'null')' cannot be evaluated because property 'value' doesn't exist, available properties are 'columnId'. Please see https://aka.ms/logicexpressions for usage details.'.

Was this reply helpful? Yes No
djc998 16 on at

Like (3)

Report
Copy link

Link copied!

I was able to solve the problem by using an if and then contains. This should solve your issue.

if(contains(variables('trackerRows').cells[9], 'value'), variables('trackerRows').cells[9].value, 'null')

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @sunithav ,

You can try to use the property name in Compose to get the property value. If Compose fails, it means that the property does not exist.

https://flow.microsoft.com/en-us/blog/error-handling/

Hope this helps.

Best Regards,

Was this reply helpful? Yes No
CU20081036-0 183 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bacao-msft ,

Thanks for your response.

I converted JSON response to string and used condition to check if string contains the required keyword.

Thanks,
SV

Was this reply helpful? Yes No
MartinPyman 29 on at

Like (5)

Report
Copy link

Link copied!

A slightly more elegant solution:
Use the equals function in a condition step equal to false

Example:
equals( variables('JSON')?['<Property to Find>'] , null)

Was this reply helpful? Yes No
PabloD 62 on at

Like (0)

Report
Copy link

Link copied!

Very nice! Thank you.

Was this reply helpful? Yes No
jensweiltoyota 4 on at

Like (0)

Report
Copy link

Link copied!

Good try but it does not work. You can't access a property that does not exist.

Was this reply helpful? Yes No
MartinPyman 29 on at

Like (0)

Report
Copy link

Link copied!

Flow running successfully and property marked as not existing:

Here is the formula, I'm looking for "bob" which definitely is not in my json object:

Did you give it a try? It'd be great to see why yours might be failing

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

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
bookworm2death 3 on at

Like (0)

Report
Copy link

Link copied!

Make sure you have that ? between the variable and the property, mine didn't work until I noticed I missed that.

Was this reply helpful? Yes No