Click the button when button text is equal to excel value on specific cell

(0) Share

Report

Posted on by adelevance1

As title, Is it possible when button text is equal to excel value on specific cell then click that button?

(sorry that I asked a lot in this channel but this is the only channel I can ask.. 🙂 )

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

MichaelAnnis 5,727 Moderator on at

Like (0)

Report

Get Web Element Attribute: Own Text Attribute to %OwnText%

If %OwnText% = 'needed value

'do something

End(If)

Good luck!

Was this reply helpful? Yes No
rickFL 30 on at

Like (0)

Report

Hi, This is exactly what I wanrt to achieve, but I am quite new to Power Automate Desktop. Could you explain to me the steps on how to achieve this?

The website looks like the below. The value on my excel list will be filled into the search box and I want to loop through the different options and only click on it when it is equal to the value in the excel cell. Could you help me please? 😊

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report

Can you right-click the element and select "Inspect"? This will open the developer tools of your browser and show what the element selector looks like. If you share a screenshot of that, we might be able to suggest how to build a custom selector for you to click on.

See here for some references on how to build a custom selector: https://learn.microsoft.com/en-us/power-automate/desktop-flows/build-custom-selectors#use-variables-in-a-custom-selector

Also this is a pretty great 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.

Was this reply helpful? Yes No
rickFL 30 on at

Like (1)

Report

Hi Agnius,

OMG amazing! I watched the video and managed to do all of it by myself I learned so much! Thank you! 😁

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

Cool. Make sure you give the video a thumbs up, too. I'm not the author, but I know them personally. They don't do a lot of videos, but when they do, they're usually quite great. So, make sure you let them know you liked it 😉

Was this reply helpful? Yes No
rickFL 30 on at

Like (1)

Report

I already gave the video a thumbs up 😊 Do you have any other good resources on custom selectors?

Was this reply helpful? Yes No