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,
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.
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.
Hi @Mdemarici123, than you have to use something like this:
See my example below and give it a try. Please let me know if this works for you.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.
The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.