Compare properties of JSON to find smallest

[u4jaanus]

Hi,

I am working on flow to retrieve the smallest value of stock of a kit.

i.e. Kit A has components B and C. Stock value for B is 5 and C is 2. Hence sale able qty for Complete KIT A is 2 

my JSON schema below.

{
  "product": "IRE1003",
  "lines": {
    "line": [
      {
        "product": "28CI127",
        "description": "100cm Mirror ",
        "key": null,
        "quantity": "1",
        "free": "5",
        "companyonorder": "20.00"
      },
      {
        "product": "E60CI",
        "description": "LED Light",
        "key": null,
        "quantity": "1",
        "free": "17",
        "companyonorder": "0.00"
      }
    ]
  }

How can I assign the smallest value from objects in Array to another Object.

Desired Answer
{
  "product": "IRE1003",
  "Stock": "5"
}

If you can point me to right direction please.

Thank you in advance.

[Paulie78 · Accepted solution]

https://ibb.co/R35Np3p

[Expiscornovus]

Great solution @Paulie78 🙂

Btw, I think in that last compose you are collecting the individual product id and not the product kit number.

I believe that expression should be: 

outputs('Compose')['product']

[Paulie78]

@Expiscornovus  oh yeah, thanks for the correction and compliment. 👍

It was actually an interesting question to try out. I did it once and it had an apply each loop. I wanted a solution with no loops!

[u4jaanus]

Thanks Paulie,

Didn't realise we can use Select operation Mapping this way.