nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Property formula empty email

Constance_Hua

Hi there,

I face a formula error when using an if in my property formula (email property): I am trying to return an empty value as the valueFalse of the if statement:

if(true,Email("test@test.com"),Empty)

But I get the error on the valueFalse format:

"Input types do not matchThe type of valueIfTrue and valueIfFalse should be equal. if expects valueIfFalse to be type Email"

The AI support says to use "Empty" but it doesn't work.

Thank you in advance for your help!

Find more posts tagged with

Workflow Designer

Accepted answers

Constance_Hua

Alright I found a workaround: I created a property of type email called "empty email" which always stays empty, and I use it in my valueFalse parameter:

if(UserAttribute([Workflow Creator], "email")==Email( "test@test.com") , Email("test@test.com"),[Empty Email])))

All comments

Chris Chelberg

Hi Constance,

If you want this email property to be "test@test.com" if that exists, and empty otherwise, I would recommend using: ifexists(email("test@test.com") ,email("test@test.com")), where you can take the first email() and switch that to another email property, or another value. If that first value exists (has value), then it will make the result email("test@test.com"), or blank if that first value doesn't exist. I hope this helps solve your issue.

Constance_Hua

Thank you Chris for your help!

Think is I am trying to reach this logic: if the workflow creator is test1@test.com, then set this property to test1@test.com. if the workflow creator is test2@test.com, then set this property to test2@test.com. But then if it is none of these emails or empty, then leave this property empty.

The problem with ifExist is that I am not checking if it exists, I am checking if it matches a specific string. And the "if" statement unfortunately is always expecting an "if false" value…

Constance_Hua

Alright I found a workaround: I created a property of type email called "empty email" which always stays empty, and I use it in my valueFalse parameter:

if(UserAttribute([Workflow Creator], "email")==Email( "test@test.com") , Email("test@test.com"),[Empty Email])))

Chris Chelberg

Hi Constance,

That works for sure. If there's a longer list of workflow creators, I would take a look at the switch() formula as well, where you can set a longer list of "if A, then X", etc and use the workaround above for the "defaultValue" email.