web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / OData Feed: Filter on ...
Power Pages
Unanswered

OData Feed: Filter on lookup name?

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

I've tried to scavenge the internet for this but without any luck. I want to filter on a lookup-fields name value. According to the schema the property is a complex type of EntityReference. I have seen someone suggest (e.g. https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/251843/odata-query-for-filter-on-basis-of-value-in-a-lookup-field-not-by-guid/702721 ) that it could be achieved using 

 

/_odata/MyEntity/mylookupfield/Name eq 'somevalue'

 

Like you can using 

 

/_odata/MyEntity/mylookupfield/Id eq guid'my-guid'

 

which works but I don't wont to filter by Id but rather the Name property. Is this the right way or is it even possible?

Categories:
Power Apps portals
I have the same question (0)
  • v-xiaochen-msft Profile Picture
    v-xiaochen-msft Microsoft Employee on at

    Hi @Anonymous ,

     

    I assume I have a lookup column named 'crba2_test103_lookup'.

    vxiaochenmsft_0-1627531248037.png

     

    You should use '_crba2_test103_lookup_value' instead of 'crba2_test103_lookup'.

    For example:

    vxiaochenmsft_1-1627531315021.png

     

     

    Best Regards,
    Wearsky
    If my post helps, then please consider Accept it as the solution to help others. Thanks.

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi @v-xiaochen-msft 

     

    Maybe I didn't phrase it well enough but I'm not interested in filtering by the GUID but by the Name property of the lookup field.

  • v-xiaochen-msft Profile Picture
    v-xiaochen-msft Microsoft Employee on at

    Hi @Anonymous ,

     

    Unfortunately it's impossible.

    GUID ensures uniqueness. 

     

    Best Regards,
    Wearsky
    If my post helps, then please consider Accept it as the solution to help others. Thanks.

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi @v-xiaochen-msft 

     

    Who said anything about uniqueness? I just want to do a normal filter just like I can do on other properties. I can easily do it on the Dataverse API but this implementation seems to be completely different even though they are supposedly both OData.

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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
Valantis Profile Picture

Valantis 59

#2
11manish Profile Picture

11manish 53

#3
Vish WR Profile Picture

Vish WR 29

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals
Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans