Set Drop-down list value on web page Error (Trying to Set Option from SharePoint DropDown): "List Doesn't Contain Option"

(0) Share

Report

Posted on by Alanisp22

145

Hello,

I'm currently facing an issue where I'm unable to set a value for an option in a SharePoint drop-down (combo box/Lookup value column), and I keep receiving the error message "List Doesn't Contain Option." Here's the process I've followed so far: I managed to retrieve the list of values from a SharePoint 'Classroom' drop-down, which is a vlookup column. To achieve this, I utilized the "exact data from web page" action and configured the extraction to output as a 'List' and I set the Base CSS selector to "[class="ms-LookupChoice-container"]." - The list of values from the drop down appear in this step.

However, when I attempt to set the desired value (whether its a variable or a specified text such as 'Classroom 13') from the retrieved list using the 'Set drop-down list value on web page' action, I encounter the "List Doesn't Contain Option" error. It's perplexing because the value I'm trying to set does exist in the retrieved list. I suspect that I might be using the incorrect UI syntax. Currently, I am using input[aria-label="Project1, empty, field editor. "] since I cannot locate a specific ID for this particular drop-down field that relates to all the rows in my list ( I need it to loop through each SharePoint list item and set a drop down value for each.) Any suggestions on what to update to set the drop-down value?

Thank you.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

The Set drop-down list value on web page only works with <select> type elements that have <li> as list items. If this drop down is not of type <select> (which you can check by inspecting it via the browser developer tools), it won't work. It looks like a drop-down, but PAD does not understand it as a drop-down.

In cases like these, what you need to do is click to expand it, extract the values (which you have already done), then loop through the values to find the one you need and use its index to select the value by using Press button on web page. You will need to inject the index into the selector to do that. For reference on how to build custom selectors, I suggest reading this: https://learn.microsoft.com/en-us/power-automate/desktop-flows/build-custom-selectors#use-variables-in-a-custom-selector
And watching this video: https://www.youtube.com/watch?v=2PcyBa22Jj8&t=6s&ab_channel=Thomas%22Shaky%22Petersen
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.
If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

Was this reply helpful? Yes No
Alanisp22 145 on at

Like (1)

Report
Copy link

Link copied!

Thank you! The referenced resources are helpful. I used the press button and input actions to accomplish setting the value. I'll need to further review how to set the index or locate it for the values to loop through the drop down values that I pulled.

Was this reply helpful? Yes No