How to click the name when duplicates found

  1. We have an Excel sheet containing data in the following format:
Candidate Name Candidate City
John Doe New York
John Doe Los Angeles
Jane Smith Chicago
  1. Portal Information: “This same data is available in our portal, where we need to extract specific information related to each candidate.”

  2. Current Approach: “In the portal, we click on the candidate’s name to access the details.”

  3. Issue with Duplicate Names: “However, when there are duplicate names (for example, two candidates named ‘John Doe’), the portal clicks on the same name multiple times, causing the same item to be selected twice.”

  4. Limitation: “We cannot click on the ‘Country’ field as it is not clickable in the portal.”

  5. Is there any other approach or workaround we can use to avoid clicking on the same candidate name twice and efficiently extract the information?"

Current UiPath approach followed
1.Read excel file and store data table:dt_ot
2.Used a loop on dt_ot
2.store candidate name in a variable
4.Click Item(aaname contains candidate name)

Thanks in advance

Hi @NISHITHA,

Could you provide a screenshot of the portal? Also, could you share a selector for any name in the portal as an example? Ideally, include two with the same name so we can see what differs.

Cheers

Hi @Julian_Muhlbauer

Cannot share the portal name as its confidential but this is the current selector format used

The portal contains data in same Table Format as the column in excel

Thanks and Regards

@NISHITHA, could you please send two selectors (the actual ones, without variables) for the same name but representing different people or countries? Please grey out any confidential information.

@Julian_Muhlbauer have attachached here for reference of 2 different name

First SS

Second SS
Screenshot 2024-11-20 213120_2

Sorry for all these questions, but it’s hard to understand what’s happening in the portal without seeing it. Is the structure in the portal the same as in Excel? For example, is the first row with Peter in Excel also the first row with Peter in the portal? Can you modify the selector to include a row number?

Hi @NISHITHA

If nothing works, try adding idx property in selector and pass the index value dynamically using a variable, to identify the index do the calculation beforehand in memory.

@Julian_Muhlbauer the table format is same as Excel

But the Sequence of names might differ from Excel to Portal sometimes

Hello @NISHITHA

For Each activities has the option to save index for current row under properties.
Save this index and use it in the selector of your Click activity.

You can use the Ui Browser to look for a property that includes row/row index in your selector.

Then replace this index with the variable for index from your For Each activity.

Sometimes you have to modify the value +2 to hit the correct line in the UI.

Regards
Soren

Hi @NISHITHA

If (Candidate Name, Candidate City) combination is unique then you can use ‘Candidate City’ as an anchor and pass the city as well dynamically through variable.

Thanks @SorenB , @mrv.raj will try it