Hi,
I've got a Sharepoint list of Goals assigned to Users with the following structure:
I want to send a weekly e-mail reminder for each "Assigned To" user with a table containing all rows of this list which have the user as the "Assigned To" user in the row, and for which the column "Progress" is not "Completed". The e-mail should contain an HTML table containing the filtered list rows.
My current attempt is as in the following image:
But I need to filter by assignee and send 1 separate email for each of the assignees ("Assigned To") .
Can anyone guide me in the right direction?
Many thanks in advance,
