I want to create an alert. The person who gets the alert shall be dependent on whats filled in the column "assigned to". Is this possible? or can you only put a specific person or group in the question box " alert send to" ? Many thanks in advance!
You can achieve this a couple of different ways. You can create a Sharepoint Designer Workflow which sends an email based on that field value.
Or you could create an MS Flow online that would run when a new item is created. The process would be:
- Create a Ms Flow
- Select the trigger "When an item is created"
5.Select your site and list name
6.Add new outlook action "Send an email"
7.Set "To" to "Assigned to Email"
From there you set the subject and body to whatever you like.
Alerts are inflexible and the options are limited. I'm using Sharepoint 2013, you've not said which version you are using, but in 2010 + 2013 the menu is the same.
If using Alerts instead of Sharepoint Designer is really your only option, then you could test the following to see if it will meet your needs.
Make a view on your list with a filter, select your 'people or group field' - your field is called 'assigned to', my example has a field called 'action owner'. Set the value to [Me].
Create a new alert - see the picture below, set the alert to be triggered 'when someone changes an item that appears in the following view'. So if someone changes one of your items, Sharepoint should send an email alert.
However, you'll need to test whether or not this works as intended. I have had mixed success with alerts.