If empty...

Like (0) Share

Report

Posted on 10 Nov 2022 08:00:37 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,482 on 10 Nov 2022 at 09:00:21

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,482 on 10 Nov 2022 at 08:47:04

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 Moderator on 10 Nov 2022 at 08:10:00

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?