Answered

Expand Query

(0) Share

Report

Posted on by lokeshpatel

I am trying to expand a query from List records. I noticed there are two different actions depending on if you use CDS (current environment) or CDS. In my example below "List records" is CDS (current environment) and "List records 2" is CDS. When I put the same expand query in both, only CDS (current environment) shows up. Can someone explain the different and how to solve this?

Thanks in advance

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

Hello @lokeshpatel

In your HTML table, you are using the Value from your List records, This is why you cannot reference the List records 2

Was this reply helpful? Yes No
lokeshpatel 28 on at

Like (0)

Report

Thanks @Jcook ,

Unfortunately, that's not the issue. I have switched it before and it still does not populate. I would use the other CDS however, then I wouldn't be able to get the labels for option sets.

Should I populate a different input?

Thanks!

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Hi @lokeshpatel

Yes try using a Compose action, or use a select action and make sure the Value is the one from List records 2

Also you can try and paste this into the From field in HTML table:

@outputs('List_records_2')?['body/value']

like this:

Was this reply helpful? Yes No
lokeshpatel 28 on at

Like (0)

Report

@Jcook

The example above was a sample. Here is the solution I'm implementing:

The issue I am getting is related to:

https://powerusers.microsoft.com/t5/Building-Flows/Bug-in-Dynamics-List-Records-Action-JSON-gets-escaped/td-p/186437

Was this reply helpful? Yes No
Verified answer

Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Hi @lokeshpatel

You want to parse the owninguser field since the expand brings the field over as a JSON object.

You can use a Parse JSON action and use this expression in the Content input:

first(outputs('List_records')?['body/value'])?['owninguser']

What I did was run this with Schema as {}

Than copied the JSON from the run and used Generate from sample to create the schema

Doing this, you will be able to reference the values inside the expand query

Was this reply helpful? Yes No