Expression rule for Email Address

Certified Associate Developer

Hi All

I have a CDT  in which the data is saved liked that:

id interger 
name varchar
managerteamid integer
s1assigne varchar
s2assigne varchar
s3assigne varchar
s4assign varchar

Now I want to get email Address which is in this manager  Team id and all the assignees and then send the email to all . 

How to write the expression to find the email Address for that and also help me how to write in send email smart service ?

Thanks 

  Discussion posts and replies are publicly visible

Parents
  • There's a lot of detail left out here (how your users are set up, etc), but in general, if you start with an Appian username, you can get their email address (in plaintext) by using the "user()" function, i.e. user("myUsername", "email") (where "myUsername" is any given user's actual username).  Note that you need to wrap any plaintext email address(es) in "toEmailAddress()" before it'll work in the Send Email node; alternatively, you can set the "to" field to point to an entire Appian Group and/or actual Appian Users and it will generally just work.

Reply
  • There's a lot of detail left out here (how your users are set up, etc), but in general, if you start with an Appian username, you can get their email address (in plaintext) by using the "user()" function, i.e. user("myUsername", "email") (where "myUsername" is any given user's actual username).  Note that you need to wrap any plaintext email address(es) in "toEmailAddress()" before it'll work in the Send Email node; alternatively, you can set the "to" field to point to an entire Appian Group and/or actual Appian Users and it will generally just work.

Children