Unable to copy a value read in excel to a dropdown in portal


#1

Hi All,

Please help!!!
Issue : In my flow I am reading a value in a cell from excel and pasting that on a dropdown in portal.
I get below error when I use Select activity for the dropdown

image

The selector value is below when I use UiPath Explorer

I have read the other posts but nothing seems to be working for me.

Thanks in advance

Anshul Agarwal


#2

Hi @anshulagarwal,

So from in your case select item activity it will not support.

Try other ways to select the drop down value.

Refer this post

Regards, Arivu :slight_smile:


#3

Thanks.

Just checked once again and I realised it is not dropdown but a combobox in which we can select multiple values by clicking on the box.


#4

Not sure if this can be done or not. Any suggestions?


#5

Hi @anshulagarwal,

It’s possible use dynamic selector pass your value use click activity ctrl+click.

Pass the aaname as dynamic
For example
aaname ='"+your value+"'

Regards, Arivu


#6

Hi @arivu96

So here is what I am doing.
When I am writing the value after reading, I am using Attach browser. Inside it I am using Click on the combobox to reveal all the values and then delay and then clicking on one of the populated values using the way you told me above

Error

image

Am I doing something wrong here?

Error comes after process of clicking and delay is done

Regards,
Anshul Agarwal


#7

Any suggestions please


#8

hi @anshulagarwal

in this selector don’t click on the button and paste the value

u need to type the value aaname="’+b2result.ToString+’" in the text box and make the title as *

Thanks
Ashwin S


#9

Thanks @AshwinS2

I figured that out yesterday. Thanks for your post :slight_smile:
Probably, where I went wrong was that I was using the varialbe in Selector Editor instead of Expression editor

Regards,
Anshul Agarwal