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!
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.
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)
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.
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?
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,079
Most Valuable Professional