Expand Query is posting null to a HTML Table

[johnandrews1987]

I'm trying to create an html table that accesses info from a related entity in Dynamics 365

I've got a List Rows step with FetchXML and an Expand Query - Expand Query is relationshipname($select=description,name).

This goes to a Select step with Dynamic Content from the List Rows step - when I run a test the Inputs are showing this:

    "a_140843db21f4ea11a81500224801c8ab.description": "SOME INFO1",

    "a_140843db21f4ea11a81500224801c8ab.name": "SOME INFO2",

but the Outputs are showing

  {

    "Name": null,

    "Description": null

  }

where I would have expected to see SOME INFO2 as the name and SOME INFO1 as the description.

any ideas how I access this information from the inputs properly?

thanks,

[ManishJain]

Hi @johnandrews1987 ,

Could you share your output of Select and List rows. Ideally select action is used for mapping / changing the name to your desired name before using it further. 

Thanks

[johnandrews1987 · Accepted solution]

Hi Manish, 

I managed to get this working - on the Select step, instead of using the Dynamic content, I wrote the following expression:

item()?['a_140843db21f4ea11a81500224801c8ab.name']

item()?['a_140843db21f4ea11a81500224801c8ab.description']

and it worked perfectly

[v-xiaochen-msft]

Hi @johnandrews1987 ,

Glad to see you solved the problem.

You could mark your own reply to close the case.

Best Regards,

Wearsky