forward emails to different people based on message text

(0) Share

Report

Posted on by jakejake

Just beginning with Power Automate and appreciate suggestions. Appreciate your patience if this has been covered elsewhere but I couldn't find a clear solution.

I receive emails from the same sender at approximately the same time every day if a member of my team did not enter their time (hours worked) for the prior day. I currently forward these emails to the employees as a friendly reminder to submit, but would like to automate. The only thing different about the email from one employee to the next is their name is listed after a keyword in the format "Employee: LAST NAME, FIRST NAME"

Ideally I would like to pull their names from this common text to then forward the message to "FIRSTNAME.LASTNAME@COMPANY.COM"

Is this possible with Power Automate? Thanks for any suggestions.

All responses (1)

Answers (1)

Verified answer

v-bacao-msft on at

Like (0)

Report

Re: forward emails to different people based on message text

Hi @jakejake ,

It seems that you need to extract the user info in the email body first, and then concatenate them into an email address.

You can refer to the following similar thread to extract the user name:

Solved: Extracting text from email - Power Platform Community

Solved: Extract text from body of an email and create new ... - Power Platform Community

Then use the concat() function to splice them into an email address:

Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

Hope this helps.

Best Regards,