Fabric Set variable Select id from table

Hi Reponen 

Thank you very much nilendraFabric for your prompt reply.

For a single row,

@activity('GetDataFromTable').output.value[0].id

Assume the output of GetDataFromTable is as follows:

{
  "value": {
    "id": 123,
    "name": "example",
    "age": 30
  }
}

Then @activity('GetDataFromTable').output.value.id will return 123.

For multiple rows:

@array(activity('GetDataFromTable').output.value, item().id)

Assume the output of GetDataFromTable is as follows:

{
  "value": [
    { "id": 1, "name": "Alice" },
    { "id": 2, "name": "Bob" }
  ]
}

Then @array(activity('GetDataFromTable').output.value, item().id) will return [1, 2].

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.