cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FlorentGiboin
Regular Visitor

**bleep** lookup column in power automate

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 ?

2 ACCEPTED SOLUTIONS

Accepted Solutions

@Jdriele 

You should be passing GUID as the error suggests.

You are passing string the Filter Query.

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

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

 

View solution in original post

5 REPLIES 5
rampprakash
Super User
Super User

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

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'.

 

@Jdriele 

You should be passing GUID as the error suggests.

You are passing string the Filter Query.

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

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
Regular Visitor

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

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

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (2,141)