How to get related entities using Flow

(0) Share

Report

Posted on by Ainsley

Hello,

Im trying to use Flow to get related entities, im using the expand query to get at a few related entities.

I've been following this short example on this blog https://dynamicsbackpage.wordpress.com/2019/12/27/using-expand-query-in-power-automate-with-cds/

I am unable to get my related entities to show up in the dynamic content pane.

Here is my expand query

parentaccountid($select=name,accountnumber),parentcontactid($select=businesscard),owningbusinessunit($select=businessunitid)

when i search for account number i dont see it in the dynamic content pane

Would someone be able to help?

Thanks!

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Linn Zaw Win 3,407 on at

Like (2)

Report

You are using the different CDS connector. You are supposed to use the Common Data Service (current environment) connector to see the related entities to show up in the dynamic content pane.

This is the comparison of the dynamic content from the standard CDS connector and the CDS (current environment) connector with the expand query for parent account number.

For any reason, if you need to use the standard CDS connector (e.g. cross-environment access), use the Parse JSON action to get the dynamic value from JSON object. You can find out more details in my blog.

http://linnzawwin.blogspot.com/2019/12/power-automate-list-records-use-expand.html

Was this reply helpful? Yes No
Ainsley 90 on at

Like (0)

Report

Thanks for the help! This approached worked for me when I was trying a many to one relationship. But when tried the expand query on a one to many relationship i dont see of the columns, would you know how i can see them?

Was this reply helpful? Yes No
Verified answer

Linn Zaw Win 3,407 on at

Like (1)

Report
For one to many relationships, you will need to use Parse JSON action.

http://linnzawwin.blogspot.com/2019/12/power-automate-list-records-use-expand.html#getsampledata

In the example below,

contact_customer_accounts($select=fullname)

List the Account Records with related Contacts (using the following expand query above)

Parse JSON

Loop the Account list from JSON body

Loop the Contact list for each account

Get the Full Name of the child Contact records of the Account

Was this reply helpful? Yes No