Forum Discussion

peterdeleu72's avatar
peterdeleu72
Copper Contributor
Mar 02, 2023

Value in SharePoint list field disappears

In a SharePoint list I have a checkbox and a choice field with a lookup from another list. I create a new item and when selecting a value from the choice field and then checking the checkbox the value of the choice field is deleted. A video displaying this can be found here: https://webdevignnet-my.sharepoint.com/:v:/g/personal/peter_peterdeleu_be/EbpN1ZesRw5NnnLWa2YqgScBOu5DvHw0nDVqmQvY2LbYnw?e=lbi6OX&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZyIsInJlZmVycmFsQXBwUGxhdGZvcm0iOiJXZWIiLCJyZWZlcnJhbE1vZGUiOiJ2aWV3In19

 

The list is newly created and has no validation. Tested it with a brand new list on 2 SharePoint tenants: same problem.

 

Any ideas?

  • peterdeleu72's avatar
    peterdeleu72
    Sep 02, 2023
    Microsoft support: "As explained by my colleague, this issue was escalated to our Engineering team and a fix has been submitted to be deployed. We keep following up to get a quick traction on the next line of action."
  • jaortizgolf78's avatar
    jaortizgolf78
    Brass Contributor

     

    1. Check if there are any workflows, event receivers or custom scripts associated with the list that could be causing the issue. Disable them temporarily and check if the issue still occurs.

    2. Check if there are any validation or formatting rules configured for the choice field that could be causing the issue. Disable them temporarily and check if the issue still occurs.

    3. Check if there are any permissions or access restrictions that could be causing the issue. Ensure that the user has the necessary permissions to add and modify items in both lists.

    4. Try creating a new choice field with a lookup and a checkbox to see if the issue occurs with this new field. If the issue does not occur, there may be a problem with the original choice field.

    5. Check if the issue occurs in other browsers or devices. If the issue only occurs in a specific browser or device, there may be a problem with the browser or device.

    peterdeleu72 

    • Peter ...'s avatar
      Peter ...
      Copper Contributor

      jaortizgolf78 it's a brand new list. Nothing special, just added the fields. I can reproduce it everytime.

      Tested in Chrome and Edge 

      • peterdeleu72's avatar
        peterdeleu72
        Copper Contributor
        I see I've switched up my accounts 🙂
        But answer is still valid 🙂
  • Peter ...'s avatar
    Peter ...
    Copper Contributor
    Update from Microsoft:
    "We sincerely apologize this issue is taking this long due to the peculiar nature of the issue.
    I just received an update from our escalation team,
    Please be informed that our escalation has submitted a fix request for this behavior to our Product Group team, once. They receive an update; from the product group I would update you.

    Meanwhile they would like you to perform these workarounds.
    Click outside of the lookup column or using Tab to move to the next field, this will "lock" the value in the column and will not clear it:
    Choose a value in the lookup column.
    Tab out (click Tab) or click outside of the lookup column (instead of going immediately to change the yes/no field).
    Now change the yes/no field
    The lookup column value will not disappear."
      • peterdeleu72's avatar
        peterdeleu72
        Copper Contributor
        Microsoft support: "As explained by my colleague, this issue was escalated to our Engineering team and a fix has been submitted to be deployed. We keep following up to get a quick traction on the next line of action."

Resources