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
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
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.
You can use a split() action if all of the following are true:
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.