Use Extract data from web page to capture the items in the drop down on the web form. Extract them into a list and use that for matching. Then use the index of the item that you've matched when clicking on the element.
If it is a <select> element, you don't necessarily need to use this approach, however - you could use Set drop-down list value in web page to simply set the value based on a variable value from Excel.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
