Answered

Getting substring out of a string in PowerAutomate using an expression

(0) Share

Report

Posted on by benny_blanco

Hi all,

I'm building this Flow that needs to rename a created document before it gets moved to a folder. Couldn't find what I'm looking for in here, so posting a new topic for it. I'm trying to get everything after the second '-' character in a string. For example, out of the string 'BugsBunny-Arn-999999-67378-CLMPDVVD-TB-GN.docx', I'm trying to make it to be only '999999-67378-CLMPDVVD-TB-GN.docx', what is the correct expression that will work? Have in mind that'd be a dynamic value, so I'm basically taking the Name of the file first and then need to convert it to have only what is after the second '-' character. Thank you!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!
OK Benny Blanco from the Bronx!!
Expression:

split(outputs('Compose'), '-')[2]

https://www.youtube.com/watch?v=zMA5uCYloDk

Was this reply helpful? Yes No
Verified answer

bibhupanigrahi 240 on at

Like (3)

Report
Copy link

Link copied!

Hi @benny_blanco , you cannot easily find second index of a character in a string, so the substring() function is not helpful here. I used a combination of split() and join() to get the exact part of string in this case.
1. Split the original string using the expression "split(variables('mystring'),'-')". This creates an array.
2. Now join the array elements in a a Compose starting the third item in the array using the expression "join(skip(variables('myarray'),2), '-')". This results in the string you want.
Hope this helps!

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!

Wow - I read the question completely wrong. 😄

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (1)

Report
Copy link

Link copied!
This is my new version now I have read the question properly:
join(skip(split(outputs('Compose'), '-'),2),'-')

Was this reply helpful? Yes No
benny_blanco 68 on at

Like (0)

Report
Copy link

Link copied!

Just tested bibhupanigrahi's suggestion which worked perfectly. Thank you @bibhupanigrahi !

Was this reply helpful? Yes No