web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / check if the property ...
Power Automate
Suggested Answer

check if the property exists

(0) ShareShare
ReportReport
Posted on by 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)
  • Suggested answer
    Ellis Karim Profile Picture
    11,691 Super User 2025 Season 2 on at
    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']
    )
    
     
     
     
    Ellis Karim

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard