dataverse list rows append to array retrieves no value

(0) Share

Report

Posted on by Rosie

292

Hello,

I am trying to produce an array to use in an email, the array values come from a related entity.

I have looked at mulitple blogs and still I get no values.

I am able to retrieve the information for the related entity but when I append to an array I get no values.

The table is QPOrders.

The related table is QPContainers.

For one order there are multiple containers, I want to get all the container id's related to the order.

When the row is modified, get the row by ID, I use compose to get the order status for a switch statement later on, Initialise a Array variable.

Then use List Rows to the the container numbers from the related table QPContainers.

Then an apply to each using

outputs('List_row_-_ContainerDetails')?['body/value']

The json sample used is the first item in the body.

As you can see in the Parse Json output the containers ids are there but for some reason they don't appear in the array.

Many thanks

Rosie

I have the same question (0)

All responses (8)

Answers (1)

v-chengfen-msft on at

Like (0)

Report

Re: dataverse list rows append to array retrieves no value

Hi @Rosie ,
Judging from the screenshot you provided, the ID you need to obtain exists in the array, and you should need an [Apply to each] to traverse (the part enclosed in orange in the screenshot), and then add ID to the array
I made a test to get the ID in the array in Object:
Need to traverse the array to get its ID

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Rosie 292 on at

Like (0)

Report

Re: dataverse list rows append to array retrieves no value

Hello,
Thanks for that, I have made some progress but it keeps adding a 2nd apply to each when I add in the field to the array.
I am not sure how to stop this happening - I must be picking the wrong part of the json.
I select qp_Containers_qp_Orders_qp_Orders as the output from the previous step.
When I go to add the field in the array variable, I can actually see the qp_containerid variable. When I add it suddenly another Apply to each is added.

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,059 Moderator on at

Like (0)

Report
Re: dataverse list rows append to array retrieves no value

@Rosie Directly after your List rows - ContainerDetails, can you add a Compose and use the following expression. This should return all the qp_containerid values in an array for you. This will eliminate the need for a loop and appending to an array, etc. See how it goes and let me know if any issues.

xpath(xml(json(concat('{"root": ', outputs('List_rows_-_ContainerDetails')?['body'], '}'))), '//qp_containerid/text()')

Was this reply helpful? Yes No
Rosie 292 on at

Like (0)

Report

Re: dataverse list rows append to array retrieves no value

Hi @grantjenkins,
Thanks for the suggestion but that didn't seem to work for me.
I used the Compose Data operation and pasted in the code.
There is no output other than the same piece of code.
For some reason in List rows I don't get a 'Show raw outputs' option. Only download. Not sure if this is impacting the outcome I am getting.

Was this reply helpful? Yes No
grantjenkins 11,059 Moderator on at

Like (0)

Report

Re: dataverse list rows append to array retrieves no value

@Rosie It looks like you may have just added the expression directly as text. You'll need to add it as an actual expression.

Was this reply helpful? Yes No
Rosie 292 on at

Like (1)

Report

Re: dataverse list rows append to array retrieves no value

@grantjenkins you are quite right, what was I thinking.
I will give that another go.
Thanks so much.

Was this reply helpful? Yes No
Rosie 292 on at

Like (0)

Report

Re: dataverse list rows append to array retrieves no value

Hi @grantjenkins ,
I am getting results now, thanks so much.
For each value in a row do I need to create a Compose actions, then Append to the variable?
I need to the results to be in the email, I have tried "Create HTML Table" but there is something not right.
Maybe you can provide some guidance?

Many thanks
Rosie

Was this reply helpful? Yes No
Rosie 292 on at

Like (0)

Report

Re: dataverse list rows append to array retrieves no value

To take the compose output to a table (for each set of values retrieved) see the solution in this post.

Was this reply helpful? Yes No