Matching a information from a cell and selecting in from a drop down

Hi everyone, I need some help. I reading a cell from excel then trying to find that item on a drop down box that holds multiple dates. How would I do that?

Use the Read Cell activity in the Excel Application Scope, and then use Select Item, sending the data from the cell you read.

For more on each activity, see below:



1 Like

Does not work. You have to find the option in the drop down arrow. Cant paste from excel just need the bot to read a cell from excel then click the drop down arrow and find the identical info and select it.

Yes, but finding the option in a drop-down box is what Select Item will do, and Read Cell will read the cell data so you can send it to the drop-down.

Can you show me a build out example?

Processusvierge.zip (17,6 Ko)

I keep getting this error
[Attribute is not supported by the current uinode from the source Get Attribute activity]

The example workflow I’ve provided will not use get attribute. You only need to use Select Item to choose from the drop-down.

image

When you pick the selector for the Select Item activity, choose the drop-down box it self, rather than the item in the drop-down box.

The documentation also states that if this still does not work, use a Click activity to open the drop-down menu, and then use Select Item (again, on the combo box rather than the item itself).

I think something is wrong with my select item activity. I get this error when trying to select a screen shot.

image

Another option is to use SimulateClick on the item in the dropdown after expanding the menu. So you click once to open the drop-down, then SimulateClick to choose the item. You’ll need a dynamic selector for the 2nd one where you insert the value from Excel into an attribute containing the name of the choice.

1 Like