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 : RoVFH/KXL8s2dCKGjHwdnZ
Power Automate - General Discussion
Answered

CDS One-to-Many Relationship Entity Walking possible?

Like (0) ShareShare
ReportReport
Posted on 18 Oct 2020 19:19:28 by 467

Hello,

 

Within PowerApps I can use the following forumula ThisItem.Customer.'Account Number' to get the customer name which does not exist in the Dynamics Sales Entity however exists in the Customer Entity for Projects, its a CDS based relationship.

 

Within Power Automate is it possible to perform something similar?  Currently a get items or using the Customer Dynamic field downstream are returning the GUID which is to be expected as this field is a relationship field in the Project Entity referencing the Account entity.  Basically, wondering if this can be done without having to perform another list items using a filter on the account entity?

 

Thanks

  • Dudditz Profile Picture
    467 on 18 Oct 2020 at 21:33:18
    Re: CDS One-to-Many Relationship Entity Walking possible?

    @Mira_Ghaly  - Thanks for the confirmation.  This is how I ended up doing it however just wanted to check.

  • Verified answer
    Mira Ghaly Profile Picture
    11,409 Moderator on 18 Oct 2020 at 20:19:37
    Re: CDS One-to-Many Relationship Entity Walking possible?

    @Dudditz

    Unfortunately not you need to have another call to Get Record where entity is account and the identifier is the customer id from your project.

     

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

Loading complete