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
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
The example above was a sample. Here is the solution I'm implementing:
The issue I am getting is related to:
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:
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!
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