✅ Resolved! Microsoft Word Templates - Cannot insert a newline? Here is a workaround!

[Andr]

Hello guys!

Today I got stuck while working on what seemed like a simple scenario.
In my scenario, I listed Monday.com tables with deadlines, then filtered only those that occur within the next month.
After that, I decided to save the results using a Text Aggregator and Set Variable.
There was just one step left: save the result to a .docx file and upload it to OneDrive.

The difficulty is that I never know how much results/newlines I will get. I might get 1 or 15000.

On the first run, I noticed that all the text appeared as a single line — with no line breaks at all.
Neither {{newline}} nor <br> nor \n worked.
I couldn’t believe such a simple task would take me hours… but then I started to search and read:

Add new line to Microsoft word templates

hello I have a text From Make: text1 {newline} text2 Result: text1 text2 Expected output on Microsoft word: text1 text2

and read:

Line breaks and paragraphs in Microsoft Word Template

Hello there, I want to add text paragraphs with line breaks in the microsoft word template module. In the help doc for word templates it says: “The Microsoft Word Templates app accepts only single-line plain text for replacement values. When adding line breaks, they will be viewed as spaces and won’t affect the formatting of the text.” (https://www.make.com/en/help/app/microsoft-word-templates) Is there any workaround or way to still get in text paragraphs with line breaks? I desperately need …

and read:

Word template module - Carriage Return/New Line in a form field

This process works in Google Docs Template, but I cannot use it as i only have a gmail account and the Google Drive module doesn’t work with just a gmail account. I am using the MS Word Template module and for the most part, it is doing what I want it to, with the exception of a carriage return (new line/line feed) issue I just cannot seem to get past. I have a .docx file that is a #10 envelope. I am trying to put Address1, Address2 (if it exists), city, state and zip into a field. In airtab…

and read again:

Add new line to Microsoft word templates

hello I have a text From Make: text1 {newline} text2 Result: text1 text2 Expected output on Microsoft word: text1 text2

and again:

Text with line feed to Word document

Hello, I would like to transfer a text block with line feed to Word. Source: [ { “Address”: “Martin Sample\nTree avenue \n12345 Newton” } ] “value”: “Martin Sample\nTree avenue \n12345 Newton”, Word document {{address}} Results Martin Sample Tree avenue 12345 Newton How can I turn the string “\n” into a line feed in Word? I am grateful for any help. Best regards, Helmut Translated with DeepL Translate: The world's most accurate translator (free version)

It was a disaster. The simplest operation ruined the whole scenario (and my life for today)! “Thanks” Microsoft for such a bug (read - “feature”).

SOLUTION:
Hours of reading and experimenting turned me to this:

Lets take a deeper look in each module:

1. Get multiple variables + Iterator
   
   
2. Iterator + Array Aggregator + Create JSON
   
   
3. Create JSON
   
   
   
   
   
   
   
   
   
   
   
   
   
   
4. OneDrive Download File + Microsoft word templates (Fill a document with batch of data)
   
   
5. Your Template Example.docx file should look EXACTLY like this:
   
   
6. That`s it! Try it!

P.S.: much thanks to the following users who assisted much: Mark_Poulton, Donald_Mitchell