Hello,
I have a form where multiple Customers (key values) are selected from an enum list. I’ve tried creating a bot which then adds certain products to these customers-- these products are related rows of the Customers table, located in a separate Products table.
The bot would run a looping action with “add a new row to another table using values from this row”. The crucial value is the Key value of Customer in the product table which relates the two. My question-- is there a way to work off a list of provided keys? In the action bot, “add a new row to another table using values from this row”-- to add the Customer key into the Product’s customer column, normally I’d simply input [Key] as the value to pass on. However, my form contains multiple keys…each of which need a new row in the Products table. So far, I’ve only gotten the action to generate the first key in the enum list.
I’ve created the same looping action for the Customer table that does not use the form or bots, where the user selects multiple customers from a table view and then selects the action. This works just fine and will do the job.
Mostly just curious if the above scenario is possible.
Thanks for any input!