How can I apply a function to an activity result (a list)?

[amaaiia]

I have a simple data Pipeline as follows:

get_data_list activity  returns a list of rows of a table. So, to access output data I should: 

@activity('get_data_list').output[0].filed1
@activity('get_data_list').output[5].filed2

How can I get the min value of field1? I can't do:

@{min(activity('get_data_list').output.filed1)}

because the output is not a list of integers, it's a list of rows.

[Anonymous · Accepted solution]

Hi @amaaiia ,

With your description, if you want to get the minimum value of field1, you can use a loop to traverse the list and apply the min function to the extracted value.

Refer to below:

# Assuming get_data_list returns a list of rows
data_list = @activity('get_data_list').output

# Extract field1 values from each row
field1_values = [row.field1 for row in data_list]

# Get the minimum value of field1
min_field1_value = min(field1_values)

Best Regards,
Adamk Kong

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