Hello, I have an Excel worksheet that contains 2 columns and 8 rows. Basically, I would like to store the values in Column B as variable so I can use them in the later part of the flowchart. The reason for having this Excel file is that I would need to change the value in column B from time to time.
Please see the Excel file below
My current approach is below. However, there seems to be a problem storing the variables. I am not sure if Switch Activity is the right activity to be used for this task. Please help… Thank you so much.
Step 1: Excel Application Scope
Step 2: Read Range “A1:B8” then output DataTale “Settings”, and store the Variable as DataTable
Step 3: For Each Row; input DataTable “Settings”
Step 4: In the For Each Row body, use Switch activity; the expression is set as "row(“Settings”).ToString; then for each case, use Assign activity to store all the variables from Excel; for the second row for example, assign PublicFolder = row(“Value”).ToString
See the pictures below