Create recurring flows

In this unit, you'll learn how to build prescheduled flows by using a trigger called recurrence. You'll build a flow for the Contoso marketing team that automatically pulls customer email addresses from a Microsoft Excel workbook on Microsoft OneDrive. You'll then set up the flow so that, once a day, any new email addresses that were added to the workbook are added to a MailChimp customer list.

Create a scheduled flow

  1. Sign in to Microsoft Flow by using your organizational account.

  2. Select My flows.

  3. Select New, and then select Create from blank.

    Create from blank

  4. Select Search hundreds of connectors and triggers.

  5. In the search field, enter schedule, select the Schedule service, and then select the Schedule – Recurrence trigger.

  6. Set the Frequency field to Day and the Interval field to 1. Then select New step, to add an action.

    Set the frequency and interval

  7. In the search field, enter excel, select the Excel service, and then select the Excel – Get rows action.

    Note

    Be sure to select Get rows, not Get row.

  8. In the File name field, select the folder button, and then select the Excel file to use.

  9. In the Table name box, select the drop-down arrow, and then browse to and select the worksheet to use.

    Select the Excel workbook file and worksheet

  10. Select New step, and then select Add an action.

  11. In the search field, enter chimp, select the MailChimp service, and then select the MailChimp - Add member to list action.

    MailChimp - Add member to list action

    Note

    MailChimp is a premium connector. Depending on your Microsoft Flow license, you might need to sign up for a trial to use this connector.

  12. In the List Id field, select the desired MailChimp mailing list. In the Status field, select subscribed.

    Set the MailChimp mailing list and status

  13. In the Email Address field, use the dynamic content feature to add the ContactEmail field.

    Set the MailChimp address

    Notice that the flow automatically creates an additional step. Flow detects that you're setting up an action that requires an additional action. Whenever the flow reads a new email address, it will also create a new action for each row.

    Additional action added

  14. Use the dynamic content feature to fill in the First name and Last name fields.

    Set the first and last names

And there you have it!

This flow will now run once a day, get the new rows from the Excel worksheet, grab the email address and name from each row, and enter the email address and name in the Contoso MailChimp mail list, saving you both time and money.