So to combine the 2 Activity outputs and create a single array,
- use Union function ( assuming you need only unique records in final output as union function removes duplicates)
@union(activity('Filter1').output.Value,activity('LookfileList').output.value)
- You can use combination of set variable activity, foreach activity and append variable activity as below :
a) create a array variable say Test
b) Assign Test variable the value :
activity('Filter1').output.Value
c) Then use foreach activity with iterations as
activity('LookfileList').output.value
d) then within the foreach, use append variable where in you append item() {meaning current iteration value} to the Test variable
This would ensure Test variable contains all values from both the output
- you can also use combination of Join, Concat and JSON function
by JOIN , you can split the array and then via concat you can merge them