sharepoint 2019 server remove an invalid field

asked 2023-01-13T19:12:28.45+00:00
Phillips, Keith 601 Reputation points

I'm migrating a SharePoint 2013 site to SharePoint 2019, using the 3-phase method. After migrating the site to SP 2016, I tried to open a list and received an error:

"Field type FilteredLookupField is not installed properly. Go to the list settings page to delete this field."

When I open the settings page, there are 2 fields that have "Delete this invalid field" in the "Used by" column, but the field names are not links to edit the fields themselves.

Any ideas how I can remove or change those fields?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
5,978 questions
{count} votes

Accepted answer
  1. answered 2023-01-20T09:31:26.9833333+00:00
    Jinwei Li-MSFT 4,691 Reputation points Microsoft Employee

    Hi @Phillips, Keith,

    I'm glad to hear you solve the problem, if you have any issue about SharePoint, you are welcome to raise a ticket in this forum.

    By the way, since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others.". and according to the scenario introduced here: Answering your own questions on Microsoft Q&A, I would make a brief summary of this thread:

    [sharepoint 2019 server remove an invalid field]

    Issue Symptom:

    I'm migrating a SharePoint 2013 site to SharePoint 2019, using the 3-phase method. After migrating the site to SP 2016, I tried to open a list and received an error.

    Current status:

    The issue has been solved. Thanks for Phillips's reply and finding, the solution is:

    "

    Discovered the problem: a third-party solution for a filtered lookup column is present in our SP 2013 system, but not in SP 2019. I found the developer's GitHub page, where he has an updated version for SP 2016. That same version also works in SP 2019.

    Here's the link for anyone interested:
    [https://github.com/hasangok/sharepoint-2016-filtered-lookup-field]

    "

    You could click the "Accept Answer" button for this summary to close this thread, and this can make it easier for other community member's to see the useful information when reading this thread. Thanks for your understanding!


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


4 additional answers

Sort by: Most helpful
  1. answered 2023-01-19T12:01:39.7566667+00:00
    Phillips, Keith 601 Reputation points

    [sharepoint 2019 server remove an invalid field]

    Issue Symptom:

    I'm migrating a SharePoint 2013 site to SharePoint 2019, using the 3-phase method. After migrating the site to SP 2016, I tried to open a list and received an error.

    Current status:

    The issue has been solved.


  2. answered 2023-01-18T08:31:08.4233333+00:00
    Haoyan Xue_MSFT 4,806 Reputation points Microsoft Employee

    Hi @Phillips, Keith ,

    This might be because of the fact that your list definition contains at-least one column which is referencing any other column and it does not exist ( might be deleted by someone or miss-spelled ).

    You could go to List Settings > check all the columns which has been custom added. Then fix it or delete it.

    Besides, I found a similar case for you, he re-installed custom "Sharepoint Filtered Look up field" and it worked, maybe you can try it.

    Please refer to:[https://social.technet.microsoft.com/Forums/en-US/4e062c2e-4cb3-4563-8177-4eea1ebd69ec/error-quotfield-type-filteredlookupfield-is-not-installed-properly-go-to-the-list-settings-page?forum=sharepointadminprevious

    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    No comments

  3. answered 2023-01-16T07:54:55.2166667+00:00
    Haoyan Xue_MSFT 4,806 Reputation points Microsoft Employee

    Hi @Phillips, Keith ,

    This might be because of the fact that your list definition contains at-least one column which is referencing any other column and it does not exist ( might be deleted by someone or miss-spelled ).

    You could go to List Settings > check all the columns which has been custom added. Then fix it or delete it.

    Besides, I found a similar case for you, he re-installed custom "Sharepoint Filtered Look up field" and it worked, maybe you can try it.

    Please refer to:[https://social.technet.microsoft.com/Forums/en-US/4e062c2e-4cb3-4563-8177-4eea1ebd69ec/error-quotfield-type-filteredlookupfield-is-not-installed-properly-go-to-the-list-settings-page?forum=sharepointadminprevious

    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    No comments

  4. answered 2023-01-18T12:09:00.74+00:00
    Phillips, Keith 601 Reputation points

    Discovered the problem: a third-party solution for a filtered lookup column is present in our SP 2013 system, but not in SP 2019. I found the developer's GitHub page, where he has an updated version for SP 2016. That same version also works in SP 2019.

    Here's the link for anyone interested:
    [https://github.com/hasangok/sharepoint-2016-filtered-lookup-field]

    No comments