Customizing User Principal Name on Azure Create User Condition. EG fist letter of First Name + Lastname@email.com

(0) Share

Report

Posted on by w0rmsp17

Hello,

I'm creating a work flow for an onboarding request. Part of my flow include creation of Azure AD users.

Our company email format is 'first letter of First Name' followed by their surname @companyemail.com

I've been playing around with different expressions but cant seem to make it work.

Any guidance would be appreciated.

Thank you

Categories:

Using flows

I have the same question (0)

All responses (9)

Answers (2)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @w0rmsp17

You can get the first letter of the first name using the substring expression like:

substring('tom',0,1), instead of 'tom' select the First Name from the dynamic selector here. And then you can use the concat function to append the outputs of above with the last name and the @ domain.com string.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
w0rmsp17 34 on at

Like (0)

Report

Hello,
Thank you for the reply. Very helpful information, I'll remember this for the future. I'm a little stuck though I'm unsure how to reference variables in the 'expression'. Keeps throwing me errors.

I get errors with this syntax "substring('First_Name'),0,1)"

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @w0rmsp17

You can do something like this: Variable name: First_Name->

substring(variables('First_Name'),0,1)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
w0rmsp17 34 on at

Like (0)

Report

Hey cheers,
It looks like the code is good. However I'm getting this error

Apparently I need to initialize this variable.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hey @w0rmsp17

Where are you getting the First Name from? Are you storing it in a variable at all? You might want to initialize a variable before this action and provide the name and then in the value, select the first name from dynamic content. It should resolve your issue then.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
w0rmsp17 34 on at

Like (0)

Report

'First Name' is a variable in a entered in a List. It should store it when the list has been submitted.

When I enter in the User Principal Name in 'Create user'
I select 'Add dynamic content' -> select 'Expression', I enter substring(variables('First_Name'),0,1)

click save and thats where the error prompts

thank you

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hey @w0rmsp17

That First Name from a list is basically the column. Can you do this: initialize a variable by adding an initialize variable action before the current action and put the name of the variable as "First_Name" and then in the value, from the dynamic selector select the First Name column.

Now if you use that expression, it should work for you.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

w0rmsp17 34 on at

Like (0)

Report

Awesome! I'm gonna try this. I'll let you know how it goes.
Thank you

Was this reply helpful? Yes No
w0rmsp17 34 on at

Like (0)

Report

It worked. Thank you!

Was this reply helpful? Yes No