You will need to read from Excel first. Do you know how to do that? You will need to use the "Excel" actions:
- Launch Excel to open the document
- Read from Excel worksheet to read the data (make it read all the data available in the sheet)
- Close Excel to close the document
Depending on your business requirements, if you need to iterate through several items in Excel, you may need to use a loop, such as the For each loop to process them one by one.
Then you need to modify the selector of the UI element you want to click, to be able to use a variable inside it. See this for reference on modifying selectors and using variables in them: https://learn.microsoft.com/en-us/power-automate/desktop-flows/build-custom-selectors
Also 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.
