Workflow to send 1 email for multiple items with the same value (dont want multiple emails)

Question

Hi guys I have a SharePoint list, where a few fields in the list have the same value, Id like to have a workflow send an email to the creator, but I don't want multiple emails for every item that was created by them and have the same value in REQStatus field which will change from multiple status fields.

Example:

I have a form with a repeating table, which can submit unlimited items to a list. So lets say 1 form has 5 items it submits to a list, each of those 5 items will have the same "REQNumber" and all five items will have the same status so "REQStatus" when REQStatus changes to Ordered I want an email to go out basically saying hey "REQNumber XXX" has been ordered. But I don't want them to get 5 different emails, is this possible?

Answer 1

I would suggest this approach :

Add a web service HTTP call activity to your workflow.

Using this activity, make an HTTP call to your Sharepoint list.

The URL should looks like this :

http://yoursite/_vti_bin/ListData.svc/yourlist?$select=REQStatus&$filter=(REQNumber eq 'CurrentElementReqNumber' and REQStatus eq 'Ordered')

Notice that the URL contains a filter to returns only items that match the current element REQNumber and that has a REQStatus Ordered.

If this request returns no results, send an email.

In the other hand don't send an email.