Is it showing as:
Surname, Forename
If your data source offers Given Name/Forename and Surname separately, use these, else you could do the following:
With(
{
seperator:
Find(
", ",
ThisItem.'Created By'.DisplayName
)
},
Concatenate(
Mid(
ThisItem.'Created By'.DisplayName,
seperator + 2
),
" ",
Left(
ThisItem.'Created By'.DisplayName,
seperator - 1
)
)
)
Or for the less complicated version 🙂
Last(
Split(
ThisItem.'Created By'.DisplayName,
", "
)
).Result
& " " &
First(
Split(
ThisItem.'Created By'.DisplayName,
", "
)
).Result
Or
With(
{
arr:Split(
ThisItem.'Created By'.DisplayName,
", "
).Result
},
Last(
arr
).Result
& " " &
First(
arr
).Result
)
