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
K.
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'])
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.
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?
Michael E. Gernaey
566
Super User 2025 Season 1
David_MA
516
Super User 2025 Season 1
stampcoin
492