Get Entities Azure Table Storage - Filter Query - contains/substringof

[powerpear]

Hi all,

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.

Using substringof:

result:

using contains:

result:

"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

[v-yujincui-msft · Accepted solution]

Hi @powerpear ,

It seems that there are some limitations of the OData filter in the get entities Action, maybe you could try to add a Filter array Action.

Here is an example that might help you:

https://powerusers.microsoft.com/t5/Building-Flows/Filter-Excel-Multiple-Variables/td-p/1542323

Best Regards,

Charlie Choi