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:
Solved! Go to 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
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
User | Count |
---|---|
88 | |
37 | |
26 | |
13 | |
13 |
User | Count |
---|---|
127 | |
54 | |
38 | |
24 | |
21 |