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 Lisa.Sanchez@XXX.com 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, Lisa@XXX.com 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 Lisa.Sanchez@XXX.com ? It's greatly appreciated.
Best Regards,