Unanswered

How can I extract a number in between two different characters in power automate?

(0) Share

Report

Posted on by Mdemarici123

Hi All,

I am trying to use power automate to extract the numbers underlined below. I am lost on how to do so. As you can see the number will always be in between a dash and an underscore and the number could be either 3, 4, or 5 digits. Also sometimes there is another iteration of text in between the dash and underscore like in the project yellow document. I think I need to use Regular Expressions, but I am completely lost.

Thank you in advance,

Marcus

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Mdemarici123

You can use a split() action if all of the following are true:

There is always a dash preceding the number

There is always an underscore after the number

There will never be more than one dash or there will always be the same number of dashes

There will never be more than one underscore or there will always be the same number of dashes

In other words, there needs to be a pattern.

If all of the above are true, see my example below, let me know and I will provide an example.

Was this reply helpful? Yes No
Mdemarici123 12 on at

Like (0)

Report
Copy link

Link copied!

Hi @ScottShearer unfortunately there will not be a constant pattern, the only difference will be the situation in the above picture in "project yellow" I was curious to see if there is a way to tell flow to get a number and only a number that is in between the dash and the underscore.

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Hi @Mdemarici123, than you have to use something like this:
https://powerusers.microsoft.com/t5/Building-Flows/How-to-know-if-an-variable-is-numeric/td-p/565181

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Mdemarici123

See my example below and give it a try. Please let me know if this works for you.

Was this reply helpful? Yes No