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
Count(LIST(“table name”[EMP ID])))
This way, i dont have to pre create actions for all possible outcomes