Answered

Filtering Dynamics 365 related records

(0) Share

Report

Posted on by DynoMatter

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?

All responses (2)

Answers (1)

v-litu-msft on at

Like (0)

Report

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 1,026 on at

Like (0)

Report

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.