Unanswered

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

(0) Share

Report

Posted on by PB-04020944-0

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 (3)

Answers (0)

Expiscornovus 33,480 Most Valuable Professional on at

Like (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 on at

Like (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 on at

Like (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