Hi Friends,
While fixing one issue I needed to change the ‘Show field’ setting for “Person or Group” type of column like Modified By column, My first thought is to use ‘ShowField’ property of a column as I seen this property exist in <Field XML.
Bellow image shows the “show field” option on Edit column page.
I tried multiple option with ‘ShowField’ but no luck and the property was not changing, then after debugging the issue I found that we need to use column’s “LookupField” property to change the setting like following.
- Add-PSSnapin Microsoft.SharePoint.PowerShell
- $webURL = "<Your web url>";
- $web = Get-SPWeb $webURL;
- $mylistName = "<Your list name>";
- $mylist = $web.Lists[$mylistName];
- $mycolumn = $mylist.Fields["Modified By"];
- $mycolumn.LookupField = "Title";
- $mycolumn.Update();
- $mylist.Update();
The other available options to set the ShowField are as following table:
Sr. No. | Show Field drop down options | Exact value need to pass LookupField property |
1 | Name | Title |
2 | Account | Name |
3 | Work email | EMail |
4 | Mobile phone | MobilePhone |
5 | SIP Address | SipAddress |
6 | Department | Department |
7 | Title | JobTitle |
8 | First name | FirstName |
9 | Last name | LastName |
10 | Work phone | WorkPhone |
11 | User name | UserName |
12 | Office | Office |
13 | ID | ID |
14 | Modified | Modified |
15 | Created | Created |
16 | Name (with presence) | ImnName |
17 | Picture Only (36×36) | PictureOnly_Size_36px |
18 | Picture Only (48×48) | PictureOnly_Size_48px |
19 | Picture Only (72×72) | PictureOnly_Size_72px |
20 | Name (with picture and details) | NameWithPictureAndDetails |
21 | Content Type | ContentTypeDisp |
Hope this will help someone from developer community.