String values to Array - To column Expression node ArrayCreate and ArrayContains

[Felipereis50]

Hi friends
How I could do this code using a collection and then passing to an Array Create formula:

Explanation:
I have this values in a column**

My Goal
I want to use this values into this formula: But dynamic

Use an array contains

But, this formula in column expression is hardCode.

---

What I have tried to do so far…

1) GroupBy - Set aggregation

2) Column Expression - Array create
checking

…then I’m Lost now

Any best ideas?

I don’t understand why, even after creating a column with the data type as a collection, it didn’t work inside my variable.

[prashant7526]

@Felipereis50

I want to use this values into this formula: But dynamic

@Felipereis50 What is your end Goal?

[Felipereis50]

Ok…

I think I found a solution.

Instead of manually creating an array, I use the column that already has the data type as a collection inside the “arrayContains” function.

The only downside is that I can’t give the array a custom name like in the previous case.
But look, it worked…

[Felipereis50]

But now I ended in the situation that I can’t create a variable from a data type column like collection…

Create a string collection flow variable

Dear all, I found a way to create a string collection flow variable from a previous post so basically turning a collection column to a flow variable [image] Is there a more straightforward way, without having to go through a table ? like from individual string flow variables to a collection string variable