Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Populate Word template from all SharePoint List Items

(0) ShareShare
ReportReport
Posted on by 26

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

Greetings, 
Louisa

  • Dalie Profile Picture
    4 on at
    Re: Populate Word template from all SharePoint List Items

    Hi

     

    So I found that if I looked for the column name in the list it brought through 2 or 3 with the same name but you select the one that is your column + value. If your column allows multiple selections you need to initialize an array variable and then append to the array with the column + value option and it should automatically create apply to each. When you populate a word template you need to make sure that if it's a multiple selection column that the item in the document is a recurring line item else if it's single selection it's a normal text item

  • jimbarfield Profile Picture
    6 on at
    Re: Populate Word template from all SharePoint List Items

    Dalie

    I have the same problem, did you ever find a solution?

  • jimbarfield Profile Picture
    6 on at
    Re: Populate Word template from all SharePoint List Items

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

  • tjanca Profile Picture
    22 on at
    Re: Populate Word template from all SharePoint List Items

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

  • Dalie Profile Picture
    4 on at
    Re: Populate Word template from all SharePoint List Items

    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

  • basukunal001 Profile Picture
    66 on at
    Re: Populate Word template from all SharePoint List Items

     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

  • CU07080701-0 Profile Picture
    on at
  • AlanPs1 Profile Picture
    2,471 on at
    Re: Populate Word template from all SharePoint List Items

    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

  • AlanPs1 Profile Picture
    2,471 on at
    Re: Populate Word template from all SharePoint List Items

    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

  • lr Profile Picture
    26 on at
    Re: Populate Word template from all SharePoint List Items

    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1