If empty...

(0) Share

Report

Posted on by Kosenurm

802

Hi,

Basic one but stumping me at this early hour.

I want this expression to be.... if this column value is blank/empty, input my email address, else (so its not empty), put the value from this column value.... what am I doing wrong?

if(empty(outputs('Update_a_row')?['body/cr350_submittedintotoolbyemail']), "my email", outputs('Update_a_row')?['body/cr350_submittedintotoolbyemail'])

Thanks

All responses (3)

Answers (1)

Verified answer

Sundeep_Malik 6,480 on at

Like (1)

Report
Re: If empty...

@Kosenurm

Just check again. The mistake you have done is at my email. It should have single quotes around it not double quotes. So, try this:

if(empty(outputs('Update_a_row')?['body/cr350_submittedintotoolbyemail']), 'my email', outputs('Update_a_row')?['body/cr350_submittedintotoolbyemail'])
Sundeep_Malik 6,480 on at

Like (0)

Report
Re: If empty...

Hey @Kosenurm

I was stuck in a similar scenario some days back. I tested a few things, and probably for you the following expression might work:

if(conatins(outputs('Update_a_row')?['body/cr350_submittedintotoolbyemail'],''), "my email", outputs('Update_a_row')?['body/cr350_submittedintotoolbyemail'])
Above they are empty single quotes: ''
Not really sure, if the above fails, instead of those empty single quotes, you can try passing null too. Hopefully it will work. My scenario was a little different than yours.
grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report

Re: If empty...

It looks fine to me - assuming you're using single quotes for the email.

What is the error you're getting? Do you have some sample JSON you could provide?