Fabric Set variable Select id from table

[Reponen]

Hello,

I am pretty new with Fabric and Data factory.

I have currently proplem that my set variable selects whole row but i only need id column from table.

My SetVariable now:

@activity('GetDataFromTable').output.value" 

How i fix this?

[v-nuoc-msft · Accepted solution]

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.

[Reponen]

If i try to use it says that 

@Item() syntax can only be used in the filter activity or child activities of a foreach activity

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

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

but gives only first id.

I need a array of ids

[nilendraFabric]

Hello @Reponen 

Matching: Ensure the column name `id` matches exactly (case-sensitive) with your table schema.

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

Or 

@activity('GetDataFromTable').output.value.id

if this is helpful please accept the answer and give kudos