TYPE INTO an exact match from excel in a dropdown menu, NO SELECT ITEM possible

[LUIS_REYES]

Hello, I,am new to RPA and to UI PATH

I want to TYPE INTO a “drop down menu” in a web site (which is not compatible to use SELECT ITEM), the selection is made based on “each excel row”, the problem comes when similar words exists, how can I run “for each excel row” but making a selection based on an exact match. In this example, want to choose “México” not “Ciudad de Méixco”
Thanks!
(Please be patient, need an explanation with some apples)

[suraj.setty]

Hi @LUIS_REYES

Can you please help to add the screenshot of the Selector for selecting the drop down, i. e Mexico in this case.

Thanks

[LUIS_REYES]

Sure thanks!

[jack.chan]

any chance you can provide the website url here? and can we access it?

[jack.chan]

in your type into activity, remove the enter

and instead, use click activity to select the result , you should only use fuzzy selector and under “Text is” the value should be <[[CurrentRow]ESTADO]>

[ushu (Usha kiranmai)]

@LUIS_REYES Is the application allows you to search for specific item from the drop down. If that happens, then get the data from the excel and search in the that field. I guess it will give the item with exact match. Then click on it

[LUIS_REYES]

@jack.chan

[[CurrentRow]ESTADO]

Thanks! here is the URL: https://consultapublicamx.plataformadetransparencia.org.mx/vut-web/faces/view/consultaPublica.xhtml#inicio

[jack.chan]

use this
the location is an argument (can you call Main6 from your workflow and change the location)

Main (6).xaml (20.4 KB)

[LUIS_REYES]

Thanks, let me try!

[90s_Developer (Murli Manohar K)]

Hi @LUIS_REYES,

Try this method,

1. Use click activity and highlight the first element in the dropdown.
2. In selector for that click activity, and check whether you’re able to find aaname tag. If yes, then pass the country value variable.

So, BOT selects the dropdown option exactly with the value from the excel.

Regards,
@90s_Developer

[Rahul_Unnikrishnan]

Hello @LUIS_REYES ,

Try to inspect on any of the element using UiExplorer. Check whether any attribute is holding is holding the value same as in Excel( for eg: aaname=“Mexico”). If it is there you can pass the values dynamically in the click activity( after typing the values in the Text fiedl, consider if you enter Mexico and you are getting 2 items.
If you want to click on the Word Mexico , then you need to pass only Mexico in the aaname. I hope it should work in your case.

[LUIS_REYES]

Hi, I was reading all the suggestions from you and other, thanks!
I,am a little bit lost, in you MAIN(6) example, yes in fact if I go manually and change the value on ARGUMENT — " in__target" to another STATE i.e. “Baja California Sur” it works fine, but how can I make that this “in_taget” take the value for each row from excel?

thanks!

[jack.chan]

like this