Unanswered

Select from Drop-Down List

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have a flow that is using a company specific application/software. Essentially I want a user to send in a form with the data that needs to be populated into the applications table. So basically, if I receive a submission like this:

That PAD would recognize the data in B and put it in the appropriate column in the application's data table. I have gotten this to work with just text that needs to be populated, however the first (essentially A1) cell in the application's data table is a drop down list. How can I get PAD to recognize the data in the Excel submission as an option in the dropdown list in the application. I've been trying to set variables and parse text but so far no luck. Any ideas or solutions?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (0)

Sort by

VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

For selecting dropdown values you can make use of the action:

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi, thank you for your answer. I want it to select the drop down text option that matches the answer coming from the user submission. I tried to use the read data action and store it in a variable and then use that variable as the option name from your screenshot above, but that did not work.

Was this reply helpful? Yes No
Henrik_M 2,021 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The text content of the variable must match the dropdown option exactly. Have you double checked?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yes, for some reason it just doesn't recognize it. I'm not sure if it doesn't recognize the text or the dropdown list.

Was this reply helpful? Yes No
Henrik_M 2,021 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Can you select option(s) by index instead of by name?

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

The regular dropdown selection should work.

If still facing issues also try sendkeys by typing the text on the dropdown.

Was this reply helpful? Yes No
Spike27 2 on at

Like (0)

Report
Copy link

Link copied!

Hi VJR,
I am trying to select club names from a dropdown list of clubs. It works fine if I create an individual action:
However, I would like to have the club name as a variable and use a loop to go through the whole list of clubs. if I try to use "Set drop-down list value in window"
I get an error to say that the value (ie the club name) does not exist on the list
(For reference the URL is: Premier League Player Stats - Appearances)

Do you have any suggestions please?
Thanks!

Was this reply helpful? Yes No
momlo 1,527 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Drop down the list... sometimes they are hard indeed - it all depends on how the page or app was created.
To be honest - sometimes you need to try all sorts of options to make them work, from dedicated list action, through JS script execution to send keys.
It really depends on the way they are built in a particular case.

Was this reply helpful? Yes No