Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

how to apply filter base on link entity in odata filter query. Note how we use /access newtest-vp_account with hyphen .

Posted on by 15

How to apply filter base on link entity in _odata filter query. Note how we use /access   newtest-vp_account  with hyphen .

(We are trying to use _odata query in power app portal / Dynamics 365 custom portal). Below are the Screenshot of Api URL.

oData-issue.png

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: how to apply filter base on link entity in odata filter query. Note how we use /access newtest-vp_account with hyphen .
    pptset is an entityset created in Dynamics which is a view of lets say A entity. A entity has a lookup of B entity and B entity has a lookup of Account entity.
    In this pptset entityset, we are fetching the attributes of A entity and Account lookup value from B entity.
    When we hit the URL without any filter, it gives us the data in Json format wherein, its representing the Account lookup value as:
    B_entity_name-account_attribute
    And we want to filter our data on the basis of this Account lookup value.
  • Charan Raju C R Profile Picture
    Charan Raju C R 3,155 Super User 2024 Season 1 on at
    RE: how to apply filter base on link entity in odata filter query. Note how we use /access newtest-vp_account with hyphen .

    AakashSharma137

    Can I check if newtest-vp_account is a lookup field name? If yes, how you managed to create a field name with hyphen (-)?

  • AakashSharma137 Profile Picture
    AakashSharma137 10 on at
    RE: how to apply filter base on link entity in odata filter query. Note how we use /access newtest-vp_account with hyphen .

    Hi  I am Also Facing a same issue and I mark this area in to red color. 

    https://test123.powerappsportals.com/_odata/new_testentity?$filter=new_testfield1-new_testfield2/Id eq (guid'3f5t45452b6-a345e-t511-5662-000fere378ab9')&$orderby=createdon desc

  • HenryXie Profile Picture
    HenryXie on at
    RE: how to apply filter base on link entity in odata filter query. Note how we use /access newtest-vp_account with hyphen .

    Hi Ashish, could you post the whole filter of URL and error message ?  because I am not sure which character made this issue, from the screen short there are - _ \  

  • Ashish_Pokhriyal Profile Picture
    Ashish_Pokhriyal 15 on at
    RE: how to apply filter base on link entity in odata filter query. Note how we use /access newtest-vp_account with hyphen .

    Hi Henry Xie, I have removed "newtest-vp_account" hyphen(-) and placed / and %252F  but its still giving a same error.

    Example :

    1-) newtest%252F_account

    2-) newtest/_account

  • HenryXie Profile Picture
    HenryXie on at
    RE: how to apply filter base on link entity in odata filter query. Note how we use /access newtest-vp_account with hyphen .

    Hi Ashish, did you try to use slash (%252F) replace the / character? 

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans