You’re offline. This is a read only version of the page.
Announcements
So here goes:
Imagine a SharePoint List setup like this (there are other columns but I don't need them):
Person 1 | Person 1 Email | Project 1
Person 1 | Person 1 Email | Project 1
Person 1 | Person 1 Email | Project 1
Person 2 | Person 2 Email | Project 2
Person 2 | Person 2 Email | Project 2
Person 2 | Person 2 Email | Project 3
Person 3 | Person 3 Email | Project 4
Person 3 | Person 3 Email | Project 4
Person 3 | Person 3 Email | Project 4
Person 3 | Person 3 Email | Project 5
Person 3 | Person 3 Email | Project 5
Person 3 | Person 3 Email | Project 6
Person 3 | Person 3 Email | Project 7
I would like to send an email to each Person with a list of unique project names:
Email 1
To: Person 1 Email
Dear Person 1 you have pending items for review on:
Project 1
Email 2
To: Person 2 Email
Dear Person 2 you have pending items for review on:
Project 2
Project 3
Email 3
To: Person 3 Email
Dear Person 3 you have pending items for review on:
Project 4
Project 5
Project 6
Project 7
Thanks in advance to anyone who can offer help figuring this out.
Hi @VDOHS,
You can use the Select action to get the key column you want, then use the union() expression to get these unique items:
Then repeat the previous step to initialize an array variable just only have emails:
After all, you can split these projects according to their email address.
Please have a try, if you have any problem, please contact us.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Share
Report
All responses (
Answers (
523
