no, my current workflow is basically
get excel sheet -> take required columns from excel sheet and convert to a Datatable variable -> using get row activities assign columns to separate variables-> filter through variables using “if” activities -> send emails based on if activities.
to add context, I have a report that shows clients usage / % through contract and I’m working on using uipath to generate emails "client A is 5% through their contract but has already used “90% of their allowance”
which ive got working perfectly ( after pulling a lot of my hair out in the process )
but if there is an issue with excel sheet which is user populated, the entire bot stops due to an exception.
What im trying to do is ideally send me an email if an except is found, and then continue ignoring that row.
So if its looking for a “#%” and someones entered a name into the wrong field, it doesnt stop the entire bot.
If none of that makes sense, I can quickly make a faux report & upload my bot