Run one action for n times based on calculation

Ami
Bronze 5
Bronze 5

Hello
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?

To clarify, i want my action to run based on Count(LIST(โ€œtable nameโ€[EMP ID]))

Each action will execute
INDEX(SPLIT([EMP ID],","),
Count(LIST(โ€œtable nameโ€[EMP ID])))

This way, i dont have to pre create actions for all possible outcomes

Thanks

0 5 388
5 REPLIES 5
Top Labels in this Space