Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Populate Microsoft Word Template Action / Power Automate - Last Step :( Not Working

(2) ShareShare
ReportReport
Posted on by 9
Hello everyone.  I have a flow that in the end has an action that Populates Word Template using Word Business Premium Connector and I am about to pull my hair out.
 
1- Below is an image of my Word Document that I am using in Populate Word Template Action.  All Content Plain Text Fields & Repeating Content Fields are defined and Title & Tag fields are filled.
 
2- Repeating Controls are Projects & Timesheets as you can see below.  Timesheets is nested within Projects.
 
 
3- In Power Automate Flow, Action I map Word File Fields.  Employee Name & Week Ending Date is mapped 1 - 1.  I pass variables for EmployeeName and WeekEnding.  Those are written to the word document no issues.  However nothing else is written and no errors are triggered either.  For Projects Projects I pass JSON.  See below.
 
 
4- JSON Output that goes to Word.
 
{
    "EmployeeName": "Joe Smith",
    "WeekEnding": "2025-05-03",
    "Projects": [
        {
            "Project": "Internal Project",
            "ProjectID": "17",
            "ProjectDescription": "Overhead General",
            "Timesheets": [
                {
                    "Date": "2025-04-27",
                    "Hours": 3,
                    "Description": "Now we are looking at Sunday",
                    "Day": "Sunday",
                    "OT": "No",
                    "Billable": "No"
                },
                {
                    "Date": "2025-04-28",
                    "Hours": 3,
                    "Description": "This is Monday Hours",
                    "Day": "Monday",
                    "OT": "No",
                    "Billable": "No"
                },
                {
                    "Date": "2025-04-29",
                    "Hours": 3,
                    "Description": "Its workings",
                    "Day": "Tuesday",
                    "OT": "No",
                    "Billable": "No"
                },
                {
                    "Date": "2025-04-30",
                    "Hours": null,
                    "Description": null,
                    "Day": "Wednesday",
                    "OT": null,
                    "Billable": null
                },
                {
                    "Date": "2025-05-01",
                    "Hours": null,
                    "Description": null,
                    "Day": "Thursday",
                    "OT": null,
                    "Billable": null
                },
                {
                    "Date": "2025-05-02",
                    "Hours": 1,
                    "Description": "checking again",
                    "Day": "Friday",
                    "OT": "No",
                    "Billable": "No"
                },
                {
                    "Date": "2025-05-03",
                    "Hours": null,
                    "Description": null,
                    "Day": "Saturday",
                    "OT": null,
                    "Billable": null
                }
            ]
        },
        {
            "Project": "Strategic Initiative",
            "ProjectID": "3801",
            "ProjectDescription": "Design & Analysis - FPE",
            "Timesheets": [
                {
                    "Date": "2025-04-27",
                    "Hours": null,
                    "Description": null,
                    "Day": "Sunday",
                    "OT": null,
                    "Billable": null
                },
                {
                    "Date": "2025-04-28",
                    "Hours": 4,
                    "Description": "Monday Billable Work",
                    "Day": "Monday",
                    "OT": "No",
                    "Billable": "Yes"
                },
                {
                    "Date": "2025-04-29",
                    "Hours": null,
                    "Description": null,
                    "Day": "Tuesday",
                    "OT": null,
                    "Billable": null
                },
                {
                    "Date": "2025-04-30",
                    "Hours": null,
                    "Description": null,
                    "Day": "Wednesday",
                    "OT": null,
                    "Billable": null
                },
                {
                    "Date": "2025-05-01",
                    "Hours": 3,
                    "Description": "Thursday Billable Work",
                    "Day": "Thursday",
                    "OT": "No",
                    "Billable": "Yes"
                },
                {
                    "Date": "2025-05-02",
                    "Hours": null,
                    "Description": null,
                    "Day": "Friday",
                    "OT": null,
                    "Billable": null
                },
                {
                    "Date": "2025-05-03",
                    "Hours": null,
                    "Description": null,
                    "Day": "Saturday",
                    "OT": null,
                    "Billable": null
                }
            ]
         }
    ]
}
 
 
I cannot figure out what's causing it.  I am not an expert on Word / Connector so really hoping for the gurus/experts to help resolve this.  Thanks in advance!
 
  • stampcoin Profile Picture
    1,302 on at
    Populate Microsoft Word Template Action / Power Automate - Last Step :( Not Working
    Your word template is really confusing, especially you enabled the design mode and took screen shot.
    My suggestion is redesign your table part, each time don't add too many elements. and don't nest the timesheets in Project.
    when you make it work, you can try nest timesheet in project. ( I doubt if that will work, and that is the problem you got now).
    So, use one Repeating-Section content control first, after that consider repeating ( another story).
     

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 97

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 82 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 48 Super User 2025 Season 1

Overall leaderboard