Dynamics List Records Expand Query use Field From linked Entity in Select Clause

[DarrenMog]

Hi,

Using List Records Controls into Dynamics, have linked to another entity using Expand Query, the data is being returned but when i try and limit the fields being returned(in Select Query), i can do this against the main entity but I'm unable to return fields from the entity in the Expand Query.

Any help would be great.

Cheers

[DarrenMog · Accepted solution]

I figured out the answer, therefore for anyone else searching for something similar

In Expand Query - Add the Entity and Fields Required i.e. Entity1($select=_field1_value)

Then in Select Query - Add the Entity  - Entity1

To Access the field - item()?['Entity1']?['_field1_value']

Just in case someone needs this.