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

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Sundeep_Malik 6,501 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Verified answer

Sundeep_Malik 6,501 on at

Like (1)

Report
Copy link

Link copied!
@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'])

Was this reply helpful? Yes No