Unable to identify the list in dropdown list after recording >> extracting and autofilling the data from excel to web

activities
studio

#1

Hi,

I am unable to select the pathof the dropdown.
I have to collect data from excel and based on that data dropdown should select the data in web page.
I use recording and taking data from excel to web… but break’s at dropdown.

Solution plz,
Priya :slight_smile:dropdown2


#2

You need to used 2 activities.
Type into with “” and activate=check and click before typing =check
Click activity with your selector just change in aaname attribute like below

“”

in_ReportYear.ToString.Trim will be your financial period variable.


#3

“”


#4

#5

not able to provide selector
just need to update aaname with variable


#6

Hi Atrimal,

Where i need to use :
"Type into with “” and activate=check and click before typing =check
Click activity with your selector just change in aaname attribute like below "

Priya :slight_smile:


#7

do not use hotkey activity to remove previous date
Use typeinto and click activity as explained.
In typeinto activity with the listbox selector make properties activate and clickbeforetyping=check
In click activity with any of list item selector.
after selector comes in selector textbox, just edit the aaname=’"+mydata+"’ in selector textbox
image


#8


replace the in_reportyear with your variable in click activity selector textbox
In click activity, to get selector you need select any item within list for eg “May 2018” and then change selector in textbox.


#9

Hi Atrimal,

Thanks for ur reply and solution… i am new to UiPath, really difficult to understand wha tu send… but finally with that, u select the year…

Now i am unable to select the calender…

Priya :slight_smile:


#10

Gr8! Summary is need to create click activity with one of list item as selector. Edit the selector within textbox by replacing the aaname attribute from “list item” to your “variable”


#11

Not understand… andi


#12

it was summary in one sentence.
insert click activity
get one of list item selector by selecting eg. “jan 2018”
edit selector in textbox by replacing aaname=‘jan 2018’ to aaname=’"+myvar+’"


#13

i cant able to select the calendar dates…
Data from Excel data


#14

how to select the year,month and day in single drop down or single date picker, But data has to retrieve from the excel sheet.

we selected these selectors but not working.


#15

Select only textbox selector not datepicker. typeinto activity date string as per format and add tab key after date stringwithin typeinto activity.