Help with Automation from excel to Web form

Help
,
1

I am attaching the xaml project as well as the Excel sheet in this topic.

It runs through the whole process fine, but when it finishes to go to the next row on excel it stops.

It doesn’t seem to continue and loop back to fill in the fields from each row on the excel sheet.
When It reaches the last step the mouse snaps to a section of the page and just stops.
after about 15 seconds an error will pop up: (**20.10.3+Branch.master.Sha.7813e000692e3c2b01e0d34df985b6379a3f1eff

Source: Select Item ‘SELECT’ (Select Item ‘SELECT’)

Message: Cannot select item. It was not found among existing items.
TIP: Some combo-boxes delay load items until its dropdown is expanded. Try to simulate a click on control prior to selecting an item.

Exception Type: UiPath.Core.ElementOperationException

RemoteException wrapping UiPath.Core.ElementOperationException: Cannot select item. It was not found among existing items.
TIP: Some combo-boxes delay load items until its dropdown is expanded. Try to simulate a click on control prior to selecting an item. —> RemoteException wrapping System.Runtime.InteropServices.COMException: Cannot select item. It was not found among existing items.
TIP: Some combo-boxes delay load items until its dropdown is expanded. Try to simulate a click on control prior to selecting an item.
at UiPath.UiNodeClass.Set(String bstrAttr, Object vValue)
at UiPath.Core.UiElement.Set(String attribute, Object value)
— End of inner exception stack trace —
at UiPath.Core.Activities.ScopeActivity.OnFaulted(NativeActivityFaultContext faultContext, Exception propagatedException, ActivityInstance propagatedFrom)
at System.Activities.Runtime.FaultCallbackWrapper.Invoke(NativeActivityFaultContext faultContext, Exception propagatedException, ActivityInstance propagatedFrom)
at System.Activities.Runtime.FaultCallbackWrapper.FaultWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
**)

Tes number 2.xaml (37.7 KB)
Copy of challenge.xlsx (34.3 KB)

2

Hi,

I can understand that you are using a select activity and the bot is failing there. The issue with select activity is that, even with the slightest change in the value the bot won’t select the correct one and will throw an error. Can you please check whatever you are trying to select is present in the dropdown ? Select activity is case-sensitive. So check that also.

Thanks.

1 Like
3

Thats just it, Im not trying to select anything in that specific dropdown. I dont have anything programmed to even go to that drop down which is why im so confused.