I’ve been tasked with automating a process for our Sales Tax team where I’m supposed to emulate logging onto a state website, going into what’s known as a “schedule,” and adding records from an Excel file to said schedule. There are a total of 9 fields the bot would interact with when adding a record, and for confidentiality reasons, I’ve censored and lettered them.
A: Dropdown menu
B: Date picker (can type in dd-MMM-yyyy format)
C: Dropdown menu
D: Dropdown menu (will not populate options until an option was chosen for C)
E: Dropdown menu
F: Dropdown menu (will not populate options until an option was chosen for E)
G: Text box
H: Read-only text box (updates when menu F has an option selected)
I: Read-only text box (updates when box G has a value and box H is not 0.00)
I’m not having any trouble interacting or sending input to any of the 9 fields listed above. My issue is that some of the dropdown menus (C, D, E, and F) don’t react properly to the bot’s Select Item activity. These are the steps the bot takes to enter these values.
- Select Item for C (data is from Excel file) + " County" string
- Send Tab Hotkey to C (bot is now focused on D)
- Send Enter Hotkey to D (hitting enter here after selecting an item for C “refreshes” D’s dropdown with options dependent on what was entered in C)
- Try catch: Try->Select Item for D (from Excel). Catch->ElementOperationException->Select Item for D (what’s known as the “unincorporated” option)
When the bot executes steps 1 through 4 on C and D, the little orange triangle in the upper left disappears, telling the website that there are values there (I assume). When the bot moves to repeat the steps on E and F, this is not the case. Specifically, menu E’s box will look like it has a value, but the yellow triangle does not disappear, which causes menu F to not refresh with options after the bot sends those tab and enter keys (steps 2 and 3). I thought maybe the order in which I entered these values matters as tabbing on that website actually takes you to E and F first, so I moved the E/F sequence above the C/D sequence but the same scenario happened.
I’ve tried just about all I can think of from sending extra keys to having the bot physically click on the dropdown in hopes of it expanding/updating but I’m getting nowhere. Is this a website specific thing I can’t get around or is there a UiPath way to fix this issue that I just haven’t tried yet?
Any feedback is appreciated, I can explain further if needed