How to select the correct dropdown menu item based on a value read from excel?

Help
, ,
1

I have a dropdown menu in my desktop application and I am trying to pick the correct item based on a value in my excel. So say in my desktop application my dropdown menu includes the values Alaska, California, Dakota. I would like to select California if the value in my row1, col1 of excel is “Los Angeles”. How can I accomplish this?
I can get the dropdown menu items by using “select item” but stuck there.

1 Like
2

Hey @sam.sajasi,

Pass your excel value which you read into the select item as a variable.

Thanks :slight_smile:

1 Like
3

Hi @sam.sajasi,

use select item activity:

image

to select California

4

Thanks for the reply. I got that part but first I want to check whether the value from my excel is Los Angeles then I want to pick California. If my excel value is anchorage I dont want to pick California I want to pick Alaska.

5

Thanks for the reply friend. How do I do that? I have also tried using the advance editor to write logic but I am very new to uipath not very familiar with synathx.

1 Like
6

Could you please share your excel and xaml file.

It will be easy to check and provide you with the demo. Thanks.

1 Like
7

Just to give you some context I work in mortgage industry. We get these excel sheets which includes trade info and we manually enter into out loan origination program. Excel look like this

image
image1355×73 5.42 KB

The trade page in out desktop application where I am supposed to enter the data looks like this
image
image618×961 165 KB

I am reading the excel line by line and creating a new trade in my application.
If the col J in my excel has the value “Fannie Cash SMP Arvest” I want to pick “FNMA-Arvest” in my desktop application. If my excel has the value “Fannie Cash SMP PNC” i want to pick “FNMA-PNC” in my application.

Does that make sense?

1 Like
8

Hey @sam.sajasi,

Thanks for throwing some light.

You need to create a master mapping sheet which has this mapping info with two columns - received value & actual value.

Once you get value from the excel sheet, you just compare and filter the master sheet to get the actual value.

Then, Select in the desktop app.

Hope this helps.

Thanks :slight_smile:

9

Is there anyway to do this with code using the advanced editor?

1 Like
10

Yes, you need to have a mapping excel sheet and then write code in advanced editor.