How to set dynamic selector

[j.sorman (Johan Sörman)]

Hello,

Yet another stupid question from a new UiPath developer.

As a follow up to my previous question, found here How to do tasks based on excel or data scapped input

I have scraped a table which i save and store in a excel for later use.
My understanding is I can now read range from my excel file to populate a datatable, correct?

Now to my issue at hand:
In my web application I need to highlight and click on a specific line which get a unique Id, a index number so 1… 2 and so on.

So by that I know my first row in my excel equals to Id=1.

How may I setup a dynamic selector so the robot will click on row id 1, 2, 3 and so on?

Thank you!

[ppr (Peter Preuss)]

@j.sorman
Have a look here:

How to use variables in selectors in Studio (dynamic selectors) without string manipulation!

This tutorial will teach you how to easily use variables in your selectors. In other words, we will be making dynamic selectors without the use of the old method of concatenating strings. How cool is that! For the purpose of this tutorial, I will make 1 click in the Notepad app. Feel free to also reference our documentation here. Let’s begin! 1. First, we will indicate the element we want to click on. In this case, it will be File menu in Notepad: [image] This results in the…

[j.sorman (Johan Sörman)]

So in this example I would have to make the robot open the excel application and make a selector of each row instead of work from a datatable (or collection as I would tell myself in Blue Prism language)?

[ppr (Peter Preuss)]

@j.sorman

let assume following:
your data is in a datatable
within a for each the index output is configured e.g. with var name idx
the selector for clicking on the web element is dynamized with the approach from above on idx

then with chaging idx the Bot should click on row / element 1.2.3.4…

[Mehmet_Unal (Mehmet Ünal)]

For me, it’s solved my problem. Thanks!