Uploading a new document of an existing document in sharepoint is it meant to keep the properties?

Question

I have a question from users in the business, when they upload a new document (an updated version of existing in SharePoint) they notice that the columns that had been previously been filled are still filled with all the old documents data.

For example Column name = approvedby, so here it will have a user's name who has approved it because it is a new document they expected that when they upload a new document it is meant to be blank columns.

The document library has a flow, where it writes in the columns who approved it. So my question is, is the behavior normal in SharePoint? Or is the flow adding the data to the newer documents?

Answer 1

This is absoultely standard behaviour. By adding a "new" document, you are not adding a new document, just a new version of the existing document, and you are only updating the content not the attributes of it. If you want to clear those values you need to write a flow to handle that.

Answer 2

This is a default behavior of SharePoint.

When you upload a new file with same name as existing file & replace the existing file, SharePoint will retain all the metadata/column values of existing file.

SharePoint will not set blank values to columns automatically after replacing existing file/document.