How to get the initial of a surname to use in user creation

(0) Share

Report

Posted on by Stellarprojects

Hey all,

I'm building a new user creation flow to simplify the existing process. The format of users mail is:

Firstname.initialoflastname@contoso.com

So I would like to replace the "lastname" in the MailNickname field and "lastname" in the UPN field with firstname.initialoflastname and I'm struggling to do so. I can see that there is a method of doing this with a concat expression but actually executing it is a problem.

Help would be hugely appreciated.

Cheers,

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

v-yuazh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Stellarprojects,

Please refer to screenshot below to add the expression with concat:

The expression in the User Principle Name as below:

concat(triggerBody()?['First_x0020_Name'],'.initialoflastname@contoso.com')

Best regards,

Alice

Was this reply helpful? Yes No
Stellarprojects 16 on at

Like (0)

Report
Copy link

Link copied!

Hey Alice,

I have explained this poorly, I do not have the users initials available to me, so i'd like to get the initial of the surname if possible.

I do have users First_x0020_Name and Last_x0020_Name, so is there a way to split the Last_x0020_Name to get the first letter only?

Cheers,
SP

Was this reply helpful? Yes No
Verified answer

Stellarprojects 16 on at

Like (2)

Report
Copy link

Link copied!

If anyone is interested I solved this by using
toUpper(substring(triggerBody()?['Last_x0020_Name'],0,1))

Cheers

Was this reply helpful? Yes No