Business Exception Rule : If First Name is empty, Skip entering the values into the web Page Fields, Type “Skipped” in Status Column of Excel and continue executing with the next Row values accordingly.
The flow looks fine. If the report is not true, please put the write cell out of the if. Write cell is already in the business exception state in set trancastion status. Can you try it?
I have to apply a business rule exception. i.e: If the First Name Value is found empty in the excel sheet, Robot should not enter the remaining values. It should just skip that whole row.
So basically, Robot should enter values of 3 rows. and skip rest of the 2 rows as they don’t have First Name.
You can create a variable of type BusinessRuleException : BusinessMessage
Then replace through with a assign activity as BusinessMessage=New BusinessRuleException(“YourBusinessRuleExceptionMessage”)
When all field filling is completed then you can use if activity to check BusinessMessage as follows
if :
BusinessMessage isNot Nothoing
then :
Use throw activity as with BusinessMessage as input to throw.
Thanks & Regards,
Dibyaprakash
You can mark this as solution if this one resolves your issue.