Select drop down by matching each row value of the datatable

Hi Al,

I am facing some question on selecting the drop down from the list by using value in each row data table.
I am trying “Type into” and “Send hotkey [Enter]” but it select the wrong value that not match with the value in data table.
I try to add “Select Item” but it show not available to use in this page.

For example: I type “United Kingdom” but it selected “United States Minor”.

3

Is there any suggestion on how to solve this issue?

Thanks.

Regards,
Jacelyn

Hi

Hope the steps would help you resolve this

—use a CLICK activity and click on that drop down
—then use TYPE INTO activity and just mention the first two characters of the word you want
Like “UN” for United States and that can achieved by this expression

str_input.ToString.SubString(0,2)

—next to this type into activity use a CLICK activity and click any of the element before running the bot
Once after selecting an element see the selector and look for the attribute holding the value
Then replace that with variable on right clicking that attribute

Pass the value to that variable using a assign and ensure it is place before to the CLICK activity which is clicking that element

Cheers @JacelynLok08

Hi @Palaniyappan,

Thanks so much for the reply. I understand for the 1st 2 steps which is click and type into. And also the substring to get the 1st 2 alphabets.

For the steps after it… I am not sure how to do it. Is it possible to have a sample flow for me to reference on?

And besides that, I found out the website I am looking into for the dropdown was auto select once i key in a “Space”.
And it auto select the last of the similar choice.

For example:
United Kingdom
United States

It will auto select “United State” once the space key in in the type into.

Thanks.

Regards,
Jacelyn Lok

Hi Palaniyappan,

I am able to solve my issue by using your advise above. Thanks for the help!

Regards,
Jacelyn Lok

1 Like

Glad to @JacelynLok08

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