Hi, I am trying to use the concat for a name field to get the first name and last name (a period between first and last name) as [email protected] from the people picker.
I create a name field and insert from "Fx" with concat(substring-before(DisplayName),
"@"), "@XXX.com") and People picker returns display name in flow run as 'Sanchez, Lisa' (the way user profiles are created there is a comma between first and last name) as Sanchez, [email protected] which does not give me the correct email address. I wonder is there any "Substring" settings to get the correct email format from the people picker as [email protected] ? It's greatly appreciated.
Best Regards,