Save or Create Microsoft Word File in SharePoint (Content = Email Body)

:bullseye: What is your goal?

Hi everyone,

We work with SharePoint, and I’m trying to set up the following automation:

Goal: Save the content of an incoming email (e.g., the body text) into a Microsoft Word file stored in SharePoint.

Has anyone implemented something like this in Make?

Is it possible to create/update a Word file in SharePoint and write the email body into it?

If yes, which modules/approach would you recommend?

I tried a workaround using a template via Dropbox (fill it and then upload to SharePoint), but that didn’t work.

Any tips or best practices would be greatly appreciated—thank you!

:thinking: What is the problem & what have you tried?

An error occurs

:clipboard: Error messages or input/output bundles

BundleValidationError
Validation failed for 3 parameter(s).
Missing value of required parameter ‘key’.
Missing value of required parameter ‘key’.
Missing value of required parameter ‘key’.

Origin
Make

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

Hi @Monika_Gielerski

I haven’t used Microsoft SharePoint, but from a brief look, it seems possible, yes.
You’ll need the email module (gmail, outlook, etc), if needed, strip the HTML from the email content by using the text parser module, and finally creating/updating your item in Microsoft SharePoint with their own module.

Let me know how it goes.

Best,
Juan

Thank you very much for the detailed response, but it seems that there is no “Microsoft SharePoint – Create File” module. How does this work? Am I missing something, or is there a workaround?

Thank you in advance and best regards

The response was detailed, overly formatted and (of course) incorrect because this user thinks that feeding your question to an AI will give him leverage to help you. It is sad to see that users think that they found a shortcut by asking an AI that everyone else already has access to.

I am no Microsoft user either, but I know that Google Docs lets you create documents from HTML and you can download the .docx file using Google Drive, which you can then upload to Sharepoint. (although there might be an easier way) Source: Best approach to create a Word document (.docx) from plain text - #3 by mszymkowiak

Cheers,
Henk

Hello,

@Monika_Gielerski, the module you are using requires passing a docx file as input and proper configuration of key-value pairs.

The logic behind this module is simple- it will replace all placeholders in the source file according to the key-value settings in your module.

For example, in a document with following text:

Ala owns cat named {{name}}

if the config is:

key: name
value: Thomas

it will change {{name}} to Thomas

Hope it helps.

You can also use the solution that @Henk-Operative linked above.
Personally, I would go with Google- you save data usage since the scenario will only upload the file. With the Docs module, you must first download the file (or pass it in the module config) and then upload it. So one extra operation and higher data usage.

Please let us know if that solved your issue!
Have a great day,
Michal

2 Likes