extract substring using compose

Like (0) Share

Report

Posted on 19 Nov 2018 07:37:00 by Harry_G

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:

General Questions

All responses (8)

Answers (1)

cuser on 29 Mar 2022 at 04:56:13

Like (0)

Report

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 Pla... on 01 Mar 2022 at 11:47:21

Like (0)

Report

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 Pla... on 28 Oct 2020 at 01:03:44

Like (0)

Report

Re: extract substring using compose

@PSchiager nice thanks 🙂
PSchiager 4 on 27 Oct 2020 at 10:09:13

Like (1)

Report

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 Pla... on 01 May 2020 at 02:21:05

Like (1)

Report

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 48 on 02 Nov 2019 at 18:26:00

Like (1)

Report

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 367 on 20 Nov 2018 at 05:04:00

Like (0)

Report

Re: extract substring using compose

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

v-yuazh-msft on 20 Nov 2018 at 04:16:36

Like (1)

Report
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:

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:

Best regards,

Alice

Community site session details

extract substring using compose

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Warren Belz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

extract substring using compose

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Warren Belz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates