The trigger for Gmail has a field called "From" which output provides: FIrstName LastName <email address>
I only want the email address without "<" ">" "First Name" "Last Name" as I would like this to be the label on my trello card. Trello doesn't accept < > these symbols so I need them removed.
Any suggestions would be appreciated.
Solved! Go to Solution.
Hi @pladavm,
So here you are using the Gmail When a new email arrives as the trigger of your flow?
If yes, then we should be able to get the Email address by adding a Compose Action, under the Compose input, copy and paste the following:
"@first(split(last(split(triggerbody()['From'],'<')),'>'))"
Reference for the language used here: Workflow Definition Language.
See the results:
Then use the Outputs Dynamic Content of the Compose action to fill hte Email part.
If you need any further help on this, please post back.
Regards,
Michael
Hi @pladavm,
So here you are using the Gmail When a new email arrives as the trigger of your flow?
If yes, then we should be able to get the Email address by adding a Compose Action, under the Compose input, copy and paste the following:
"@first(split(last(split(triggerbody()['From'],'<')),'>'))"
Reference for the language used here: Workflow Definition Language.
See the results:
Then use the Outputs Dynamic Content of the Compose action to fill hte Email part.
If you need any further help on this, please post back.
Regards,
Michael
That's great @v-micsh-msft Michael thank you!
Can you please confirm if the code will also work if there is no first name last name or < > e.g. email@domain.com comes through and nothing else?
Hi @pladavm,
I think this code should only work with the Gmail trigger, as this trigger would return the FROM content in the steady format, which then we could take use of to get what we want.
If the first Name or Last Name contains nothing, this code also works with the Gmail trigger. Tested.
Regards,
Michael
Hi @v-micsh-msft
Thank you! What would the code be for the outlook as it does similar first name last name <> thing as well? Would it not be the same?
I read the article you linked in your response and a I did a lot of reading about this Azure logic code but I am finding it difficult to find a structured learning course so i can understand how to use data operation compose function properly.
Do you have any suggestions on how to learn data opertion compose functions? What is the term I should be googling? Azure logic code?
Hi there,
Courtenay from Parserr here. Just wanted to let you know. This is exactly what Parserr does We were added to Flow last week and very excited about it.
Parserr allows you to turn incoming emails into useful data to use in various other 3rd party systems.You can use to extract anything trapped in email including email body contents and attachments.
In your case, you could setup a rule on Parserr to extract the First and last names for every email. In flow, you could use that data with any of the other connectors.
Let me know if you need any help.
Hi Courtney, what is the website for Parserr?
Does it parse PDFs as well as email?
Hi Team,
Is it possible in microsoft flow to send email by excel column (only project manager name not email address),because our manager dont want to add email address manually in excel file.
Status Project Item Type Start Date End date project manager
Pending SwS Java 15/05/2018 15/08/2018 Dominique philippi
Pending SI Python 08/05/2018 17/08/2018 Arnaud ferrand
Pending GSS Ruby 06/05/2018 05/08/2018 Janice Lagundi
Please reply me.
Regards
Vikas kaushik
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
User | Count |
---|---|
26 | |
26 | |
25 | |
21 | |
17 |
User | Count |
---|---|
54 | |
46 | |
33 | |
33 | |
30 |