0

We have a requirement that the users will download excel documents from the document library and update the data in the excel documents and reupload into the SharePoint Online document library, While reuploading we don't want the metadata properties, we need to remove the metadata. For SharePoint on-premise version, we have solutions using the CSOMor PowerShell as described in the How to remove the metadata when downloading a file from SharePoint library.

But for SharePoint online, we don't have that option as per the MSDN Link.

Is there any workaround to achieve the requirement?

Any thoughts or suggestions, please.

1 Answer 1

0

This is a common problem with SharePoint due to the property promotion/demotion that affects Office and tiff files. It may result in incorrect metadata values in your SharePoint system.

I am not aware of tools with that capability at present. It is not rocket science to clear the properties embedded in Office files during downloading.

Alternatives I am not a Power Automate expert but as far as I know it can only manipulate the SharePoint metadata and not the properties within the Office files. Switching off property promotion/demotion is probably also not desired. You may end up with instructing your users to manually remove the fields until the "download and clear properties" feature becomes available.

Paul

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.