topic Re: Fabric Set variable Select id from table in Pipelines

Fabric Set variable Select id from table

Reponen — Mon, 17 Feb 2025 18:35:09 GMT

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?

nilendraFabric — Mon, 17 Feb 2025 21:45:17 GMT

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

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

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

if this is helpful please accept the answer and give kudos

Anonymous — Tue, 18 Feb 2025 02:31:57 GMT

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 — Tue, 18 Feb 2025 12:25:09 GMT

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