Adding a calculated column to array

(1) Share

Report

Posted on by CU20021609-0

Hi,

I have this array that has two columns, "Price" and "Quantity"

<root>
  <array>
    <Product>A
    </Product>
    <Price>120
    </Price>
    <Quantity>45307
    </Quantity>
  </array>
  <array>
    <Product>B
    </Product>
    <Price>58
    </Price>
    <Quantity>2530
    </Quantity>
  </array>
  <array>
    <Product>C
    </Product>
    <Price>165
    </Price>
    <Quantity>685
    </Quantity>
  </array>
</root>

I would like to add a calculated column to this array to calculate the total value for each product, "Value" = Price * Quantity. I am looking for a XPath solution rather than "Apply to each", if possible.

Thanks.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @CU20021609-0

Try like as shown below

1. Use a compose action to store the xml input

2. Use Select action to perform the calculated column operation as shown below

Expression:

json(xml(outputs('Compose')))?['root/array']

Expression:

addProperty(item(),'Value',string(mul(float(item()?['Price']),float(item()?['Quantity']))))

3. Use a compose action to structure the array like below

4. use compose action to convert the json in above compose action to xml.

Final XML looks like this

<root><array><Product>A</Product><Price>120</Price><Quantity>45307</Quantity><Value>5436840</Value></array><array><Product>B</Product><Price>58 </Price><Quantity>2530</Quantity><Value>146740</Value></array><array><Product>C</Product><Price>165</Price><Quantity>685 </Quantity><Value>113025</Value></array></root>

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!

Was this reply helpful? Yes No
CU20021609-0 5 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Nived_Nambiar. This is exactly what I was looking for,

Was this reply helpful? Yes No