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?
Solved! Go to Solution.
concat(substring(variables('FirstName'),0,1),variables('LastName'))
Here's the formula to use. Just replace FirstName and LastName with the appropraiate data fields from dynamic content
Hi @Pstork1
Thanks for the reply but I think I am missing something.
There is no formula in your reply?
concat(substring(variables('FirstName'),0,1),variables('LastName'))
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
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.
User | Count |
---|---|
76 | |
58 | |
48 | |
29 | |
20 |
User | Count |
---|---|
28 | |
27 | |
26 | |
21 | |
20 |