Using the first letter a string in another variable.

[RArmstrong]

Hi All,

I am pulling data from an SQL database to create AD users.
I have basic fields like first name, last name etc.

What I need to achieve is using the first letter of the users first name added to the last name to make a user name. 

For example

The fields "Robert" & "Armstrong"

becomes RArmstrong@somedomain.com

Any ideas?

[Pstork1]

Here's the formula to use.  Just replace FirstName and LastName with the appropraiate data fields from dynamic content

[RArmstrong]

Hi @Pstork1 

Thanks for the reply but I think I am missing something.

There is no formula in your reply?

[Pstork1 · Accepted solution]

Sorry, been a long day.

concat(substring(variables('FirstName'),0,1),variables('LastName'))

[RArmstrong]

Thanks @Pstork1,

That worked but now I am getting the following error 

 

[v-yamao-msft]

Hi @RArmstrong ,

The function you are using should work.

From the screenshot, it seems that you have 57 apply to each items.

Please check other items to see if the error happens on certain item.

Best regards,

Mabel          

[Pstork1]

Click on the Next failed link to find out which step failed.  I would suspect its probably that some of the records have null fields for First or Last name.  You could adjust the formula to check for that.