Use Drop Down Combo Box to Select each item and Populate Excel Sheet

[VeeLearnMSFT]

After posting this message I was able to extract the drop down list and was able to place it in excel.  I just ended up inspecting the elements and was able to get the values out and parsed out using data functions in excel.

Here is what the list looks like:

Excel Instance 1:

What I want to do is loop through the above excel sheet, interact with the dropdown list, and extract the table results into another excel sheet for each specialty, a running table.. The only thing I would need is to add another column next to the table extract to tell me which specialty is for.  As the table extract does not identify which dropdown was selected.

Excel Instance 2:

What I am getting stuck on is how to I loop throu excel instance 1, interact with the drop down and then past into a running sheet in ExcelInstance 2 with an added column.  The column has to display the specialty as the exctracted table does not contain the specialty it pertains to.  

Can someone please walk me through this process?

My Flow Example

Thanks community!

Website Dropdown:

Sample Table to be extracted, This would be for each specialty:

[VeeLearnMSFT · Accepted solution]

I figued this out and I no longer need help.  Here is what I have done and it worked very well.