Answered

Expand Query is posting null to a HTML Table

(0) Share

Report

Posted on by 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,

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

MJain 2,450 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

johnandrews1987 10 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @johnandrews1987 ,

Glad to see you solved the problem.

You could mark your own reply to close the case.

Best Regards,

Wearsky

Was this reply helpful? Yes No