web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : gS3QgOIcowPDCoBuoo9dBJ
Power Automate - General Discussion
Answered

extract substring using compose

Like (0) ShareShare
ReportReport
Posted on 19 Nov 2018 07:37:00 by 367

I have string have value "[113] this is testing string". i need to convert it "this is testing string". I tried compose action with substring using Indexof. But unfortunately it doesn't work for me. Any help woulf be appreciated 🙂

Categories:
  • cuser Profile Picture
    on 29 Mar 2022 at 04:56:13
    Re: extract substring using compose

    Need to Extract string between words  ,
    example like word 

    Case "" please in between these words i am extracting the string problem is extract string contains word "case "

     

    trim(first(split(last(split(outputs('Compose'),'Case')),'Please send us an order confirmation directly in response to this mail.')))
  • Community Power Platform Member Profile Picture
    on 01 Mar 2022 at 11:47:21
    Re: extract substring using compose

    Hello, 
    I'm about to create a workflow using power automate, i use the french version. 
    i have a issue, i can't find the trigger compose to recover a file that a catch with microsoft form. 
    could someone please help me...
    thanks

     

  • Community Power Platform Member Profile Picture
    on 28 Oct 2020 at 01:03:44
    Re: extract substring using compose

    @PSchiager   nice thanks 🙂

  • PSchiager Profile Picture
    4 on 27 Oct 2020 at 10:09:13
    Re: extract substring using compose

    First(Split(Last(Split("<<just this text>>", "<<")), ">>")), which will first extract "just this text>>" and then "just this text".

  • Community Power Platform Member Profile Picture
    on 01 May 2020 at 02:21:05
    Re: extract substring using compose

    How would you go about this if you wanted the values between << and >>

     

    i.e.  <<just this text>>  would return  just this text

  • kedarsk Profile Picture
    48 on 02 Nov 2019 at 18:26:00
    Re: extract substring using compose
    Thank you but you have manually mentioned the 6 and 22 as number for index and characters . How to get it automatically or in other words what if we aren't sure about what those numbers could be?
  • Harry_G Profile Picture
    367 on 20 Nov 2018 at 05:04:00
    Re: extract substring using compose

    Thanks @v-yuazh-msft. it working like a charm :).

  • Verified answer
    v-yuazh-msft Profile Picture
    on 20 Nov 2018 at 04:16:36
    Re: extract substring using compose

    Hi @Harry_G,

     

    I have made a test on my side, please refer to screenshot below to create the flow:

    Capture.PNG

     

    The expression in the Compose 2 as below:

    substring(outputs('Compose'),6,22)

    And you could also enter the expression below in the Compose 2:

    last(split(outputs('Compose'),'[113] '))

     

    The flow would run successfully as below:

    Capture.PNG

     

     

     

    Best regards,

    Alice

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

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete