Union function missing from function list

[Sitaneph]

I would like to use the union function to get a unique value array from my input array. I have seen many posts that discuss how to use this function to achieve this. However when i have tried to do this I have found that the union function is not in the function list. Am I using the wrong card or is this function only for certain connectors? This is a screen shot of my flow and the error when trying to find union in the functions list.

[v-bofeng-msft · Accepted solution]

Hi @Sitaneph :

I reproduced this problem, the reason for the error is that you did not enter the complete formula:

The complete formula should be something like this:

union('<collection1>', '<collection2>', ...)

Some thing like :

In addition, even if there is no related function in the recommended function list, as long as the formula you enter is okay, then it should still work.

Best Regards,

Bof

[Sitaneph]

Yes just typing in the full expression with correct parameters worked. It is useful to know that this is the case.