Drop-downs from excel

[Adams_Zoe_J]

I cannot figure out how to select the correct item from a drop-down using input from an excel file. I’ve checked other forum discussions, but they just lead to more problems.

[Adams_Zoe_J]

This is my workflow:

Citizens Bot Project.xaml

[Anthony_Humphries]

More on how to do this in this thread.

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

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.

[Adams_Zoe_J]

I do not have the SimulateClick option.

[Anthony_Humphries]

SimulateClick exists for the Click activity, so this should be possible.

[Adams_Zoe_J]

How would I access the SimulateClick option. I put in a Click Activity, but I cannot seem to find it.

[Anthony_Humphries]

It’s at the bottom of the Properties panel.