Hello, I am currently working on Automation Bots. When a user answers yes to a data field I am trying to have the automation bot add multiple new rows to a "Task" table. Essentially having multiple tasks populate to the user's task list when they select yes to a checklist item.
Currently, the bot is only adding the "Call Firm Lead Prospect" to the "Task" table but they are not adding the "Email Firm Lead Prospect" to the "Task" table. Is there a way to have the bot add both at once or do I have to create a different bot to perform each one separately? Screenshots attached.
Thanks in advance.
Solved! Go to Solution.
My testing showed that one can add two "row add" action steps in a single bot. The two bot steps adding two rows to a single table ran successfully.
1st Step as below
2nd Step as below
The rows added by the bot are below highlighted in turquoise
You can see the [Quantity], [Product ID] have changed as per 1st and 2nd step in the bot steps. The [Ordder ID] which is reference of parent is same because two records are added with reference to one parent record and [OrderDetail ID] , which is the key of the child table is set uniquely for the two records. [Total] is a computed column so it need not be set in the bot.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |