Get Items with in Time Range

Need your help!


I have a requirement to get all items in a email enable list with in a 2 minute time range.


For example: An email is sent to the list with an attachment at 12:31 and 12:31. This appears as two items on the list. I need to get both ID for the items. I"m using it in another manner.


Background Information: I a process which is running correctly and works well but I can't prevent users from entering items with a previous used email subject.   My current WF looks for all items with the same email subject but these days i'm discovering that users are using the same subject over and over which means that my WF is picking up older items.


Any ideas on this or a better way getting this corrected? Thanks

0 Kudos
1 Reply
Not applicable

Re: Get Items with in Time Range

First important note for this requirement. The SharePoint timer list operates in batches of 5 minutes. Requirements for timing shorter than that may not be reliably met. That may or may not matter for what you're trying to do, but it's worth highlighting.

Second, I'm trying to get clear about your requirement. Perhaps you could set ensure unique values for the column where email subject is stored? That said, I'm not sure of the requirement.

It sounds like you've got a workflow that starts on create that checks all other items in the list, querying for subject and looks for a match. Have you tested this as working correctly? Once I've proven that check then the condition should fire the task (I assume) to have them change the subject or do something else.

Again, I'm not very clear about what you're trying to do. Hopefully this helps.

0 Kudos