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.
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.