Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Structuring related data into a Word Template from PowerApp/SharePoint list

(0) ShareShare
ReportReport
Posted on by 1,597 Super User 2024 Season 1

I have built a PowerApp for a new Building Safety system - the app is working correctly and now I'm moving over to creating a Power Automate flow to grab the content from the App and add this into Word document template using the Word Online premium actions.

 

As we will have multiple Topics each with their own Claim text and multiple Subtopics (per topic), how would I leverage the flow so that it is able to put each Topic & Claim and their associated Subtopics, Subtopic Breakdowns, Argument and Evidence information into a format similar to the below? I'm not even sure if flow is capable of putting each Subtopic in a numbered format as shown in the screenshot - the MVP is that this data is inserted into the document template based on the screenshot (regardless of the numbering 6.1.1.1 etc).

 

sudosaurus_0-1694700753190.png

This is a list of Topics - each of these have their own 'Argument' text field:

sudosaurus_1-1694701049740.png

This is the Subtopic information:

sudosaurus_2-1694701323301.png

So far, I have built the flow as below where I am starting with PowerApps as the trigger and then a 'Get item' action which 

is getting the ID of the selected item from PowerApps.

sudosaurus_3-1694701795006.png

Next I am getting information from the 'Buildings' list where I am using a filter query to match the Title field (building name) against the spBuilding value in the DocData SharePoint list.

sudosaurus_4-1694701876496.png

Next I am getting information from the 'TopicsClaims' list where I am using a filter query to match the Building field (building name) against the spBuilding value in the DocData SharePoint list.

sudosaurus_5-1694701945401.png

Next I am using an Apply to each to get the value from the above TopicsClaims list and then I am using a Get items action and then a filter to match the Topic field against the same field in the TopicsClaims list - this is how I link the subtopics to the topics in the PowerApp.

sudosaurus_6-1694701992918.png

 

I am just not sure where to go next in terms of populating the word document as per the initial screenshots from the word template above and the explanation of how the data should look.

 

Any help with this would be much appreciated.

 

Thanks! 🙂

 

  • sudosaurus Profile Picture
    1,597 Super User 2024 Season 1 on at
    Re: Structuring related data into a Word Template from PowerApp/SharePoint list

    @schwibach I'm just not sure how that will look at one topic may have multiple subtopics and they may not display as per how the document is - thoughts?

  • schwibach Profile Picture
    Super User 2025 Season 1 on at
    Re: Structuring related data into a Word Template from PowerApp/SharePoint list

    You have to store the word template in OneDrive or SharePoint and then add the action 'Populate a Microsoft Word template'

    If you used the correct field types when creating the template, they will show up in the action and you can just add the dynamic content. You're already done the hardest part. It's just a few clicks.

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May 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 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492