**bleep** lookup column in power automate

[FlorentGiboin]

Hello,
I have always trouble to use lookup column from a table in a power automate (ex: list rows: filter by columns).
It's never simple easy and fast to find the right syntax.
Do you have any article that I could bookmark for the rest of my life ?

[rampprakash]

Hello @FlorentGiboin 

Its very simple. For Keep it Remembering you can simply keep in Mind with _ (Underscore) and value. Thats it.

If the Lookup name is new_countryid then you need to use _new_countryid_value thats it 🙂

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com

[Jdriele]

Might works in many case, but I get an error (sometimes any other crazy message)

Column Name in the listed table : dp_request
Filter : _dp_request_value eq 'DP-001757'

A binary operator with incompatible types was detected. Found operand types 'Edm.Guid' and 'Edm.String' for operator kind 'Equal'.

[Mira_Ghaly · Accepted solution]

@Jdriele 

You should be passing GUID as the error suggests.

You are passing string the Filter Query.

[rampprakash · Accepted solution]

Hello @Jdriele 

_dp_requst_value eq '2a4a3823-c97b-47e7-a889-5fd9c906fa22'

You need to PASS GUID not STRING value hence you are getting that error. Try Passing GUID to get Rid of the issues.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com

[FlorentGiboin]

@rampprakash thx you, sorry I can't accept 2 solutions 😞