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!
17
Share
Report
All responses (
Answers (
