You cannot extract this data all at once. As @Nived_Nambiar has correctly noted, you will need to do this in two separate steps, because the information is available in two different pages. But this can still be done in the same flow.
To add to what Nived said, I would suggest trying to extract a URL to the product page along with the title, if possible. This will make it easier for you to open each individual product page - you will not need to click on each product, but will be able to instead use Go to web page and go directly to it using the URL. This will also mean you will not need to return to the product list after each product page.
So, if you can use Extract data from web page to extract a table that would contain the product title in one column and the URL to the product page in another column, you can then use a loop (I recommend For each) to iterate through this table.
As you iterate, your %CurrentItem% (generated by the For each action) will contain a data row with two values - the title of the current product and its URL. You can then use Go to web page to navigate to the product page and use another Extract data from web page action to retrieve the product details.
Then you can use Get first free column/row from Excel worksheet to get the row to write to, and then Write to Excel worksheet to write the title and the details to Excel.
You will be writing one product at a time to Excel to make the flow simpler. It would also be possible to handle it as a new data table and then write all of it to Excel at once, but that would be slightly more complex to implement.
Here's what a flow like that could look like:
I won't be providing a snippet for you to copy, because I just captured the data of a random page in there, and not the web page you are using. Also, I simply selected writing to columns A and B in Excel, while you might want to write to different columns.
-------------------------------------------------------------------------
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.
