‘Contains’ not working with OData filter query as expected with List all items present in table Fin and Ops action

(0) Share

Report

Posted on by Alex1171

Hi all,

I’m trying to perform the following filter query on the ‘List all items present in table’ Fin and Ops action:

contains(Comments, '@{variables('toFind')}')

However, nothing is being returned, even if the toFind variable contains a real substring of the field.

Even more strangely is that if I use a filter array after finding all records with the following parameters:

item()?['Comments'] contains "variables('toFind')"}]}

I get the exact result I expect, however I need to be filtering with the List all action, so this is not suitable.

Does anyone know how I might fix this or other approaches I can try? Thank you!

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @Alex1171,

Some list actions don't support all the OData functions. For example I know the contains cannot be used in the SharePoint Get Items action OData filter query. In that action you can use the substringof function instead of the contains function.

Maybe that is the same case with the FinOps List all items present in table action. Have you tried the substringof function instead?

Was this reply helpful? Yes No
Alex1171 6 on at

Like (0)

Report

Thanks for the reply! @Expiscornovus so even more strange it works fine on other fields in the table with the exact same syntax so it specifically seems like somethings up with the comments field. I tried substringof but that doesn't seem like a support function for F&O ODate queries.

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @Alex1171,

Yes, than it sounds like to be more of a field type of thing. I need to refresh my memory on comments/notes fields of F&O, it's been a while since I configured that application. Let me double check that part.

In the meantime be aware that the substringof function is an odd one from a syntax point of view. While most functions would list the field as the first parameter.

contains(MyField, 'test')

The substringof function lists the value as the first parameter

substringof('test', MyField)

Was this reply helpful? Yes No
Alex1171 6 on at

Like (0)

Report

Hey @Expiscornovus yep I tried with that syntax and still get an error. I'm guessing it must be data specific since I'm not having issues with the other fields, at a bit of a loss. Thanks for your help again.

1 people found this reply helpful.

Was this reply helpful? Yes No