Filter Query where Numbers are Separated by Slash

(1) Share

Report

Posted on by Phineas

5,325 Super User 2025 Season 2

I need to create a filter query that looks to see if a column 'contains' a number.

The 'Tag Number' column in the list may have one number or a set of numbers
separated by slashes (see below).

Example 1: 102111
Example 2: 123638/173984/103526

How do I (is it possible) to write a filter query that will recognize 173984, or any
of the other numbers using some form of 'contains' language where a slash(es)
is present?

SharePoint List Tag Number column -

Flow Get items action -

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Michael E. Gernaey 53,452 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Phineas

You have to change eq to substringof like this

substringof('YourStringhere', ColumnNamehere)

If this resolves your issue please mark as such and maybe a like

Thans!

Was this reply helpful? Yes No
Phineas 5,325 Super User 2025 Season 2 on at

Like (0)

Report

@Michael E. Gernaey

How would the substring by composed (look like)?

Shall I just enter 6 random numbers, and PA will look for a six
digit number between all the slashes that matches the
Tag_Number coming in from the 'When an item is created
action'?

My Proposed substring -
substringof('123456',Tag_Number)

Was this reply helpful? Yes No
Suggested answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Phineas

The substring option will check whether part of string exist in column, This means even if the number is 104204 or 102041 it will still captures both these, so better way would be to use below OData filter query

substringof('104204/',FailedStation) or substringof('/104204/',FailedStation) or substringof('/104204',FailedStation)

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!

Was this reply helpful? Yes No
Phineas 5,325 Super User 2025 Season 2 on at

Like (0)

Report

@Nived_Nambiar

Something like this?

Was this reply helpful? Yes No
Suggested answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi

Sorry actually FailedStation was the column for my list

In your case it should be Tag_Number

See below updated odata filter code

substringof('104204/',Tag_Number) or substringof('/104204/',Tag_Number) or substringof('/104204',Tag_Number)

Was this reply helpful? Yes No
Michael E. Gernaey 53,452 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Phineas

Yes if you are going to have multiple, you only listed one

You have got to get better at writing these questions to cover what you are doing and asking for. The answer was answered when I answered it originally.

Recognizing numbers has nothing to do with / slashes. So you would never have to put a substring with slashes in it.

You asked how to find a number (which is really a string) in a string the answer is as I said originally

substringof('yourstringHoweverYougetithere', ColumnName)

Was this reply helpful? Yes No