ODATA “contains” for Get Items SharePoint list

(2) Share

Report

Posted on by PatrickSched

212

Hello everyone,

I have a SharePoint list. Among other things, there is a column “Item number” (TITLE) as a text field. It can happen that this cell contains either only one number (e.g. 6862072) or two or more (e.g. 6862072, 6862056, 6862064).

I would then like to get all items in a flow that have “111111”, for example, even if there are other numbers in the cell. How does this work?

I have already tried it with “substringof(‘ITEMNUMBER’, Title). But I get nothing as an output value even if the number is in the SharePoint list.

In my example (see screenshot below) I want both items to be found.

Thanks for your help in advance

Best regards
Patrick

Categories:

Building flows

Screenshot_001386...

Screenshot_001384...

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
It should be possible to use substringOf function for this. Have you tried a hard coded value as a test first with the substringOf function?

Maybe the issue is related to your forms question value which you used in the filter?

Below is my test setup.

The list with my test data

The substringOf function

substringof('6862072',Title)

The output in a HTML table

Was this reply helpful? Yes No