Answered

Create a file with a word template

(1) Share

Report

Posted on by Community Power Pla...

Hi all,

I would like to create a flow : when an item is created in a list, create a file in a Sharepoint Library with the items from the list. The file is actually a word template document (a custom content type). The problem is that the word document say error when I want to open it.

Could you help me ? Do you have another solution ?

Thank you,

Martin

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (1)

PieterVeenstra on at

Like (0)

Report

It is easier to create a document by getting the content using a Get file content action.
This now gives you Word (or whatever format the tmeplate file is that is referenced in the identfier) formatted file content.

Then using the Create File action you can create a fiel wherever you like.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks for your help.
Unfortunately, the Word error is the same

Was this reply helpful? Yes No
PieterVeenstra 13 on at

Like (0)

Report

Hi Martin,

Are you able to open the document that you are using as a source within Office Online without the error message appearing?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Yes, and when I create a new document in the library it opens correctly. If I fill in the item properties manually the Word Document accepts the fields.

I modified the File identifier (I don't really know what I'm doing but I try to find a solution). If I chose my template document for the file identifier, it opens correctly in the library but the list fiels aren't copied.

Was this reply helpful? Yes No
PieterVeenstra on at

Like (0)

Report

You document lives in the Forms/Content type folder.

Can you try moving your template document into the document library itself and then copy it from there.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I added a "Update File Properties" action and the fields from the list are now copied.

I moved the template into the document library itself : the document created is a copy of the template but doesn't take the item fields in consideration. Even if I do it manually.

Was this reply helpful? Yes No
PieterVeenstra 13 on at

Like (0)

Report

Hi @Anonymous,

That sounds like a content type issue to me.

Does the ocntent type where you copy the document from match the content type where you copy it to? Are the fields identical in both librasries ( i.e. are you using site collection columns?)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks for your answers.

I finally did it thanks to SharePoint Designer.
I followed this article : https://sharepointlibrarian.com/2016/09/30/sp-workflow-to-create-a-document/

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (0)

Report
Hi @Anonymous,

Within the "Create file" action within your flow, the File Content field is required to fill an binary data, but you filled a String within it.

More details about the "Create file" action of SharePoint list, please check the following article:

Create file action

I have made a test on my side and please take a try with the following workaround:

Add a "When an item is created" trigger, specify Site Address and List Name.

Add a "Compose" action, Inputs set to following json data:

Add a "Create HTML table" action, From set to following formula:

array(outputs('Compose'))

Add a "Create file" action, File Content field set to output of "Create HTML table" action, File Name field set to following formula:

First Name Dynamic content Last Name Dynamic content .doc

Note: File Name ends with .doc rather than .docx within File Name field of "Create file" action.

Image reference:

The flow works successfully as below:

The created file opened successfully in my SharePoint library as below:

Best regards,

Kris

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you !! It works

Was this reply helpful? Yes No