In this section, we will read each of the Excel rows and invoke the Child bot so that we can send messages to employees on the list:
- Let's add another Step action so that we can logically separate out this block. Add a Step Action and name it Loop through Employee List and send Text Messages.
- Within this Step, add a Loop Action. We will iterate for each row in the worksheet and assign the current value to a new Record variable, which we will call CurrentRow, as shown in the following screenshot:
- Now, we can get the employee name and number from this record variable. As you may recall, Employee Name was in the first column and Employee Number was in the second column. Let's assign them to two new variables:
- Use String: Assign to assign $CurrentRow[0]$ (the first column) to a new String variable called ReceiverName.
- Also, add another String: Assign to assign the next column...