I have a custom list with columns: System Admin Name, Access End Date and several other columns. Now I want to create a workflow that will run daily at time X on this list. The workflow should iterate through each item in the list, and check if Access End Date = Today, if true, it should send an email notification to Admin Name
+11
If you search and surf through the community you will get your answer. Here is the gist of it:
1. Create Site Workflow
2. Query list to get all the ID's in a collection variable.
3. For-Each ID in the collection, compare the date with today.
4. If Yes, send the notification.
5. Create the workflow schedule, add the next date and time you want to run at and enter repeat in 1 day.
Hope this helps.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.