Help with creating a Newsletter using Forms, Lists and Power Automate

(0) Share

Report

Posted on by PB-04020944-0

102

I want to be able to populate to a Newsletter in Word, receiving contributions via a Microsoft Form, the link to which I would share with the relevant contributors. How do I achieve this using Power Automate? What are the steps involved and do I need to also include a Microsoft List or eliminate that? I am looking for assistance in building the flows.

Thank you.

Peter

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Suggested answer

Kalathiya 1,971 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @PB-04020944-0,

Yes, you can automate this using Power Automate. One common approach is to create a Word document with placeholders (a template) and then map your Form responses to those placeholders. This way, each submission can automatically populate the newsletter without needing to copy and paste manually.

Word Template: Must be stored in OneDrive or SharePoint and use Content Controls for populate the value dynamically.

Automate Steps:

Trigger: When a new response is submitted (Forms)

Action: Get response details

Action: Populate a Word template > map the form fields to the template controls

Action: Save, email, or convert to PDF if required

Reference link:

For Populate Word Template:

https://community.dynamics.com/blogs/post/?postid=6d013383-a908-49ee-b91c-d72d9dad06eb

For MS Form Trigger:

https://www.youtube.com/watch?v=NpBI0o1Neqc

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No
PB-04020944-0 102 on at

Like (0)

Report
Copy link

Link copied!

@Kalathiya Thank you so, so much. I really appreciate it. Will test this out and see how it goes.

Was this reply helpful? Yes No
PB-04020944-0 102 on at

Like (0)

Report
Copy link

Link copied!

@Kalathiya Does this involve creating a MS List? I don't see that as a step in your illustration above. Also, I am not seeing an option to "Populate a Microsoft Word template" in the Actions.

Can you help?

Was this reply helpful? Yes No
Kalathiya 1,971 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @PB-04020944-0,

No, please refer to the reference below for instructions on how to create the SharePoint list.

https://support.microsoft.com/en-us/office/create-a-list-0d397414-d95f-41eb-addd-5e6eff41b083

https://www.youtube.com/watch?v=Lu74FOayqDo&t=39

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

Was this reply helpful? Yes No
PB-04020944-0 102 on at

Like (0)

Report
Copy link

Link copied!

Hello again Kalathiya . Do I even need to bother with a Sharepoint List at all, though? You don't include that in your steps above.

Was this reply helpful? Yes No
Kalathiya 1,971 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@PB-04020944-0,

Not really but you only need a SharePoint List if you want to store or track the data somewhere.

In the steps above, I was just explaining how to build the flow itself. If flow is only triggering an action for generate document, then you don’t necessarily need a SharePoint List.

If you can share your exact scenario, I can suggest whether you actually need it or not.

Was this reply helpful? Yes No
PB-04020944-0 102 on at

Like (0)

Report
Copy link

Link copied!

Hi Kalathiya

Thank you for your help so far,

Is there an alternative to getting the Microsoft Word template rather than going the Word Online (Business) route? That seems PREMIUM.

Was this reply helpful? Yes No
Kalathiya 1,971 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @PB-04020944-0,

No, the “Populate a Word template” action is available under Premium actions only.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

Was this reply helpful? Yes No
PB-04020944-0 102 on at

Like (0)

Report
Copy link

Link copied!

Just another question in this regard, where is it recommended that the Word template is stored for this purpose?

Thank you.

Was this reply helpful? Yes No