Notifications
Announcements
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 ?
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/UCnGNN3hdlKBOr6PXotskNLAFollow me on Twitter : @rampprakashdBlog : 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_requestFilter : _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.
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.
@rampprakash thx you, sorry I can't accept 2 solutions 😞
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 717 Most Valuable Professional
Michael E. Gernaey 329 Super User 2025 Season 2
Power Platform 1919 268
