<aside> 💡 Do you need to navigate to multiple URLs iteratively? Each of the URLs contains dynamic values which need to be read from an Excel spreadsheet.
You need to navigate to multiple URLs (and perform certain actions thereafter). For example, you need to navigate to:
Where URL1 and URL2 are dynamic values that you need to read from an Excel file.
In this case, you will need to navigate to the following URLs:
The following flow provides a high level overview of the solution:
We will need to read the Excel data as a datatable using the action “Read from Excel worksheet”. Remember to specify that the first line of range contains column names under the advanced properties.
Then, using the action “For each”, we will loop through each of the datarow “CurrentItem“ ****in the datatable. For each iteration of the loop, we use the action “Go to web page” to navigate to the URL “%Url%/%CurrentItem%/%CurrentItem%” which consists of 3 parts: