Invoice Retrieval from Website: How to iterate through two dropdowns to download invoices

Help Studio
, ,
1

Hello,

I need a bot to retrieve invoices from a website. The website has two dropdowns, one with portfolios and one with accounts. I need the bot to iterate through all the portfolios and accounts. Here are some screen shots of the website:
image

image
image872×437 15.3 KB

Has anyone else had to do this and would you be willing to share your solution?

Thank you,
LHub

Update #1: I have been able to store all portfolio names from the portfolio dropdown in a data table and get the bot to access and download the invoice of the first account in the second dropdown. I’m struggling with getting it to go to the next account. -LHub

2

@Laura_Hubbard

Get all accounts also similarly…and use a second loop inside the first for account

Cheers

3

Do you want to iterate for the portfolio and then for each in portfolio iterate through the account,
if yes then use a loop inside the first loop to do it
or explain what is the issue is it the selector