Unanswered

extract substring using compose

(0) Share

Report

Posted on 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 topics

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

v-yuazh-msft on at

Like (1)

Report
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

Was this reply helpful? Yes No
Harry_G 367 on at

Like (0)

Report

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

Was this reply helpful? Yes No
kedarsk 48 on at

Like (1)

Report

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?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

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

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

Was this reply helpful? Yes No
PSchiager 4 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@PSchiager nice thanks 🙂

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
cuser on at

Like (0)

Report

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.')))

Was this reply helpful? Yes No