cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
powerpear
Frequent Visitor

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

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:

powerpear_0-1650358186946.png

result:

powerpear_1-1650358202603.png

 

using contains:

powerpear_3-1650359895414.png

 

 

result:

powerpear_2-1650359535697.png

 

"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
1 ACCEPTED SOLUTION

Accepted Solutions
v-yujincui-msft
Community Support
Community Support

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.

vyujincuimsft_0-1650525826575.png

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

 

 

View solution in original post

1 REPLY 1
v-yujincui-msft
Community Support
Community Support

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.

vyujincuimsft_0-1650525826575.png

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

 

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,255)