- Title
- AuthorName
- ArticleContent
- PublicationDate
- Category
- AttachmentURL
- Status (New / Approved / Published)
- PageOrder (Number — for ordering articles in newsletter)
Flow 1: Form Submission → List Population | Based on your trigger capture form's detail including attachment, update the list.
TRIGGER: Microsoft Forms — "When a new response is submitted"
ACTION 1 — Forms "Get response details"
ACTION 2 — SharePoint /MS List: "Create item" in your Microsoft List
Title → Form title response
AuthorName → Form author response
ArticleContent → Form content response
PublicationDate → Form date response
Category → Form choice response
Status → "New" (hardcoded)
ACTION 3 — Condition: Has file attachment? (Form attachment field is not empty)
YES(File is there) → ACTION 4 — Forms | Get file content from form response
ACTION 5 — SharePoint | "Add attachment" to the list item
ACTION 6 — SharePoint | Update list item AttachmentURL = file URL
If (File is not there) NO → Continue
ACTION 7 — Outlook | Send confirmation email to contributor
Email Content: "Thank you [Author], your article has been received!"
Flow 2: List → Word Template Population | This flow runs on demand or scheduled when newsletter is ready to publish:
TRIGGER: Manual trigger (or scheduled — e.g. daily/monthly)
ACTION 1 — SharePoint | "Get items" from List
Filter: Status = "Approved"
Order by: PageOrder ascending
ACTION 2 — Initialize Variable | varPageCount = 0
ACTION 3 — Apply to Each (loop through approved articles) | Start of loop
ACTION 4 — Increment Variable | varPageCount + 1
ACTION 5 — Word Online (Business) | "Populate a Microsoft Word template"
Map content controls:
ArticleTitle → items()?['Title']
ArticleAuthor → items()?['AuthorName']
ArticleContent → items()?['ArticleContent']
ArticleDate → items()?['PublicationDate']
PageNumber → variables('varPageCount')
ACTION 6 — SharePoint | "Create file" — save populated Word doc
Name: concat(items()?['Title'], '_Page', variables('varPageCount'), '.docx')
End Loop //-- End of Apply to each loop
ACTION 7 — Word Online (Business) | Merge all individual Word docs into final newsletter
ACTION 8 — SharePoint / OneDrive | Save final newsletter document
ACTION 9 — Outlook | Send newsletter to distribution list as attachment
Handling Multiple Articles — One Page Per Article | This is the most critical part of your question. Here are your options:
There are multiple approache to make complete article page with pros and cons, let's see which one fits for your case:
Approach-1: Separate Word doc per article then merge | How: Loop → populate template → save each → merge | Pros: Clean, each article isolated | Cons : Merging docs in PA is tricky
Approach-2: Single template with page break content control | How: One template, loop adds page break between sections | Pros: Simpler fow | Cons: Template design is compex.
Approache-3: Convert each to PDF then merge | How: Loop → Word → PDF → merge PDFs | Pros: Professional output | Cons: Needs PDF merge action
Please let me know if these steps help.
I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!
