how to filter rows with different datatypes

[mahmoodhsaud]

Hi Everyone,

I created a flow where it will be triggered when a new row is added, I wanted to filter another table with newly added row but the problem is the filter should satisfy two conditions and also the data types of the row is different. 

Below is the expression used to filter but its not working,

crfa8_strategyid eq '1' and owninguser ne 'DYNAMIC CONTENT'

Table Name	Row Name	Data type
newly added/comparing	strategyid/crfa8_strategyid	unique identifier / Text
newly added/comparing	dynamic content / owninguser	lookup/lookup

Thanks in Advance

Regards,

Mahmood

[manuelstgomes · Accepted solution]

Hi @mahmoodhsaud 

I found another answer here in the community that looks similar to your problem:

https://powerusers.microsoft.com/t5/Using-Flows/Flow-error-Filtering-Data-with-OData-GUID/td-p/14109...

Can you please take a look and see if this solves your problem?

Cheers
Manuel

------------------------------------------------------------------
If I have answered your question, please mark it as "Accept as Solution." It will help other members finding the solution faster. If you like my response, please give it a Thumbs Up. ?
Otherwise, reply to it, and the community will do its best to help you.