web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate check if the property ...

Power Automate

Suggested Answer

check if the property exists

(0) Share

Report

Report

Posted on by xvzms

103

Hi, In my flow I try to get address from Dataverse table.

This column address is not required in the table.
When the address is exist, flow run successfully, but when did not exist I get error message.

How can I check if this value is exist and if no add an empty value?

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Ellis Karim 12,024 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @xvzms,

Try using the "bracket notation with a question mark" (query method):

if( equals(body('Get_a_row_by_ID')?['address1_country'], null), '', body('Get_a_row_by_ID')?['address1_country'] )

The use of the question mark in JSON specifies that if the property being referenced does not exist then a null value will be returned instead of throwing an error.

So, if the property 'address1_country' is missing, the expression body('Get_a_row_by_ID')?['address1_country'] will return null.

You can also use the empty function to shorten the above expression to:

if( empty(body('Get_a_row_by_ID')?['address1_country']), '', body('Get_a_row_by_ID')?['address1_country'] )

For more details, please see How to Query JSON Data Using JSON Notation with Power Automate❔❔❓ – Ellis Karim's Blog

Ellis Karim

Blog: https://elliskarim.com

Was this reply helpful? Yes No

Join the conversation