cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MartinG1
Regular Visitor

Set drop-down list value on webpage using a partial match

I have an excel column called "Trader Name" that I'm trying to match to a specific drop-down value on a webpage. 

However using the "Set drop-down list value on webpage" action unless the value in my excel column exactly matches a row in the webpage drop-down it will fail.
Is there any way of partially matching a row in the webpage drop-down i.e. Breeze Motor in my excel column would match and select Breeze Motor Co Ltd, Yarrow Road, Poole, BH12 4QY in the webpage drop-down?

 

MartinG1_0-1642432397946.png

 

1 REPLY 1
Guriga
Advocate II
Advocate II

Hi, 

I don't know do you still looking for a solution for this but here is a little example for help:

Guriga_0-1646747206200.png

NewVar for searching the part text. For testing, it's easier to use like this.

car.xlsx has a couple of car company names.

Read the excel and go on each value of it starts with the NewVar.

This is in the IF statement.

You can use the CurrentItem to add to the Option Name in the select drop-down

 

Hope the content above may help you.

 

Best Regards
If my answer helps, then please consider Accept it as the solution to help the other members find it more quickly. function.

 

 

 

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (3,205)