I have a SharePoint list with a bunch of columns along with a person/group field. Each Monday I'd like all the records based on a specific filter to be gathered and sent to those names in the person/group field. Example of my SharePoint list:
Project Name Date Person
ProjectXYZ 10/7/2019 Sam Jones
ProjectABC 10/7/2019 Jack Johnson
ProjectEFG 10/7/2019 Sam Jones
The result I'm looking for is one of the two below, either would work.
Option 1: I want one email sent to Sam Jones with his two records and one email sent to Jack Johnson with his one record.
Option 2: I would like one email sent to both of them with the complete list of all three projects.
I'm getting stuck. When I put the Email field from my SharePoint list in the 'To' line, I get two duplicate emails. What am I missing?
Once you got the distinct values use the GetItems to filter by each person collect all values in an array or something. Finally send email. Here you need to use two for each loop. One for distinct values and another for get items.
Hope it make sense.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.
Did I answer your question? Mark my post as a solution!
If you liked my response, please consider giving it a thumbs up