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.
The fields "Robert" & "Armstrong"
Solved! Go to Solution.
Here's the formula to use. Just replace FirstName and LastName with the appropraiate data fields from dynamic content
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.
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.
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!