I'm in the process of creating a custom list. All Items in this list will be added by two departments. what I'm looking to do is record which department the user belongs to.
Example: User 1 is in permission group Department 1, User 2 in in permission group Department 2.
User 1 creates a new item in the list. Column in list shows this was added by a user in Department 1.
Essentially I'm looking for a way to record this without including any choice columns for department and was hoping there's a way I can achieve this via the AD or Permission Groups as we will need to know which records have been added by which department in our reporting.
Any suggestions/ideas of best way to achieve this or the closest I can get to this will be greatly appreciated. Thanks