Power Platform Community Forum Thread Details

Hi all,

I'm new to power automate and I'm kind of struggling with this problem.

If the code AND land are the same then add this json part to final_array.

Next if the next json part has the same code and land, then add size and value to the previous
one,while every other part of the json stays the same.
If code AND land are NOT the same then skip and add as a new json part to final_array.

final_array [ ]

json_data

[
    {
        "size": 1,
        "code": "300",
        "content": "xyz",
        "land": "AB",
        "value": 5
    },
    {
        "size": 1,
        "code": "300",
        "content": "xyz",
        "land": "AB",
        "value": 10
    },
    {
        "size": 1,
        "code": "400",
        "content": "abc",
        "land": "KK",
        "value": 12
    }
]

End Result should look like this:

[
    {
        "code": "300",
        "content": "xyz",
        "land": "AB",
        "size": 2,
        "value": 15
    },
    {
        "code": "400",
        "content": "abc",
        "land": "KK",
        "size": 1,
        "value": 12
    }
]

Categories:

General topics

Create an array of unique keys and use xpath to query your json and sum the values:

Select Keys

From: outputs('Compose')

Map:

code

item()['code']

land

item()['land']

Select

From:

union(
	body('Select_Keys'),
	json('[]')
)

Map:

code

item()['code']

content

xpath(
	xml(json(concat('{"Root":{"Item":', outputs('Compose'),'}}'))),
	concat('string(//Item[code="', item()['code'], '" and land="', item()['land'], '"]/content)')
)

land

item()['land']

size

xpath(
	xml(json(concat('{"Root":{"Item":', outputs('Compose'),'}}'))),
	concat('sum(//Item[code="', item()['code'], '" and land="', item()['land'], '"]/size)')
)

value

xpath(
	xml(json(concat('{"Root":{"Item":', outputs('Compose'),'}}'))),
	concat('sum(//Item[code="', item()['code'], '" and land="', item()['land'], '"]/value)')
)