Click the list based on the three letter code

Refer the SS:
image
Question:
I need to select the based on the three letter code provided in excel ,
The value may be in first page or last page i need to find that code which matches the excel and i need to click on that specific value

NOTE: Need to work dynamically
Pls help me its So urgent …

@Sudharsan_Ka

You can use Find Children activity and Select Item activity

For reference check below

Hope this may help you

Thanks

It is not a dropdown Find children works only on dropdown right
Im new to Ui path can you elaborate what i need to do?

Hi @Sudharsan_Ka ,

Can you post the UiPath Selector available by using the Ui Explorer for at least 3 items in the results ‘EXI’,‘EXJ’ .etc

Thanks & Regards,
Nithin

1 Like

use Element exist may be it will work am not Shure

@Nithin_P we can use find element like that we can do right use aaname=‘{{Val}}’ i dont know i hope it will work

For EXI


For EXJ

For EXK

Hi @Sudharsan_Ka ,

Add the ‘text’ attribute to the selector by clicking the following check box:

Then share the resulting selector here.

Thanks & Regards,
Nithin

1 Like

1 Like


Use like this in that val place yo can give your code from the excel

Regards
Chethan P

Hi @Sudharsan_Ka ,

You need to make the selector dynamic by selecting a variable for the text attribute:

The variable should be assigned inside a loop. It should change value from EXI, EXJ .etc…

Hope that helps !

Thanks & Regards,
Nithin

1 Like

If i assigned the variable it will choose the three letter code which is in the last page also? if not
i need to scroll and need to find in the list and then i need to click for that what i have to do?

@Sudharsan_Ka

You can try with click activity and use the selector you used in Element exist

Also check stimulate click and try

Hope this may help you

Thanks

How to use element exists dynamically

I need to add variable to the selector right?

image

whether I can use like “row(“column Name”).toString” inside that as variable or else i need to create one by assigning it and then give input

I recommend assigning “row(“column Name”).toString” to a new variable and then using the variable in the click activity.

Thanks & Regards,
Nithin

Hi @Sudharsan_Ka ,

It should generally work even if the element you want to click isn’t available on the screen. But this behavior will change from application to application. Hence I recommend you test it out and if the click doesn’t work then you can try using Send Hotkey (Down Arrow).

Thanks & Regards,
Nithin

I have created the workflow like getting each and every row by get text and assigning idx value dynamically and if the text found click that if not increment idx+1 and iterate the same process
problem is it is getting all the text but it is not clicking on the text instead it looping continuously and execution stopped without clicking
Start node



increment is done in the highlighted area

@NIVED_NAMBIAR @copy_writes Bro can you help with this task