logic apps - cannot be evaluated because property doesn't exist

Question

In Logic Apps, I have an expression:

coalesce(triggerbody().data.job_id,triggerbody().resource_id,'error')

I basically want to get the first one that is not null, however one of these does not EXIST in the json payload. I get an error:

'The template language expression 'coalesce(triggerbody().data.job_id,triggerbody().resource_id,'error')' cannot be evaluated because property 'data' doesn't exist, available properties are 'transaction_id, event_type, event_time, resource, resource_id, account_id, resource_third_party_id, request_user_type, request_user_id'. Please see https://aka.ms/logicexpressions for usage details.'.

If data doesn't exist, that value should be "null" and resource_id used. Any ideas what the expression would look like to have that behaviour?

felixmondelo · Accepted Answer · 2018-03-20 10:18:41Z

3

The problem here is that you are trying to access to a property of a null element:

coalesce(triggerbody().data.job_id,triggerbody().resource_id,'error')

As triggerbody().data is null, Logic App can't evaluate triggerbody().data.job_id, you should check first if triggerbody().data is null.

answered Mar 20, 2018 at 10:18

felixmondelo

1,4921 gold badge13 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user1048175 Over a year ago

triggerbody().data doesn't exist in the payload deliberately- if it is not there, it needs to take from triggerbody().resource_id, but how do I do this.... I have tried if(equals(triggerbody().data, null), triggerbody().resource_id, triggerbody().data.job_id) but same error. Not sure how to check for undefined

felixmondelo Over a year ago

Instead of use triggerbody().data, use triggerbody()?['data']. The question mark operator lets you reference null properties of an object without a runtime error. For example, you can use this expression to handle null trigger outputs: @coalesce(trigger().outputs?.body?.property1, 'my default value')

user1048175 Over a year ago

Bingo. Thanks so much!

Collectives™ on Stack Overflow

logic apps - cannot be evaluated because property doesn't exist

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related