I have a list with a multiple choice column - 'Department'(dropdown).
I essentially need to send out an email notification to the department group (Sharepoint Security group) depending on which department the user is assigned to and am able to do it by listing out every department listed out.
However, I was wondering if there was a much elegant way to do it by using variables or parameters. Example: If Department (D) changes to New department (N) send notification email to SharePoint Group N (Associated group to specific department).
Is this possible in SharePoint designer or would it require Visual Studio?
Any other suggestions are greatly appreciated as well.