I created an automation that reads from an Excel file stored in SharePoint. The Excel file contains a column that stores email addresses. After reading all the necessary info in the Excel file, the automation will send email using the SendOutlookMail activity and update the Excel file after the email has been sent out.
My users will update the Excel file and then run this automation using UiPath Assistant. We encountered a situation where after the automation is ran, no email is sent out and the Excel file is not updated. No error is shown in UiPath Assistant. When I ran the same automation reading the same Excel file using UiPath Studio, it showed that the automation was encountering error for the data in the email address column of the Excel file. Upon checking, we found that it contains invalid character “:” instead of the “;” for separating multiple email addresses.
May I know whether UiPath Assistant writes to any logs to show whether the automation ran successfully or encountered any error?
Is there a way for the automation to validate the email addresses read from the Excel file, skip sending the email and inform user of the error?