Forum Discussion
Automatically send an email to a user when 'assigned to' column is modified? (SharePoint Online)
We have a list that contains items which go through an approval process. When a list item is first created, a name is put into the 'assigned to' column, indicating the first approver. When that user ...
Is the list a task list or a custom list? If it's a task list there is an option in advanced settings to send an e-mail when tasks are assigned.
If it's a custom list you can either use flow or if you don't have a bunch of users you can create a view called My Approvals. Filter the view using where Assignedto field = [Me], and then have each person create a list alert, based on when items are changed, sending alert when changes are made in the follow view "My Approvals".
This should send an alert anytime a new item shows in that view, aka someone gets one assigned to them. The only negative with this approach, they will get notification when they make edits to their task when it's assigned to them.
