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

(0) Share

Report

Posted on by PB-04020944-0

142

Hope someone can please advise or assist me. I am looking to collate emails and Word documents into a Newsletter and it is my understanding that this can be achieved using Microsoft Forms, Microsoft Lists and through Power Automate to produce the result. I am just unsure of the order this

comes in so that it all comes together and which flows/triggers are involved. Is the process to create the Form first, then the List and then to use the Power app to generate the final document (i.e, Newsletter). Can a blank template also be used in the process? Thanks, everyone.

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (0)

Sort by

Expiscornovus 33,891 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @PB-04020944-0,

Can you share what you want to use from the emails and word documents? Is it part of the text or does it also include images?

Can you share (redacted) examples of these emails and word documents so we can get an idea of the structure of the content you want to use? And what would be the design of the newsletter itself?

And what is the trigger of the process? Do you want to sent the newsletter once a month? (like a schedule).

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

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

Like
a
(0)

Report
Copy link

Link copied!

Expiscornovus

Many thanks indeed for your response. Sincerely appreciated.

This would be for the collating a responses into one mailbox, arriving from various sources. Each person would contribute something in the form of an email. The idea I have in mind is to create a Microsoft Form in the first instance (and invite everyone to add their content to this). The sections in the Form I have in mind are:-

1- Project Title

2- Project Content

3- Images related to Project (if applicable)

4- Project Contributor

Then to replicate these for Microsoft List, which, as I understand it, is next in the process. How would I link these to work?

The final step would be for PowerAutomate to generate a Newsletter into a template which each contribution as it comes in and then to ultimately run it so that the Newsletter in its entirety would be populated into a set Template in Word.

Is this achievable?

Thanks

Peter

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

Like
a
(0)

Report
Copy link

Link copied!

Hello again Expiscornovus

I have now created my Microsoft Form and List for this purpose. What is the next step, please?

Thank you.

Was this reply helpful? Yes No
Suggested answer

Heather_itD Community Manager on at

Like
a
(0)

Report
Copy link

Link copied!

@Expiscornovus - Just incase you missed this, @PB-04020944-0 is asking for next steps. Thank you!

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

Like
a
(0)

Report
Copy link

Link copied!

Hello Expiscornovus or anyone else who can please assist.

The Form, the List and the Word Template are in place for this purpose now. I just need to establish the steps in the Power Automate process if someone could please advise me of rhose.

Thank you kindly.

Was this reply helpful? Yes No
Haque 3,653 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Heather_itD

A draft guideline has been proivided in this thread.

Was this reply helpful? Yes No
Suggested answer

Expiscornovus 33,891 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PB-04020944-0 & @Heather_itD,

Apologies for the delayed response, I totally missed these mentions.

I would create two separate flows. One trigger based to create the newsletter items in the list. And a second scheduled flow to collect the items for the newsletter and populate a Word template with a repeating section control.

Below are two example flows, if that helps?

1. Collect the form responses in a List

2. Schedule the creation of a newsletter (docx). Based on the items create within the last week (the flow is schedule once a week).

a. The Get Items action uses a filter query

Created gt '@{addDays(utcNow(), -7)}'

b. A Select action is used to prepare the data for the Repeating Section Control.

c. The create file uses an expression to create the 'unique' name for the newsletter file

Newsletter @{utcNow('dd MMMM')}.docx

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

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

Like
a
(0)

Report
Copy link

Link copied!

Thank you kindly, Expiscornovus and no apology necessary. I will attempt this and let you know how I get on. :)

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

Like
a
(0)

Report
Copy link

Link copied!

Hello again Expiscornovus

Can you please advise as to the final step? I am unsure what I am putting in. Thanks.

Was this reply helpful? Yes No
Expiscornovus 33,891 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PB-04020944-0,

You can use the All Items view (which is the default view of the list), that is fine for your setup.

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No