cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RGB5
Helper I
Helper I

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

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.

 

Condition.PNG

Below is the condition Expression.

 

Expression.PNG

 

 

This condition is getting Evaluated from below Get_Items

 

Get_Item.PNG

 

 

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.

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @RGB5 ,

 

Please try to use TSR/Title

instead of 

TSR

 

Will it work for you?

 

Best Regards,

Wearsky

View solution in original post

7 REPLIES 7
v-xiaochen-msft
Community Support
Community Support

Hi @RGB5 ,

 

Please try this:

LookupInternalFieldName/Title eq 'Lookup Value'

or 

LookupinternalFieldName/Id eq 'Lookup Id'

 

Best Regards,

Wearsky

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
Community Support
Community Support

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

Hi @v-xiaochen-msft ,

 

TSR is the lookup column in my List

 

Look_up Column.PNG

 

The Internal name for the column is TSR 

 

TSR.PNG

 

Filter Query on Get Items

 

Filter.PNG

I tried this but no luck.

 

Below is the screen shot of flow output

 

flowOutput.PNG

 

v-xiaochen-msft
Community Support
Community Support

Hi @RGB5 ,

 

Please try to use TSR/Title

instead of 

TSR

 

Will it work for you?

 

Best Regards,

Wearsky

Wow It worked as expected.

 

Many Thanks!!!

 

 

 Hi @v-xiaochen-msft ,

 

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

 

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,215)