web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Select the country fro...
Power Automate
Unanswered

Select the country from dropdown list in a webpage corresponding to the value in the excel file

(0) ShareShare
ReportReport
Posted on by

I Have an excel file where I need to enter data from it to a web page. I has over 100's of rows with different columns. I am stuck where I need to automate the process of selecting the country from a drop down list in a web page from each row in the excel file. Since it is a drop down selection option. I am using if condition from each country to verify the values and then select the right country in the drop down list. I have more drop down process in the further process. If I have to follow the same if condition method, It takes forever to finish this. Is there any option where I can build a flow to automate the process of selecting the right country from the drop down for each row? 

I have the same question (0)
  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    It depends on how the dropdown is built in the web page. If it is a <select> element with children that have proper names, you should be able to simply use Set drop-down list value on web page and pass the variable value from Excel as the option to select. No need to have any conditions there.

     

    If it's not a <select> element, but more like some <div> that invokes some JavaScript function on click, you will likely need to use Press button on web page to open the dropdown, then use Extract data from web page to retrieve the available values, loop through them to find the one matching what you need, and then use Press button on web page to press the one you matched against. You will need to modify the selector for the option to click on to also include a variable (such as a loop index). See here for more reference on how to modify selectors: https://learn.microsoft.com/en-us/power-automate/desktop-flows/build-custom-selectors#use-variables-in-a-custom-selector Also watch this tutorial: https://www.youtube.com/watch?v=2PcyBa22Jj8&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.

    I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

  • Pavel_NaNoi Profile Picture
    1,074 on at

    No need for a for each / loop, just use a Find or replace in Data table for that one.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 246 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 176

#3
Haque Profile Picture

Haque 157

Last 30 days Overall leaderboard