Answered

Sharepoint Get Items Odata filter substringof or contains usage

(0) Share

Report

Posted on by Yonik

Hi ,

I am trying to use the Odata filter with substringof command to filter only the lines that contains some specific names, the names are SPACE delimited string values like "USA CANADA GERMANY"

i tried :

substringof(ContryName,'CANADA')

but it is not working , error code 400

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-bacao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Yonik ,

You should put the field name as the second parameter in substringof() function:

Reference:

https://sharepains.com/2018/11/12/sharepoint-get-items-odata-filter-query/

Besides, please try to run Get items action without configuring Filter Query first, then check the body of Get items action to get the internal name of the field.

Please take a try again.

Best Regards,

Was this reply helpful? Yes No
Yonik 5 on at

Like (1)

Report
Copy link

Link copied!

Thanks @v-bacao-msft ,
Your recommendation was very correct, seems that share point list does not use same column names in FLOW automation.
More over the calculated field is not identified by FLOW at all.

However i solved the problem by using "yes/no" fields and filtering with "EQ" operator.
Thanks again

Was this reply helpful? Yes No