I have a designer workflow using HTTP Web Service Call to query a list of items that are due for review and send an email to a group of users. But sometimes a few of the users that received the email does not have a work-items that are due for review (Resolved) which make the email irrelevant to them.
ON the I have a choice column named “Overall Status” with status: New, InProgress, and Resolved. And another people picker column ‘Engineer”
Web Service Call URL:
https://sharepointSITE/_api/web/Lists/GetByTitle('SharePoint List')/Items?$expand= Engineer &$select=Title,Overall_x0020_Status,Engineer/UserName
Is there a way to filter the Web Service Call results and send each user an email with only the items that are assigned to them?