First of all, you should modify your Extract data from web page action to:
- Save the data into a variable instead of an Excel sheet
- Extract more than one row (try capturing all columns that you need in one row and then capture at least one of them in the second row - this should make the helper realize you need a table and will automatically get all rows)
You can then use a Loop to iterate from 0 to %DataFromWebPage.RowsCount-1% (%DataFromWebPage% is the variable where your data will be extracted to instead of the Excel sheet). You'll get a %LoopIndex% variable for each row.
You will then need to try to use that index to click on the Details element in the web page. You will likely need to use Press button in web page or Click link in web page to do that. Try capturing the element in the first row, then in the second and see how the selectors are different. Then modify them to use a variable to use it in a loop.
See here for more reference on how to modify web selectors: https://learn.microsoft.com/en-us/power-automate/desktop-flows/build-custom-selectors#use-variables-in-a-custom-selector
Also this great tutorial video (make sure you give the author a thumbs up): 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.
