I am struggling with implementing a Filter Query on Azure Get Entities step.
I want to return TicketNumber for the rows where BankAccount contains value from my 'Compose_-_Bank_Account_number'.
I cannot use 'eq' but something like contains/substringof because the field BankAccount in some cases can store multiple bank accounts.
I tried everything I found online, but no luck.
For both- contains and substringof I also tried to inverse value and column name, but result was the same.
"An unknown function with name 'contains' was found. This may also be a key lookup on a navigation property, which is not allowed.\nRequestId:8fb31110-0002-000b-22cd-537aa9000000\nTime:2022-04-19T09:11:00.7235813Z"
Does any of the experts have idea how this can be achieved?
Thanks a lot