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

Community site session details

Session Id : lT9wgaBwjlrJIQ3kwS6ZuR
Power Automate - Building Flows
Answered

Filtering Dynamics 365 related records

Like (0) ShareShare
ReportReport
Posted on 2 Dec 2019 13:08:49 by

Hi, I am trying to filter records by a lookup field (ie all entities with reference to the same lookup record) but get errors in flow.

 

I get all kinds of errors when trying to execute the query with different formats. The lookup has got the GUID of the linked entity as value, so I am trying like this

 

ppp_primaryentityid eq '<guid of primary entity'

ppp_primaryentityid eq guid'<guid of primary entity>'

ppp_primaryentityid eq (guid'<guid of primary entity>')

 

But all of them generates errors. I have tested with plain ODATA query with the GUID and entity name, and I am sure my data is correct.

 

Is there any standard way to find items across a 1:N relation like this is dynamics?

 

  • v-litu-msft Profile Picture
    on 19 Dec 2019 at 08:23:20
    Re: Filtering Dynamics 365 related records

    Hi @DynoMatter,

     

    Has your problem been solved by @LeeHarris 's advice?
    If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

    Best Regards,
    Community Support Team _ Lin Tu

  • Verified answer
    LeeHarris Profile Picture
    1,026 on 02 Dec 2019 at 16:12:26
    Re: Filtering Dynamics 365 related records

    Hi @DynoMatter 

    If you are using the Common Data Service connector you may have to adjust your filter so that the lookup field name is formatted as shown below.

     

    _ppp_primaryentityid_value eq '<guid of primary entity>'

     

    If this doesn't work please post some screenshots of your filter action and I will try to assist further.

     

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2