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,506

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)

Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report
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 on at

Like (0)

Report

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