Unanswered

Filter text for a code with unique digits

(1) Share

Report

Posted on by Kubsy

Hey there everyone. I'm trying to create a flow that updates Planner when an Outlook calendar event is created with a unique code in the title. The code has always a specific letter as first digit and a dash as sixth digit and is 10 digit long. Example: 'Lxxxx-xxxx'. If it shows up anywhere in the event title then it should go to the planner.

So far I'm stuck with the filtering. Tried some conditioning but I'm too much of a rookie to make a neat solution to that. Can anyone help me with this? Thanks in Advance!

Categories:

Business Process Flows

I have the same question (0)

All responses (3)

Answers (0)

David_MA 12,515 Super User 2025 Season 2 on at

Like (1)

Report
Re: Filter text for a code with unique digits

If you can figure out how to extract your code from anywhere within the title, you can then use an expression such as this to make sure it is in the format and length you want:

if(and(not(isInt(substring(triggerBody()['text'], 0, 1))), isInt(substring(triggerBody()['text'], 1, 4)), contains(substring(triggerBody()['text'], 5, 1),'-'), isInt(substring(triggerBody()['text'], 6, 4)), equals(length(triggerBody()['text']), 10)), 'true', 'false')

The above just checks to make sure the first character is not a number, so it could be any valid character. Otherwise, it checks the format you listed.

I have an expression somewhere to check if it is A-Z or a-z, but I cannot remember where 🙂

Was this reply helpful? Yes No
David_MA 12,515 Super User 2025 Season 2 on at

Like (1)

Report
Re: Filter text for a code with unique digits

I think I have something that will work for you. You can test it with a manually triggered flow.

Add a string input to your flow named Title

Initialize an Array variable named Split and set the default value to the following expression: split(triggerBody()['text'],' ')

The above expression will break your title on each space

Add an Apply to each and use the variable for the output

Add a condition to check if the current item's length equals 10 with this expression: length(items('Apply_to_each'))

On the yes side of the condition, add a second condition to check if the following expression equals true: and(not(isInt(substring(items('Apply_to_each'), 0, 1))), isInt(substring(items('Apply_to_each'), 1, 4)), contains(substring(items('Apply_to_each'), 5, 1),'-'), isInt(substring(items('Apply_to_each'), 6, 4)), equals(length(items('Apply_to_each')), 10))

Be sure to use true from the expression builder and do not type true.

Then on the yes you can update your Planner item.

If you want to be more efficient, you can wrap the apply to each in a Do until it finds your expression.

The flow will look like this:

Was this reply helpful? Yes No
David_MA 12,515 Super User 2025 Season 2 on at

Like (1)

Report

Re: Filter text for a code with unique digits

That's a good option, but unfortunately in my environment they don't allow any non-standard actions.

Was this reply helpful? Yes No