Use Drop Down Combo Box to Select each item and Populate Excel Sheet
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
Sample Table to be extracted, This would be for each specialty: