Using excel information to click proper selector

I’ve attached an image that shows the site that I’m working on. I have a spreadsheet that has the numbers on the far right listed. I need to use that cell to dictate which selector to choose on the left side. As you can see, there are no other differences. How would I utilize some type of variable to recognize the number and use that info to choose the right + sign?

Hi!

See this article for how to use dynamic selectors Studio - Dynamic Selectors (uipath.com)

Try using the activity Extract Table Data to read the whole table as a datatable, identify which row has your value and then use that information together with a click activity and a dynamic selector.

If the table extractor does not work use the UI explorer in Studio to find out how the page is structured.

Hi @trentm

If you are using Modern Activities, Use a click activity with
Target as that left most plus(+)
Anchor as Right most column where you have those ID’s taken one by one from Excel file.

Then make the selector dynamic by choosing aaname property in Anchor and replacing it with CurrentRow().toString.

Hoping that you have used a For Each Row activity and doing all of this click and further tasks in that loop.

Happy Automation!

Hi @trentm

→ Use the for each Ui element activity and indicate the first element in the spreadsheet. Output is CurrentElement.
→ Inside for each insert an Get attribute activity and pass the CurrentElement in the Input element option in properties then select the attribute which contains the code and save in a variable.
→ After Get attribute activity insert the If activity to check the condition.
→ Inside then block insert the click activity and pass the CurrentElement to the Input element option in properties.

If you have any further queries on above steps, let me know.

Hope it helps!!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.