Make integration: Populate a Word Template with Form Data to Dropbox not working

I have tried to carefully follow the video directions for creating a scenario in jotform where a form comes in, and enters the information to a word doc in dropbox. But I have tried multiple times and it's not working, the scenario stops every time.

• Simple log
• Advanced log

• 
  
• Jotform - Watch for Submissions1+0.7s
• The operation was completed.
• 
  
• Dropbox - Download a File2+0.6s
• The operation was completed.
• 
  
• Microsoft Word Templates - Fill out a document3
• The operation failed with an error.

• Validation failed for 3 parameter(s).
• - Invalid filename in parameter 'fileName'.
• - Collection can't be converted to text for parameter 'key'.
• - Collection can't be converted to text for parameter 'key'.

Hi Dr. Yehuda,

Thanks for reaching out to Jotform Support. Can you please share a screenshot of how you set up your Make.com scenario? We’ve got a guide here that’ll show you how to do that. I would also suggest that you change the file name of your Word document, do not include special characters if possible. Please also make sure that the merge tags in your Word document are correct. You can find the correct merge tags by checking the Field's Unique Name. Let me show you how:

1. Click on the field to highlight it then click the Gear icon.
2. Click on the Advanced tab.
   
3. Scroll down then expand the Field Details to see the Unique Name.
   

Give it a try and let us know how it goes.

Thanks, I have tried the above, and received this screen.

Here is the word document i am trying to populate.

https://www.dropbox.com/preview/CAL%20Team%20Folder/Winnie%20Chrchill%20Anon%20Report.docx?context=content_suggestions&role=work

Hi Dr. Yehuda,

Unfortunately, accessing the Word document requires a Dropbox Business account to access that file or page. Could you perhaps set the file permission to the public so that we can preview/download the file and see how to replicate the issue in Make? You can also share the file in Google Drive.

After we hear back from you, we’ll have a better idea of what’s going on and how to help.

Here is the doc in google drive

https://docs.google.com/document/d/11Pc-FG7zWBzAr4ofGUGZ6ZgX6T1azzHF/edit?usp=drive_web&ouid=111911443615566489782&rtpof=true

Thank you

Hi Dr. Yehuda,

I understand the issue, but I’ll need a bit of time to work out a solution. I’ll get back to you shortly.

Thanks for your patience, we appreciate it.

Hi Dr. Yehuda,

I tried setting up everything in my Make account following this guide, and I was able to set every module and save the whole scenario successfully. Check out the screencast below to see my results:

Can you take a screenshot of the Microsoft Word Templates module, showing the Value and Key fields as shown in the screenshot below?

As soon as we hear back from you, we can move forward with this.

Hi Dr. Yehuda,

Allow me to look into this and I will get back to you with an update as soon as possible.

Thank you for your patience.

Hi Dr. Yehuda,

When I tried replicating your set-up on Make.com, I kept getting an error as well. However, the error I was getting was "InvalidConfigurationError Unclosed tag The tag beginning with "{" is unclosed", so I checked the template and found that under the "DOB" field, the number of curly braces, didn't match:

In Make.com, I have set up my module as follows:

1. Make sure that the Key matches any of the text in your template that are enclosed with {{ and }}, in my case, I wanted to fill out the {{yourName}} portion of the template.
2. For items in the submission that has an arrow, make sure to expand them as they contain collections. For example, the Your Name data will contain the First Name and Last Name. Make sure to add both to the value.

After making the changes in the set-up, I was able to create the flow successfully:

See following screenshot of the result:

That's it. I run into some issues, can you take a screenshot of the whole configuration of your Microsoft Word Template set up that includes the upper portion?

Give it a try and let us know if you need any other help.

Thank you for your help.

I am still running into the same issue. I have screenshot the word doc I am trying to populate, as well as the scenario that is not working. I hope you can help.

Hi Dr. Yehuda,

I have checked your screenshots, and it seems that the curly bracket still not removed as suggested by my colleague Shane:

Can you go ahead and make this change and try to test again?

Give it a try and let us know how it goes.

I have changed it. However, I am still experiencing an error. Would you be able to advise?

Hi Dr. Yehuda,

The issue seems to be with the Dropbox configuration now. Have there been any changes, such as moving the folder or modifying its permissions? The error code 409 showing on the logs may be because you are connected to a different account that doesn't have access to that file/folder or because the intended file path is incorrect.

Can you please double-check and give it another try and let us know what happens? If you're still having the same issue, we'll do a more in-depth investigation and work on finding a solution.

Keep us updated and let us know if you need any more help.

Thanks for all your amazing support.

The scenario has now successfully completed the document i wanted to populate.

One last issue - the word doc has the word 'collection' before the data from the form in each entry. How can I resolve this?

Hi Dr. Yehuda,

Glad to know that you were able to successfully set up the scenario. As for your other question, I've moved that to a new thread. You can check that out here.

Let us know if there's anything else we can help you with.