cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yupabs
Helper I
Helper I

Auto Approve Email from a link in the body message

Please help I'm new to Power Automate.

 

Below I need to automate.

 

1. When receiving an email with specific subject, I opened that mail and click on the 'Approve' link which will open new email and send with subject approve: **.

2. Once above is done, what i want to add is when in conversation one of my teammate message specific text.. i will find in my email and trigger #1 logic. And once done, should auto reply the message in the conversion like "Done".

 

Is this possible? Even if only #1 can do..that should be very helpful already.

Ex. select that specific message in conversation (teams) and click to find that specific email based on the message and trigger #1 to auto approve the mail.

 

Your help is greatly appreciated. Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
jinivthakkar
Super User
Super User

@yupabs You will need to have structured email, only then you can extract the contents.

 

Please check these links : 

 

https://powerusers.microsoft.com/t5/Building-Flows/Extract-text-from-body-of-an-email-and-create-new...

 

https://powerusers.microsoft.com/t5/Building-Flows/Extract-text-from-Body-of-an-email-in-Flow/td-p/5...

 

If its not structured then its very difficult to find a dynamic string every time.

 

You can have something like No.ABC123 or #ABC123 or RequestNo.ABC123 so you know the string after No. or # or RequestNo. is your required data.

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

 

 

View solution in original post

7 REPLIES 7
jinivthakkar
Super User
Super User

@yupabs You can have a link which will open a new email with subject, to, body etc. You could also have dynamic content

 

jinivthakkar_1-1612722210704.png

jinivthakkar_2-1612722288763.png

 

 

<a href="mailto:someone@yoursite.com?cc=someoneelse@theirsite.com, another@thatsite.com, me@mysite.com&bcc=lastperson@theirsite.com&subject=Big%20News&body=Body-goes-here">Email Us</a>

 

Not sure how #2 can be done and why dont you try email with options action in Power Automate ?

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

yupabs
Helper I
Helper I

Thanks for your help. Let me try and update you.

Btw, i'm trying to find how to extract specific text from a teams message. I used indexOf but not sure of the exact syntax to use in the connector flow to put the "content" of the string. Please advise.

 

Ex. "Please help to approve ABC123456. Thanks".. I want to get the "ABC123456"..

 

Once above is done.. i want to use that string to search in the email.. which would be another flow.

In this context.. I wanted to get specific text as well in the message body after i find the email.. there will be a reference # which i need to put in the message body.. See below sample.

 

yupabs_0-1612750605456.png

 

jinivthakkar
Super User
Super User

@yupabs the string format ABC123456 is fixed or it will keep on changing everytime like next time there can be ABC1 or ABC22 or ABC333 or will it be always ABC666666 ?

It won't be fixed value, it will be a dynamic string. Thanks @jinivthakkar 

jinivthakkar
Super User
Super User

@yupabs You will need to have structured email, only then you can extract the contents.

 

Please check these links : 

 

https://powerusers.microsoft.com/t5/Building-Flows/Extract-text-from-body-of-an-email-and-create-new...

 

https://powerusers.microsoft.com/t5/Building-Flows/Extract-text-from-Body-of-an-email-in-Flow/td-p/5...

 

If its not structured then its very difficult to find a dynamic string every time.

 

You can have something like No.ABC123 or #ABC123 or RequestNo.ABC123 so you know the string after No. or # or RequestNo. is your required data.

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

 

 

yupabs
Helper I
Helper I

Thanks @jinivthakkar for your help!

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,477)