SharePoint Online - Document library custom column not defaulting correctly

Question

SharePoint Online - Document library custom column not defaulting correctly

Rajasree Nair 0

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

Yanli Jiang - MSFT 31,671 Reputation points Microsoft External Staff

2023-04-11T01:32:26.9533333+00:00

Thanks for your question. We are currently looking into this issue and will give you an update as soon as possible. Thank you for your understanding and support.
Yanli Jiang - MSFT 31,671 Reputation points Microsoft External Staff

2023-04-11T01:33:24.2833333+00:00

Thanks for your question.

We are currently looking into this issue and will give you an update as soon as possible.

Thank you for your understanding and support.

2 answers

Your answer

Yanli Jiang - MSFT 31,671 Reputation points Microsoft External Staff

2023-04-11T01:32:26.9533333+00:00

Thanks for your question. We are currently looking into this issue and will give you an update as soon as possible. Thank you for your understanding and support.
Yanli Jiang - MSFT 31,671 Reputation points Microsoft External Staff

2023-04-11T01:33:24.2833333+00:00

Thanks for your question.

We are currently looking into this issue and will give you an update as soon as possible.

Thank you for your understanding and support.

Answer 1

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.

Answer 2

Rajasree Nair 0

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.

Xyza Xue_MSFT 30,241 Reputation points Microsoft External Staff

2023-04-13T08:24:55.7866667+00:00

Hi @Rajasree Nair ,

I think the issue nothing to do with the column name "status". It may caused by backend. I have no idea about this issue. You can try to use powershell to set it. If it still happen sometimes, you can create a new service request in the M365 admin center ad an admin, and more professional will help you.

(Microsoft 365 admin center ->> Support ->> New service request)

Thanks for your understanding.

Share via

SharePoint Online - Document library custom column not defaulting correctly

2 answers

Your answer