I would like to filter email by:
I have a datatable that stored above criteria, each row represent 1 type of mail.
User can choose to store all criteria for 1 type of mail, or they can enter either one/two criteria for a type of mail. The 3 conditions will be linked up by “And” condition.
e.g. Subject | Sender | MailBody
- ABC company | firstname.lastname@example.org | Invoice
- CD Company | NULL | NULL
For 1, if uipath checked that all 3 criteria matches, then it will assign the 1st mail as ABC company
For 2, since Sender and Body are Null, so uipath will only check Subject field, if subject contains CD Company, then it will assign it as CD company.
My questions is, how should i construct the workflow so that the RPA will ignore Null value criteria, only select those criteria which is not Null, and use “And” condition to assign the mail?
I can only think of creating several nested if condition, to cater NULL and not NULL case with all 3 criteria matches, or either 2, or only 1, but the workflow will be clumsy and difficult to maintain