Storing emails(Drag and drop) in sharepoint online site

Question

Storing emails(Drag and drop) in sharepoint online site

Saurabh Singh 26

We can see email information but we have to click individually to check. Is there possibility to check without opening it. We would like to see information - Prefrences - from,subject,date, to address to identify email.

We have to Click individually to get email information.

1 answer

Your answer

Answer 1

Paul de Jong 806

OOTB this is not possible. Uploading emails via drag and drop results in an msg file where the name is based on the subject. A sequence number like (2) is added when the file already exists. Email metadata is not extracted apart from the subject that is used to compose the name.

If you want to store email metadata (Subject, From, To, Sent date, presence of attachments, ...) in SharePoint columns you will need to use 3rd party apps. Most apps are add-ins for Outlook (list) but there are also SharePoint apps that are browser-based (example). Uploading an email via drag and drop into the standard SharePoint modern view will then trigger the metadata extraction. Fully transparent for the user.

The extracted email metadata allow for filtering, sorting and searching. By configuring managed properties users can use the same syntax as in Outlook: from:microsoft subject:sharepoint

Saurabh Singh 26 Reputation points

2022-08-25T17:04:52.363+00:00

Is that paid or free 3rd party addins? :)
Paul de Jong 806 Reputation points

2022-08-26T06:43:10.24+00:00

As far as I know there are no free addins offering this functionality.

There is quite some price difference between the various vendors. Find the best solution by not only taking into account your requirements but also include the price and deployment/supportability effort.
Saurabh Singh 26 Reputation points

2022-08-26T12:28:45.517+00:00

just for clarification per one of their forums below why is it not possible to install harmon.ie on the SharePoint Server? Is it because this solution is not valid for SPO and applicable to SharePoint 2010/13 etc?

https://harmon.ie/
Paul de Jong 806 Reputation points

2022-08-26T15:08:03.927+00:00
Correct. This cannot be used for SharePoint Online.
If a user uploads an email there are the following options:

Use Outlook add-ins

Use SharePoint apps that work in the browser

Develop a solution using Power Automate that is triggered when an email is added. I have not seen working implementations yet. Note: parsing msg emails is tricky (been there) because it is a binary file format. e.g. https://interoperability.blob.core.windows.net/files/MS-OXMSG/%5bMS-OXMSG%5d-210817.pdf

Use a stand alone system (within your own company's network) that extracts email metadata from emails in SharePoint (uploaded via any means: browser, OneDrive, mobiel apps, applications, ...) and captures the values into SharePoint columns (example https://www.slimapplications.com/product/bulkmetadatamanager/). The tool can be scheduled to run every hour, day or week.
Renjie Sun-MSFT 2,861 Reputation points Microsoft Employee

2022-08-30T09:49:25.99+00:00

Hi @Saurabh Singh ,

I’m checking how the things are going on about this issue. Whether the answer helps you?
If there is any problem with this issue, feel free to let me know.

Share via

Storing emails(Drag and drop) in sharepoint online site

1 answer

Your answer