SharePoint Online - Document library custom column not defaulting correctly

Rajasree Nair 0 Reputation points
2023-04-10T18:08:28.5133333+00:00

I have a document library where users can post spreadsheets. I have a custom Column called "Status" which is a Choice field and has a default value of "Pending". Admins can mark the file complete after the process the file. However, in rare occasions, we are finding this status is not honored, and files get the status of "Completed" as soon as its posted. so the default value got saved as Completed. Any ideas why this is happening? this is happening very rarely (1 in a few 100 looks like) but it has happened more than thrice now. i looked through version history to confirm the file did came in as "completed". Any thoughts? User's image

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

2 answers

Sort by: Most helpful
  1. Haoyan Xue_MSFT 20,431 Reputation points Microsoft Vendor
    2023-04-11T06:09:52.8766667+00:00

    Hi @Rajasree Nair ,

    We made a test in our environment, and we could not reproduce your issue.

    This issue is relatively complicated, so let's do some troubleshooting.

    1, Switch account to see whether only you have this problem.

    2, Switch browser or use privacy mode to see whether the problem still exists.

    3, Use PowerShell script set the value and see whether the problem still exists. Run below pnp PowerShell script as admin:

    Connect-PnPOnline -Url https://domain.sharepoint.com/sites/Amy_TeamSet-PnPDefaultColumnValues -List Documents -Field "Status" -Value "pending"
    

    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.

    0 comments No comments

  2. Rajasree Nair 0 Reputation points
    2023-04-12T05:11:31.2566667+00:00

    As I mentioned, the issue happens once every 100 or so instances. I cannot reproduce it, but it has been reported by 3 different users over the course of last few months. Do you think using the column name "status" causes some issues with any reserved keywords? Any other ideas on why this happens randomly? I can look at the version history and see that the original status on these files is set to Completed. So I know its not a user error.