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.

Blog: here

It looks like it was case sensitive

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Kudoed Authors
Users online (2,671)