Hello everyone,
I have two questions about the task I’m trying to solve in UiPath Studio.
This automation aims to fill out a form on a website using data from an Excel file named DEMOQA_FormData.
The processes that I want to add are as follows:
The first process would be for the robot to enter the number 0 into the Excel file ten times when it detects white spaces within the column named “Teléfono.” This ensures that the form can be filled out without any issues, and within the Excel file, in the column named “Estatus,” it can write process “realized.”
The second process would be for the robot to skip the copying and filling of data for a user found on a row in the website form when it identifies a blank space in the “Apellidos” column. This blank space causes an error, which I’ll show below when searching for the attached image within the form. In this second process, once the step is skipped, I want it to write “unrealized” in the “Estatus” column in the cell corresponding to the row where the user is registered.
I’ve been using activities like if, continue, navigate browser, and for each excel row within Try catch, but I haven’t been able to get the result. 
Could someone please explain how I could solve my problem?
My workflow is attached here.
Base_selectores2.zip (614,8 KB)
