Power Platform Community Forum Thread Details

I have a column called Employee Name which has a first and last name (ex. Joe Smith) separated by a space. I Need to pull out the first name and first two letters of the last name (joesm) and then copy it to another column.

I have tried the split, replace, text and several other functions and can't get it to work. I have tried to get the data before the space and then the data after the space but it still fails.

Any help would be greatly appreciated.

Thank you!

Categories:

Building flows