
Announcements
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.
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,