web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate How i can get all the ...

Power Automate

Answered

How i can get all the charecters after the first "-"

(0) Share

Report

Report

Posted on by johnjohn123

3,514

I have values such as:-

Station-Quebec

Station-St-Marys

Stat-Test

so how i can get all the characters after the first "'-" ? so i should get :-

Quebec

St-Marys

Test

? thanks

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (3)

Sort by

Verified answer

Expiscornovus 33,830 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @johnjohn123,

One approach could be to use an indexOf to determine the position of the first - character. After that you can use the length of the whole string to calculate the part you want to collect with a substring.

Below is an example of that approach:

substring(outputs('Compose'), add(indexOf(outputs('Compose'), '-'), 1), sub(length(outputs('Compose')), add(indexOf(outputs('Compose'), '-'),1)))

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @johnjohn123 :

I've made a test for your reference:

Reference expression:

1\split(outputs('Compose'),variables('Return'))
2\skip(items('Apply_to_each'),add(indexOf(items('Apply_to_each'),'-'),1))

The Result

Best Regards,

Bof

Was this reply helpful? Yes No
Verified answer

Paulie78 8,422 Moderator on at

Like (1)

Report
Copy link

Link copied!
Like this:

The two expressions in the select action are:

split(outputs('Compose'), decodeUriComponent('%0A')) join(skip(split(item(), '-'), 1), '-')

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

Was this reply helpful? Yes No

Join the conversation