Else If not working with Use excel file

Good morning. I am working on StudioX, using a check app state. When target appears, I have an ELSE IF. I am using Else IF, because I need the robot to check if Column name “COA Order Type” is equal to “Cancellation”, is equal to “Renewal”, or is equal to something different. If the column is equal to Cancellation, then it goes to the excel and writes on another column, if it is Renewal needs to go to excel and write something else.

For the first Else IF, I added the use Excel file, which is working as expected. When I add the second Else if option and try the “Use excel file”, all the + signs disappear within the Use Excel File activity, and brings the message of “Condition is required”, even I have it there.
Initially I thought it was an Studio issue, so I closed the program and restarted my computer but I keep having the same issue.


@Karolina_Esquivel,

Try adding another else if condition in your existing else if activity and delete it.

This was a bug in one of the system package version. I think this should resolve your issue.

I did try to add a new Else If, even outside the check app state to see if it work, but no. What I am going to try is to use a different package version to see if that solves the issue. Will keep you posted.

1 Like

@Karolina_Esquivel

Changing your system package version can fix this

Cheers

Hello @Karolina_Esquivel remove the else-if and the use excel file then again drag and drop the else-if conditon and define all the condition first then take Use Excel file activity.

OR

You can take Use Excel File activity before and in the Do block of Use Excel file activity take else if activity then inside the Else if use your excel activity.

Cheers

HI.
I changed the package version to an older one and it working. Thanks

2 Likes