Archiving newsletters with Power Automate (Flow)

This tutorial explains how you can configure Power Automate (previously Microsoft Flow) to automatically export JungleMail for Office 365 newsletters into SharePoint Online lists to create a newsletter archive.

Configuration

1. Configure Power Automate integration with JungleMail for Office 365.

2. Create a SharePoint list for your newsletter archive, containing columns that you want to include newsletter data. We recommend to include the columns from the picture below to start with. You will always be able to add more columns later.

Important: make sure that the column in which you want to display the newsletter content has the enhanced rich text option selected.

3. Sign in to your Power Automate account, then click Create and select the Automated flow type.

4. Under Flow name, give your flow a title. Under Choose your flow's trigger, enter the full or partial name of your JungleMail for Office 365 custom connector.

5. Select When newsletter is submitted as the trigger and click Create.

6. Add Get newsletter details as an action from JungleMail for Office 365. Use dynamic content to insert Newsletter ID.

7. Add Create a SharePoint item as an action from JungleMail for Office 365. Provide the Site address, list name and use dynamic content to automatically fill in the columns.

The full flow will look like this:

8. In JungleMail for Office 365, go to Settings > Other, then go to the Triggers section. Select Enable newsletter submitted trigger, then select the trigger you've created in step 3.

Now, when a newsletter is sent, Power Automate will automatically create a record in SharePoint.

Tip: switch to classic experience to view the full email content in the Newsletter Content column.