cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

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
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
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

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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Top Kudoed Authors
Users online (6,493)