Issue : Just Today i came accross a issue in Which the User had a List with many columns and One of the column Which was a look up column was corrupted
used to give a error "Unknown Error"
We were not able to Delete or edit the column
After a lot of research we found a work around to delete the Column
Checked the Url and found the below
/_layouts/FldEditex.aspx?List=%7B37920121%2D19B2%2D4C77%2D92FF%2D8B3E07853114%7D&Field=Product%5Fx0020%5FDescription
Which is a wrong url it should be
/_layouts/FldEdit.aspx?List=%7B37920121%2D19B2%2D4C77%2D92FF%2D8B3E07853114%7D&Field=Product%5Fx0020%5FDescription
Just remove ex from FldEditex.aspx => FldEdit.aspx
And you will be able to get to the inside of the column where you can edit or Delete the column .
Cause - Unknown
used to give a error "Unknown Error"
We were not able to Delete or edit the column
After a lot of research we found a work around to delete the Column
Checked the Url and found the below
/_layouts/FldEditex.aspx?List=%7B37920121%2D19B2%2D4C77%2D92FF%2D8B3E07853114%7D&Field=Product%5Fx0020%5FDescription
Which is a wrong url it should be
/_layouts/FldEdit.aspx?List=%7B37920121%2D19B2%2D4C77%2D92FF%2D8B3E07853114%7D&Field=Product%5Fx0020%5FDescription
Just remove ex from FldEditex.aspx => FldEdit.aspx
And you will be able to get to the inside of the column where you can edit or Delete the column .
Cause - Unknown
Thanks Amol. It works. Helped me fix a corrupt look up column. Cheers!!
ReplyDeleteNo problem Manjeet :) Always welcome. Do let me know in case of any queries/questions, Thank you!
DeleteWorked for me. thanks
ReplyDeletemy pleasure :) Do let me know in case of any queries/questions, Thank you!
DeleteLove it!! Knew there had to be an easy way. Thanks!!!!!!
ReplyDeleteMost helpful. Immortalized in our team's SharePoint Admin Knowledge Base. Thank you for sharing this with the community.
ReplyDeleteThank you for your appreciation :) Do let me know in case of any queries/questions, Thank you!
Deletevery valuable information! My issue has been fixed... Thanks Amol!!!
ReplyDeleteHi, Even I am not able to delete the custom lookup field in sharepoint list.
ReplyDeleteNote: I have created list through vs2010 wsp.
Please Advice..
Hi, Even I am not able to delete the custom lookup field in sharepoint list.
ReplyDeleteNote: I have created list through vs2010 wsp.
Field ID="{BC2682F3-F9C9-4D16-BCBE-D4F0A1628A3A}" Type="Lookup" Name="Name" DisplayName="Name" List="Lists/NameList" Mult="TRUE" ShowField="DocName" EnableLookup="TRUE" IsRelationship="TRUE" Overwrite="TRUE" Required="FALSE" Sealed="FALSE"
Please Advice..
Could you please try to delete that column by using SharePoint designer (SPD) 2010?
DeleteI am pretty much sure that its been possible by using SPD.
Please check and let me know the results, Thank you.
Many thanks, Amol, you saved me hours of trouble-shooting!
ReplyDeleteAwesome, Thanks for the confirmation!
Delete