Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - General Discussion
Unanswered

Extract Specific details from Email body

Like (0) ShareShare
ReportReport
Posted on 25 May 2023 20:57:48 by

Hi All,

I want to extract "first name", "Last Name", and "URL" from the below text. the text I have converted using html to text action. text highlighted in red is needed.

 

here is the text :

 

[https://apc014ca9941912%7C0%7C0%7C638206184187049547%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wJQIjoiV2luzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=1nHhHIH35J3V7S9wX259vha92dwZ8b6oM6bigOcJwU4%3D&reserved=0 ]

 

From: ENTERPRNG.COM <ENTERPRI.BRING.COM>
Sent: Thursday, May 25, 2023 2:32 PM
To: RCG OSHORE <RCRE@hcl.com>
Subject: Please approve the following form: Offer Form - India -
1267929BR-ASSOCIATE COLTANT : Ethiraj S

 

[https://trm.brassring.com/clientlogo/hcltechlogo.gif]

Garg, Shefal(31) has eLinked a form for you to approve.

S, Ethiraj
[https://trm.brassring.com/MobInterface/FormApproval.aspx?g=AF1C5FE60E4649BD88518BA306D234D8&c=M5574F32pHy5Ha$bgzac5w== ]

This is a system-generated message. Please do not reply.


Dear Approver,

This is to inform you that the offer for below candidate with the requisition
mentioned is pending for approval.

Kindly approve the offer at the earliest.

Regards,
System Admin

Access your eLink dashboard to review and take action on all your eLinks:

My eLink Dashboard
[https://trm.brag.com/mobile/elinkprofile?q=%5etDCxP6HMyK28UZkeO%2bbjmaH2UcgbiBZX%2fT3zn7OuQgC7hJCQGV9lydSZ6%2fgPRSNI1Uz%2fL5WrHdvqMiBdPnDGZTZ%2fbToVdYDa6grFXMRoM4k%3d ]

 

Output required :

First Name  : S

Last Name: Ethiraj

url : [https://trm.brang.com/MobInterface/FormApproval.aspx?g=AF1C5FE60E4649BD88518BA306D234D8&c=M5574F32pHy5Ha$bgzac5w== ]

  • Rhiassuring Profile Picture
    8,688 Super User 2025 Season 1 on 25 May 2023 at 22:41:17
    Re: Extract Specific details from Email body

    Here's the whole flow:

     

    Rhiassuring_0-1685054328228.png

     

    The "NewLine" variable is just a string variable where I hit "enter" in the space, and that's it.

    The EmailBody is a copy / paste of what you entered above.

     

    Here are the steps, with the expressions used shown in the notes:

     

    Rhiassuring_1-1685054383508.png

     

    Rhiassuring_2-1685054405549.png

    Rhiassuring_3-1685054445069.png

     

    When the emails are always the same, it's pretty easy - you just use "Find Text" first to find the string that precedes the block you need. From there, you just find something to split on, and then trim down to what you need.

     

     

     

     

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,731 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,075 Most Valuable Professional

Leaderboard
Loading started