Filter Query where Numbers are Separated by Slash

(1) Share

Report

Posted on by Phineas

4,951 Super User 2025 Season 1

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:

Business Process Flows

All responses (6)

Answers (0)

Michael E. Gernaey 43,383 Super User 2025 Season 1 on at

Like (0)

Report

Filter Query where Numbers are Separated by Slash

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)
Suggested answer

Nived_Nambiar 17,739 Super User 2025 Season 1 on at

Like (0)

Report

Filter Query where Numbers are Separated by Slash

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)
Phineas 4,951 Super User 2025 Season 1 on at

Like (0)

Report

Filter Query where Numbers are Separated by Slash

@Nived_Nambiar

Something like this?
Suggested answer

Nived_Nambiar 17,739 Super User 2025 Season 1 on at

Like (0)

Report

Filter Query where Numbers are Separated by Slash

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!
Phineas 4,951 Super User 2025 Season 1 on at

Like (0)

Report

Filter Query where Numbers are Separated by Slash

@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)
Suggested answer

Michael E. Gernaey 43,383 Super User 2025 Season 1 on at

Like (0)

Report

Filter Query where Numbers are Separated by Slash

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!