Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I added a conditional column to a list, it had a complicated algorithm to determine the value. I'm sure I had a syntax error in it, however now I can't even access it. When I try to view the list, I get the error...

Error The "ListViewWebPart" Web Part appears to be causing a problem. Specified argument was out of the range of valid values.

Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator.

Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: 85d71f52-7f6f-42f9-901e-659b65eb1f31

I'm using SP 2010 Enterprise.

Does anyone know how I can change the contents of that conditional column and save my list???

share|improve this question
add comment

2 Answers 2

up vote 1 down vote accepted

If you know the GUID of the list, then it should be easy.

Type - http://servername:portnumber/_layouts/listedit.aspx?List={GUID} in the URL and then you will be redirected to the list settings page where you will be able to modify the columns.

To find GUID of the list type this in PowerShell -

$web = Get-SPWeb -Identity http://servername:portnumber
$list = $web.Lists["List Name"]
$list.ID
share|improve this answer
    
Thanks Deepu I'll try that and let you know if it worked for me. –  Ryan Feb 10 '12 at 14:26
    
Wow, that worked great. Thanks for the help! I figured out another way to delete the column, but yours is better. I'll post it below. –  Ryan Feb 10 '12 at 16:01
add comment

Get all the columns...

$web = Get-SPWeb http://yoursite
$list = $web.GetListFromURL("Lists/yourlist/AllItems.aspx")
foreach ($column in $list.Fields){
    $column | Select-Object -Property InternalName
}

then delete the column

$web = Get-SPWeb -identity http://yoursite
$list = $web.Lists["yourlist"]
$column = $list.Fields["yourcolumnname"]
$column.Hidden = $false
$column.ReadOnlyField = $false
$column.Update()
$list.Fields.Delete($column)
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.