cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cm77
Level: Powered On

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
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
Level: Powered On

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
Level: Powered On

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
cm77
Level: Powered On

Re: Flow conditions (startswith letter followed by number)

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

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 364 members 5,279 guests
Please welcome our newest community members: