Skip to main content
Community site session details

Community site session details

Session Id : SSvcMr9xFBRINhDTKo5jfo
Power Automate - General Discussion
Unanswered

Remove succeeding text

Like (0) ShareShare
ReportReport
Posted on 20 Aug 2022 13:12:41 by 2

Hello folks - 

 

I'm new with the Power Automate but really enjoying playing with it since it's part of O365 ecosystem.

 

I'm currently working on something to capture a specific line from an email body and ignore the succeeding text. So far, I've managed to capture the text from the email body, thanks to the expression posted here, but it does also capture all the text after.

Screenshot 2022-08-20 210457.jpg

 

This is the expression I'm using: last(split(triggerBody()?['body'],'Message ID: '))

 

I think there are few tweaks needed on the expression, I just don't know what it is 🙂

 

 

Thank you!

  • MarconettiMarco Profile Picture
    3,812 Super User 2024 Season 1 on 22 Aug 2022 at 05:36:23
    Re: Remove succeeding text

    ok @akosijesyang ,

    the instructions available in that link should work.

     

    If I have answered your question, please mark my post as Solved.
    If you like my response, please give it a Thumbs Up.

    My blog site about Power Automate: https://powerautomatejoy.com/

    BR,

    Marco

  • akosijesyang Profile Picture
    2 on 22 Aug 2022 at 00:58:28
    Re: Remove succeeding text

    Hello @MarconettiMarco - thank you for suggesting the link. I'll look at it.

     

    It's the "space" that separates the string I want to capture from the next section.

     

    Thank you.

  • MarconettiMarco Profile Picture
    3,812 Super User 2024 Season 1 on 21 Aug 2022 at 07:24:29
    Re: Remove succeeding text

    Hello @akosijesyang ,

    is there any particular character at the end of the string you want to grab?

    How do you want to limit the string extraction?

     

    If is there a specific character at the end, I think you could use an approach like the following:

    https://powerusers.microsoft.com/t5/Building-Flows/extract-s-string-between-two-characters/m-p/81139#M8072

     

    If I have answered your question, please mark my post as Solved.
    If you like my response, please give it a Thumbs Up.

    My blog site about Power Automate: https://powerautomatejoy.com/

    BR,

    Marco

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1