Split a list and adding a new row action

I have a table in which i have a list of values. I wish to split these values into separate values and then add a new row action with each value.

so far i have managed doing so when i know in advance the number of values in the list and then created an action for each value using this for example INDEX(SPLIT([EMP ID],","),2)

Is there a way to do so when i have many values in the list and with only one action?



So an action per value as i did?

That’s the easiest way, yes.

1 Like