Condition is always evaluating to true and creating the new record instead of update

[RGB5]

Hello Everyone,

I am creating an Automated flow to either insert or update the SharePoint list. My Condition is always evaluating to true and creating the new record instead of update.

Below is the condition Expression.

This condition is getting Evaluated from below Get_Items

Here TSR on the Filter query is a Lookup Driven Column.

But when i am putting the Single line text column under Filter query it is working as expected. Means updating and creating records as per the source (Spread sheet).

Please anyone suggest if missed any step to use my lookup driven column in the filter query ?

Note :- The Lookup driven column will always be a unique value in my case.

[v-xiaochen-msft]

Hi @RGB5 ,

Please try this:

LookupInternalFieldName/Title eq 'Lookup Value'

or 

LookupinternalFieldName/Id eq 'Lookup Id'

Best Regards,

Wearsky

[RGB5]

Hi @v-xiaochen-msft ,

Thank you so much for the quick update. I am just confused a bit since i am new to this technology. 

Here the (LookupInternalFieldName/Title)  is from the lookup list or from the target list where I am trying to update? 

[v-xiaochen-msft]

Hi @RGB5 ,

Using it from the list which has lookup column.

In other words, using this in your filter query parameter of 'get items' action.

LookupInternalFieldName is the name of your lookup field.

Best Regards,

Wearsky

[RGB5]

Hi @v-xiaochen-msft ,

TSR is the lookup column in my List

The Internal name for the column is TSR 

Filter Query on Get Items

I tried this but no luck.

Below is the screen shot of flow output

[v-xiaochen-msft · Accepted solution]

Hi @RGB5 ,

Please try to use TSR/Title

instead of 

TSR

Will it work for you?

Best Regards,

Wearsky

[RGB5]

Wow It worked as expected.

Many Thanks!!!

[RGB5]

 Hi @v-xiaochen-msft ,

Can we use AND condition to add one more column in the Filter query?