cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

D365 connector- List Records for 1:N relationship

Hi,

I have a requirement to retrieve emails associated with case, in the flow. I'm using List records with the following configuration.

I have used 1:N relationship from case to email.

Flow List records.png

It is not returning the 1:N relationship "Incident_Emails records in the resultset. It has only case records field.

I tried to query the same odata query in the browser. It is returning results properly.

odataurl.png

I would like to know if I have missed something.

And If 1:N relationship doesn't supported then looking for an alternate suggestion.

 

Thanks!

3 REPLIES 3
Highlighted
Super User III
Super User III

Re: D365 connector- List Records for 1:N relationship

Hi @NithyaPal 

 

Try to get the list records from "Email Messages" filtered by regarding id as  your 'CaseId' GUID.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Highlighted
New Member

Re: D365 connector- List Records for 1:N relationship

Thanks for the suggestion. Since I need to retrieve all cases and its associated email, I used regardingobjectid_incident relationship with email to retrieve the records in the following way,
[Organizationuri]/api/data/9.1/emails?$expand=regardingobjectid_incident($select=title,statecode)
Highlighted
Super User III
Super User III

Re: D365 connector- List Records for 1:N relationship

Hi @NithyaPal 

 

If you found a solution please update your post solution accepted. This will help others when they looking for solution.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,322)