Possible to input a flag in the excel data for which item has processed?
Example, i have a list of emails, items which has filter and sent by email,
This would be a daily task for robot to process.
My objective for this is to resolve on the second day it processed, it should not capture the same data as yesterday and send email again.
My data filter basis is base on 2 month in advance.
All activities is working fine, except for the challenges which i wanted to let the robot to know for what i have processed on yesterday or before as flag thing.
In your workflow, in the email activity, you can filter only the unread emails → the unread emails mean they are not processed yet, and your process can continue the next day to process them.
I don’t know if you’re using transactions or not, but if I understood correctly, one row in Excel is one transaction you want to process; send email. Excel is the input data.
I would do it by adding two columns to the Excel: ID and Processed. ID would be unique id for the row, e.g. a growing number starting from 1, fill up the values manually. Processed would be boolean, true or false, by default all are false.
Automation would first read only those columns from Excel where Processed == false. From the results, automation would go through them one by one. If queues are used, one item is one queue item with the necessary details (ID, email address of the receiver and other necessary data from the row).
After one item is successfully done, it would update the Excel by setting Processed column to true. Correct row can be found with the ID which is found from the data of the item/transaction.
Actually Filter activity is no good here, sorry my bad, at least not for the easiest solution.
Tried it and here’s one quick way of how to do it (project is C#): Loop the rows of the Excel and for each row, check the Process Status column value. If not processed yet, do whatever you need and update the column in the end. Save Excel after each row.
