27
I have a form that collects some info, one of these being the email but I want to just save the username from the email.
input from form: username@email.com
I want to remove @email.com
and just enter: username
tried expressions and compose with no luck so far.
I gave this a try but it didnt work. one thing i missed in the first post was that the email comes from a people picker. I ended up doing an item update to save the email adress, then a compose with this
Share
Report
All responses (
Answers (
"@CONCAT('https://leprinofoods-my.sharepoint.com/User%20Photos/Profile%20Pictures/',REPLACE(body('Update_item_2')?['imageurl'],'@leprinofoods.com',''),'_leprinofoods_com_LThumb.jpg')"
then last it and update item again with the username only
Hi @jeffha77,
Please try to use workflow definition language function split.
I created a simple flow for your reference.
The flow is triggered by a Button, in the first Compose action, I use the split function to split the string using “@”.
split(triggerBody()['text'],'@')
Then in the second Compose action, use the following function to get the username of the email address.
outputs('Compose')[0]
Then when the button is clicked and an email address is entered, it will return the username part of the email address.
Please take a try with it.
Best regards,
Mabel Mao
#1
WarrenBelz
146,679
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,015
Most Valuable Professional
