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?

if(
equals(body('Get_a_row_by_ID')?['address1_country'], null),
'',
body('Get_a_row_by_ID')?['address1_country']
)
if(
empty(body('Get_a_row_by_ID')?['address1_country']),
'',
body('Get_a_row_by_ID')?['address1_country']
)
|
Ellis Karim
Blog: https://elliskarim.com
|