I currently have a list which has a lot of savings information for finance to validate. I have created an overdue flag, so that if something has not been validated for more than 7 days, it should mark as "Overdue". I would also like to create a workflow to send finance an email daily on all the items marked "Overdue". Is this possible?
EDIT: Including my currently site workflow below. It is looping through the items, but it is not sending a List of "Overdue" items and only sending an email with the last reference ID in the list thats overdue. What I would like the Email to read it:
Please Validate the below:
Ref ID -overdue by # days
....
Ref ID - overdue by # days