cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cm77
Regular Visitor

Flow conditions (startswith letter followed by number)

Hi all,

 

I wonder if anyone can help please?

 

I have a Flow working that checks the first part of a field. For example, I have a 'starts with' condition where if the field starts with L then condition is true, but I would only like to return true if L is followed by a number, so L1 would be true but LB would be false.

 

Is this possible?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Flow conditions (startswith letter followed by number)

@cm77 

Unfortunately, Flow does not yet support wildcard characters of any type.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Flow conditions (startswith letter followed by number)

@cm77 I have a solution that may work for you - see my screen shots below.

Please note the following:

  • Any expressions that I used are documented in the comments for that action
  • If the second character is not a number, the Set variable action will fail - that is why I'm using the run after settings.
  • If my Flow does not hit the terminate action, then the column starts with an L and is followed by a number. Replace the set variable action after the terminate action with whatever action you want to take but be sure to set the run after condition to "is skipped".

Please let me know if this need more explanation.

ParseText1.jpgParseText2.jpgParseText3.jpgParseText4.jpg

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
cm77
Regular Visitor

Re: Flow conditions (startswith letter followed by number)

Hi Scott,

 

Thank you for the quick response on this yesterday!

 

I'm not 100% clear on how to do this unfortunately, I'm new to Flows. I was hoping there would be a numeric wildcard and a letter wildcard that could be used but it appears to be somewhat more complex than I had initially reaslised.

 

The required value could be based on any single letter at the start of the data followed by any number after it. So a 'true' could be anything that starts with 'B25' but not 'BD6', or 'M3' but not 'MK4'. It's basically a UK postal code validation, but narrowed to specific areas.

 

Does the numeric wildcard '#' work in Flows as it does SQL?

 

Thanks again,

 

Chris

cm77
Regular Visitor

Re: Flow conditions (startswith letter followed by number)

This works somewhat..

 

conditions.PNG

I'm not sure yet if the '#' character will work.

Highlighted
Super User
Super User

Re: Flow conditions (startswith letter followed by number)

@cm77 

Unfortunately, Flow does not yet support wildcard characters of any type.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

cm77
Regular Visitor

Re: Flow conditions (startswith letter followed by number)

Thanks Scott. Hopefully wildcards will be introduced at some point.

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (8,289)