Get Items - Query filter for contains

[Grahambo05]

Is substringof supported as a query filter?

Not sure if my syntax is wrong

Example 

substringof(Market_x002f_State, 'las vegas')

[v-yamao-msft]

Hi Grahambo05,

I haven’t seen a function of Substringof. There is a function of Substring which can be used to return a subset of characters from a string. Please check more details about the workflow definition language at here:
https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

For your scenario, are you trying to use Filter query for data source such as SharePoint? Hope this doc about Odata query operation could be a reference for you, you could check the supported Odata query options at here:
https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/use-odata-query-operations-in-sharepoint-...

Do you want to use the function to return the items which contains “las vegas”? I assume that you may consider to use Contains function to return true if dictionary contains a key. Please check the doc workflow definition language for more details.

Best regards,
Mabel Mao

[martinav]

is substringof supportted yet?

[martinav]

Apparently, it is supported now.  I was trying it with the items reversed in the parenthesis.

substringof('LAM',Title)

Then, come to find out... doesnt work at all for Name in a document.  So, no luck for a SP Get Files.

Always a nuance to waste hours of time.

[asdfaf4]

This is highly disappointing... I'd like to use ODATA filter out all files that contains ".url" but filename with extension is not supported either...  Please fully support ODATA