cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Kingpin
Kudo Kingpin

extract substring using compose

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 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

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

View solution in original post

Highlighted
Kudo Kingpin
Kudo Kingpin

Re: extract substring using compose

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

Highlighted
Helper I
Helper I

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?
Highlighted
Helper I
Helper I

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

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,405)