Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
14 replies
Subscribers
5 subscribers
Views
7332 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Concatenation of String
rohandhondilalk
over 7 years ago
Hi All,
We have one requirement where, we need to send a mail to the particular user. i.e,
we have one pv!abc which has username, and for which we are concatenating with our domain . So we need "pv!abc@domain.com". We tried all the possibilities but none of them worked out.
Thanks in advance.
OriginalPostID-245885
Discussion posts and replies are publicly visible
0
helmuta
over 7 years ago
Is the user in Appian?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rohandhondilalk
over 7 years ago
Yes , he is in Appian.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
helmuta
over 7 years ago
I just created an expression rule that has two inputs user and domain. In the rule the code is ri!user&ri!domain and the value comes back correctly. Another option would be to look up the user in the Appian user table and get the email address. Something like user(pv!abc, email)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 7 years ago
@rohandhondilak Would you please be let us know at a high level on what you have tried? And when you mean none of them worked, what is it that you are experiencing - an error or a successfully completed node without sending any email?
I believe you would have already done concatenation as it's straight forward. Did you apply the following conversion over the concatenated string prior to including the recipient details in the to/cc of Send email node? I believe it might be worth giving a try.
fn!toemailrecipient(fn!toemailaddress(fn!concat(pv!abc,domain.com)))
There could be some more issues here but I am looking at the validity of the recipients in the first place.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Rajasekhar Pamidipati
A Score Level 2
over 7 years ago
Hi rohandhondilalk,
If you have user with valid email id configured while creating or updating that your, then you can directly use that user as recreant for sending email. because if you give user as input then appian will automatically take the email provided for that user.
If in case you want to use email id like pv!abc with domain name, in that case you can concatenate them like pv!abc & "domain.com" and you need to use toemailaddress() or toemailrecipient() to convert that text value into email type.
It will be like toemailaddress(pv!abc & "domain.com") which will Email Address type as output.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rohandhondilalk
over 7 years ago
@rajasekharp,
We have tried the same and its not working with us.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 7 years ago
@rohandhondilak Did you try the combination of both, that is, toemailrecipient(toemailaddress()) or only one of them?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rohandhondilalk
over 7 years ago
@ sikhivahans,
Thanks . The recipients are valid and we had tried the fn! which you had mentioned.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rohandhondilalk
over 7 years ago
@sikhivahans,
As of now we tried individually, we will try both and update you. thanks :)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 7 years ago
No worries, ideally both are needed afaik but not one of them. Because toemailaddress() converts the data type of source(which is concatenated string in your case) to Email Address type and toemailrecipient() converts this Email Address type to Email Recipient type which then becomes valid to be used in to/cc of the Send Email node.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>