Tag: deleted

Today I created a new site column named “Business Category” inside my issue tracking list on SharePoint 2013 server. The column type is a dropdown list. Now the internal name for the column is “Business_x0020_Category”, as shown on the URL where the encoded name is “Business%5Fx0020%5FCategory” :-

Now I try running this command to update the value of this column to all the items inside the list:-

$web = get-spweb "http://****/***/**/"
$list2 = $web.lists("Tracking")
foreach ($i in $list2.items)
{
$a = $i("ID");

$sourceItem = $list2.items.GetItemById($a);

$sourceItem("Business_x0020_Category") = "User Delivery";

$sourceItem.Systemupdate();


}

but I got this error inside the PowerShell command:-

Column 'Business_x0020_Category' does not exist. It may have been deleted by
another user.
At line:5 char:1
+ $sourceItem("Business_x0020_Category") = "User Delivery";
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : OperationStopped: (:) (), ArgumentException
    + FullyQualifiedErrorId : System.ArgumentException

so can anyone advise on this, please ?

and when I run the following command

$web = Get-SPWeb  $web = get-spweb "http://****/***/**/"
$list = $web.lists("Tracking")
$list.fields | select InternalName, StaticName | sort StaticName | ft -AutoSize

the column Business_x0020_Category is listed in the list:

PS C:Windowssystem32> $list.fields | select InternalName, StaticName | sort StaticName | ft -AutoSize

InternalName                     StaticName
------------                     ----------
_CopySource                      _CopySource
_EditMenuTableEnd                _EditMenuTableEnd
_EditMenuTableStart              _EditMenuTableStart
_EditMenuTableStart2             _EditMenuTableStart2
_HasCopyDestinations             _HasCopyDestinations
_IsCurrentVersion                _IsCurrentVersion
_Level                           _Level
_ModerationComments              _ModerationComments
_ModerationStatus                _ModerationStatus
_UIVersion                       _UIVersion
_UIVersionString                 _UIVersionString
AppAuthor                        AppAuthor
AppEditor                        AppEditor
AssignedTo                       AssignedTo
AssignID                         AssignID
Attachments                      Attachments
Author                           Author
BaseName                         BaseName
Business_x0020_Category          Business_x0020_Category
Business_x0020_Development_x0020 Business_x0020_Development_x0020_Tracking_x...
businessfunctionsInitials        businessfunctionsInitials
Category                         Category
Comment                          Comment

so can anyone advise what is going on?