hi i have problem in droup down .in my source excel file value is Developer but my web drop down value is Developer (IT - Digital Solution) how to match this value before bracket.
Thank you
Hi @MD_Farhan1 ,
Welcome to the UiPath Forum.
Screenshots would be most appreciated for additional clarity but based on what I’ve understood so far, you have values in excel that are only partial matches of what is found in web.
What you can do is use the Find Children or Get Attribute activity on the drop down and use a For Each to loop through each item in the dropdown which checking if the value contains the what you are looking for.
item.ToString.Contains("Developer")
Once you find a match you can assign that to the Select item activity as argument and this should work.
Kind Regards,
Ashwin A.K
i am not clear. before i using select item activity CurrentRow(Column_Name).ToString. now how to update?
Hi @MD_Farhan1 ,
Use a Find Children Activity to fetch all the items present in the Dropdown. Next you have to use a For Each activity to loop through each item in the dropdown list(which is in memory) and search for a match in an If Activity.
item.Get("text").ToString.Contains(CurrentRow("Position").ToString)
Use a Break activity right after that so that it stops.
Kind Regards,
Ashwin A.K
if possible send me work flow screen shot. because i am fresher for this technology.
Thank you
Hi @MD_Farhan1 ,
Here is an example which was replicated on this website.
CompareDropdownValue.xaml (13.1 KB)
Kind Regards,
Ashwin A.K
Are these values going to be consistent? If so, just use a Switch to change the value from Developer to “Developer ( IT-Digital Solutions )” and then use that updated value in your Select Item activity.
no it change depent on department. like it have one developer then ui have on developer like that.
Then I would try a Click on the dropdown then a Click on the desired option. For that second click you can use a dynamic selector ie…
<webctrl aaname='" + yourVar + "*' />"
The catch here is if yourVar is “Developer” and you have more than one option in the pulldown that starts with Developer it won’t work.
pls send me some workflow screen shot because i am fresher.
Thank you.
I suggest doing the free training at academy.uipath.com as it will teach you these basic things like selectors and variables.
i have number of rows to select like this not only one time so mention column Position Right?
If you have data in a datatable you’ll be using a For Each Row in Datatable to loop through the data. Then you’d use CurrentRow(“columnname”).ToString in your dynamic selector (where I put yourVar in the example)
pls give me a work flow bro i am fresher so it more helpful for me and others
As I said, you need to make the effort to go through the FREE training on academy.uipath.com as it will teach you these basic things.
Still I am struggling 
can you send your flow and website so that we can resolve if it is not confidential
Regards,
Dheerendra Vishwakarma
hi,
Already i mention excel and web drop down screen shot in above pls check.
Thank you