We need a solution to grab the new email address of the user. Currently it is pi

sudhirp804 over 10 years ago

We need a solution to grab the new email address of the user. Currently it is picking old email address of the user example abc@myworld.com and it should pick or the grab the new email address like abc@myworldwide.com
Currently in our process model we pick email address from process variable which picks the old email address. What we required some expression which will grab the new email address of the user.
Could anyone let me know how it can be done. I have created a new expression rule which will search the user the firstname and lastname and pick the email address but only picking the old email address here. We need to pick/grab the other email address of the user like if user old email is abc@myworld.com than it should pick the new email address abc@myworldwide.com
=rule!prmFormatUserAsEmailAddress()
=if(and(not(rule!APN_isEmpty(ri!user)),isusernametaken(ri!user)),user(touser(ri!user),"firstName") & " " & user(touser(ri!user),"lastName"),"NA")
...

Discussion posts and replies are publicly visible

0 sudhirp804 over 10 years ago

Right it picks email attribute of an Appian but we need to pick from organization database where both the email address exist...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 10 years ago

Simple, make a change in your recently created rule such that a query is made against the table in which returns the desired column that reflects new email address.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sudhirp804 over 10 years ago

I mean it first search the user firstname and lastname and email address from the organization database .... As in appian email is old email but in the database it is new email address what we need to we don't want to mess up change all user email address one by one...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 janakik over 10 years ago

Two ways for resolving your issue,
1. All the users should update their domain of email id, then your code would pick updated email id.
2. My other suggestion would be using toemailaddress(substitute(user(touser(ri!user),"email),"world","worldwide.com")), this function would return emailid with new domain
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 10 years ago

My suggestion is to design a process which maintains a sync between new email addresses column and the 'email' attribute of the User object. This gives you a long term solution and there isn't a need for making short term fixes on need basis.

Bear in mind that short term solutions (such as modifying the email address by making use of an additional rule etc) should be applied in all the areas in which email address is used, which in-turn might become cumbersome.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sudhirp804 over 10 years ago

Janakik - The expression rule pick the worldwide.com email address but now the issue like user name old email address is sudhirg@world.com but his new email is gsudhir@worldwide.com. Instead of picking gsudhir@worldwide.com it is picking sudhirg@worldwide.com.... Could you let me know how to resolve this issue..my expression rule is below:
=toemailaddress(substitute(user(touser(ri!user),"email"),"world.com","worldwide.com","NA"))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sudhirp804 over 10 years ago

This rule pick worldwide.com but not exact user name... In Appian username kim.strickland@world.com and his new id is KStrickland@worldwide.com. It should pick KStrickland@worldwide.com but it is picking kim.strickland@worldwide.com. Thats the issue could anyone let me know how to resolve this issue.

=toemailaddress(substitute(user(touser(ri!user),"email"),"world.com","worldwide.com","NA"))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 janakik over 10 years ago

As suggested by Sikhivahan, go for a permanent fix. Create a stand alone process to make Appian profile information sync with your Organisation DB.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel