Hello,
I am looking for an expression or script to use in my Power Automate flow. My flow converts email requests that are forwarded into Planner tasks. The Planner tasks include the body of the email in the description section.
The email may contain an email thread, i.e., multiple messages within the same email. I want to capture the name of the initial sender (i.e., the person who sent the first email in the thread) and the timestamp of the last email sent before it was forwarded to the shared mailbox.
I believe the best approach is to extract this information directly from the initial trigger of the flow (i.e., when an email arrives) or from the description portion of the task. The idea is to leverage the "FROM:" and "Sent:" fields in the email's HTML content to identify the initial sender and timestamp.
The expression I currently use does not consistently capture the originator or requester.
Any ideas or suggestions to improve this process would be greatly appreciated.