I have a "Department" drop-down list on a form, which I would like to set as default to the current users department within Active Directory, but retain the list of values so that they can change this value should they wish.
I know how to pull the users department into a text field using the code :
I've tried putting this in as the default value on the field, but it doesn't work. Anyone managed this? I've had a look on the forums here but can't quite work it out.
we would need more details on your setup and design...
is it dropdown for choice or lookup?
=> for the former your above formula should work, but department you query from user profile has to match up to single character with a choice option.
do you design classic or responsive form or mobile form?
SP/NINTEX product version (2007...2019) may play a role...
in some cases even exact release version might do so....