Aggregate values in array variable

Question

A pipeline has a Meta data activity ('Get list of files') that retrieves all of the child items' filenames from a Azure Blob Storage container, and the result passed to a foreach activity:

@activity('Get list of files').output.childItems

for each filename, a lookup activity looks up that file, and the row count is appended to an array variable ('itemCount') within the foreach activity:

@activity('Lookup file item').output.count

then outside of the loop, the final appended variable is output to an array variable, so the result is something like:

{
	"name": "totalCountArray",
	"value": [
		29,
		10,
		11
	]
}

How would you then aggregate the values in the array as a sum of integers? Expected result in the example would be "50"

Answer 1

Hello @Marc Jenkins

Thanks for the clarification, and using MS Q&A portal.

You can make use of foreach loop activity + couple of set variable activities to compute the sum of an array.

Here is a video reference for that. Please go through and let us know if it helps.

Thank you.