At this moment
coalesce
returns always
email@gmail.com
, as it is non-null.
So, replace:
[UserEmail]=coalesce('email@gmail.com',UserEmail)
with:
[UserEmail]=coalesce(UserEmail,'email@gmail.com')
BTW:
I don't understand the usage of:
[PhoneNo]=coalesce(null,PhoneNo)
. This means: replace null with first non-null value of
PhoneNo
.
Check the documentation as
an0ther1[
^] mentioned in his anwer.