Populate Word template from all SharePoint List Items

(0) Share

Report

Posted on by lr

Hi,
is there a way to populate a Word document template with all items from an SharePoint list?

Greetings,
Louisa

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (0)

AlanPs1 2,471 on at

Like (1)

Report

Hi @lr

In simple terms, yes.

This video will show you how to create the template - https://youtu.be/Zzm965PlYl0?t=354

Instead of using "rich text content control", use "plain text content control" for now.

The principal of populating the template from a button is the same as the list.

You just need to make the template to suit the contents of your list, format the template with tables or labels for your text to suit..

Please give it a go and post back if any issues.

If you have found my post helpful, please mark thumbs up.

If this post has solved your problem, please click "Accept as Solution".

Any other questions, just ask.

Thanks, Alan

Was this reply helpful? Yes No
AlanPs1 2,471 on at

Like (0)

Report

Hi @lr

I am just wondering if you have managed to get any further at all?

Thanks, Alan

Was this reply helpful? Yes No
lr 26 on at

Like (0)

Report

Hi @AlanPs1,
it works very fine for one item on a list. But how can i populate a template with all items from my list?
For example, this is my Sharepoint list:
Food | Ordered
-----------------
Burger | Yes
Soup | Yes
Pizza | Yes

Then I want a document that looks like this, for example:
Your orders:
Burger
Soup
Pizza
How do I configure the flow?

Was this reply helpful? Yes No
AlanPs1 2,471 on at

Like (1)

Report

Hi @lr

I would expect you will need to use an "Apply to each" so that it applies to every item in the list.

By all means post a picture of the Flow but generally the above will get all items if using "Get items".

If you have found my post helpful, please mark thumbs up.

If this post has solved your problem, please click "Accept as Solution".

Any other questions, just ask.

Thanks, Alan

Was this reply helpful? Yes No
AlanPs1 2,471 on at

Like (0)

Report

Hi @lr , I hope you are doing good.

How did you get on, did you manage to use "Apply to each" in order to access all items in the list?

If you have found my posts helpful, please mark thumbs up.

Any other questions, just ask.

Thanks, Alan

Was this reply helpful? Yes No
CU07080701-0 on at

Like (0)

Report

https://powerusers.microsoft.com/t5/Building-Flows/Populate-Word-Template-Repeating-tables/m-p/295409#M31215

Was this reply helpful? Yes No
basukunal001 66 on at

Like (0)

Report

Hi Alan,

The video is helpful. But I've a query. The action- "Populate a Microsoft Word template" is a premium action. I used this action in my PowerAutomate flow as a trial user to generate documents. May I know how long this action will work for the flow?

Thanks,
Kunal

Was this reply helpful? Yes No
Dalie 4 on at

Like (0)

Report

Hi Alan

I have a column in SharePoint that is a choice column. What would i need to do in order for the Word template to read this column as currently I get the below in the column
[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"Regulatory"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":3,"Value":"Financial"}]

Regards
Dale

Was this reply helpful? Yes No
tjanca 22 on at

Like (0)

Report

Hi, i have the same problem. did you resolve this problem, what is solution? 🙂

Was this reply helpful? Yes No
jimbarfield 6 on at

Like (0)

Report

Same problem . . . did you ever find a solution?

Was this reply helpful? Yes No