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 Automate / "Expand Query" for Dyn...
Power Automate
Unanswered

"Expand Query" for Dynamics CRM is not fetching related data

(0) ShareShare
ReportReport
Posted on by DiptimanBadajen 2

Hi,

I'm using Flow for CRUD operation on Dynamics CRM data.

I'm trying to fetch all the related "Appointments" for a given "Contact" from CRM. For this I've already tried "Dynamics 356 - List Records" and "Dynamics 356 - List Records (V2)" actions/activities in the flow with "Expand Query" option (Contact_Appointments). This is a general 1:N relationship in default Dynamics CRM instance. However, the body of the response does not contain any related "Appointment" data. (I do not get any error message, the body only contains the "Contact" entity data). Following is the details of the action.

Dynamics 356 - List Records - ActionDynamics 356 - List Records - Action

It would be really helpful if anyone can guide me how to achieve it.

Categories:
General topics
I have the same question (0)
  • v-yamao-msft Profile Picture
    v-yamao-msft Microsoft Employee on at

    Hi DiptimanBadajen,

     

    Please take this documentation about “OData system query options using the OData endpoint” for a reference:
    https://msdn.microsoft.com/en-us/library/gg309461(v=crm.7).aspx#BKMK_expand

     

    From the doc we know that “$expand directs that related records should be retrieved in the record or collection being retrieved.

     

    If you want to retrieve related records, locate the name of the entity relationship that defines this relationship. You may have to view the entity relationship information in the application to correctly identify the relationship or the conceptual schema definition language (CSDL) for the Organization Data Service.

     

    For example, to retrieve opportunity records related to accounts, use the opportunity_customer_accounts entity relationship. The query /AccountSet?$expand=opportunity_customer_accounts returns the opportunity records and the account records.”

     

    Please try to configure the Expand query according to this doc.

     

    Hope this could be a reference for you.

     

    Best regards,
    Mabel Mao

  • Jim Daly Profile Picture
    Jim Daly Microsoft Employee on at

    @v-yamao-msft 
    The link you have provided is not correct.

    This link is for an older OData v2. endpoint in CRM 2015.

    You need to direct people to the current documentation for the Web API, which is located here: 

    https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/webapi/query-data-web-api#apply-system-query-options

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 February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 304

#2
David_MA Profile Picture

David_MA 245 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 243 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans