cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
troyhoskison
Helper I
Helper I

List CDS - expand query

I am trying to create a email from CDS Data

 

troyhoskison_0-1605111307645.png

 

However I need data from a related table so I added the lookupfield in the expand  query

 

troyhoskison_1-1605111393004.png

When I go to the HTML table section I can see the field:-

 

troyhoskison_2-1605111448864.png

 

So while editing it seems to work

 

but when I run it I get:-

troyhoskison_3-1605111566075.png

But this is the right field:

troyhoskison_4-1605111610986.png

 

Any help would be apreciated

 

Troy

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
JatinSanghvi
Power Automate
Power Automate

Hi @troyhoskison , can you recheck if 'cr318_stockcodelookup' is indeed the navigation property name? You can check the CDS organization metadata by opening '<organization-url>/api/data/v9.0/$metadata' on browser and confirm if the string shows as name of the NavigationProperty element.

View solution in original post

3 REPLIES 3
JatinSanghvi
Power Automate
Power Automate

Hi @troyhoskison , can you recheck if 'cr318_stockcodelookup' is indeed the navigation property name? You can check the CDS organization metadata by opening '<organization-url>/api/data/v9.0/$metadata' on browser and confirm if the string shows as name of the NavigationProperty element.

View solution in original post

Mira_Ghaly
Dual Super User II
Dual Super User II

@troyhoskison 

Can you please show the full configuration of the List Records action?

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

It looks like it was case sensitive

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (24,881)