To replace the value of a microphone from $10 USD to $5 USD, we will first name a set variable as RowIndex. We will start with 0.
Next, we add a “for each loop” action into the workspace. We will select %Table% from the variable drop down menu (click the {x} button) in the for each dialogue box. We will be setting an if condition for each item in the table.
Insert an “if” action to the workspace. Set the first operand to the current item of the column name. In this case, we are looking for “microphone” in the column “Product Name”.
For cases where the above if condition is fulfilled, we will then manipulate the product price column of that table row to contain the new reassigned value of 5 USD.
We then need to use the “increase variable action” to increase the row index.
Running the flow will show us that we have successfully updated the microphone price!
