I am confronted with the following problem: I am looking up a Business Name which is copied from an Excel sheet and then pasted into a search mask on a website.
The problem is that the results is not always the first row, it could also be result 1 or result 2, 3, 4, etc.
BUT the correct result only exists once. So I need the automation to only select the result that matches 100%.
I know that I could change the “inner Text” of the Target but as I want to search for several values (for each excel row) I need the value from the excel copied into the Inner text
So steps are
Log in on website
Search for Business Name on website (Business Name is in excel file)
Wait for results
Select the correct Business out of many results
So the problem is definitely step 4. The automation needs to select the exact match (matching to the excel)
→ If the options are structured after search for the Business Name. Then use the For each Ui element activity and indicate the options.
→ In the for each ui element activity there is option called configure filter there you can provide the variable which contains value on which option to select. Output - CurrentElement
→ Inside for each insert click activity and pass the CurrentElement to the input element option in the properties.
you need to extract the results into a DT. To do that you can use the Table Extraction Activity.
For each item into the DT then you need to compare this item with the Business Name (Exel file). You can do that using an if activity and then type into the condition as follow:
str_currentItem.ToString.Trim.Equals(str_BusinessFromExcel)
If the condition is met then you need to select the desired Ui Element. Using the Ui element activity.
I have a question regarding the extraction to a DT. Would extract data to Excel?
And then how do I set this up correctly so that all data gets extracted? Right now it just overwrites the result from the previous run.
