Use Power Apps to schedule many dynamically recurring emails to send through Flow

[JChouinard2016]

Hello,

I am creating an app for the quality team at my company. Currently, they write down errors that the warehouse pickers make and type them into an Outlook email to send to their supervisors once per week.

I have created an app where they input the errors into a form and save them to a SharePoint list. They can then create dynamic reports that can include multiple different recipients, different recurrence patterns, messages, etc. and save them to a different SharePoint list.

Currently they can pull up their saved reports and send them manually at any time, but I would like if they can automate this process by making the emails recur.

The issue I'm having is trying to create a flow that can dynamically pull each recurring report in the SharePoint list at the correct time and send them to the specified recipients. Is this possible with one Flow? If not, is it possible to create a new Flow through Power Apps every time a user creates a new recurring report?

Any help is appreciated.

[rampprakash]

Hello @JChouinard2016,

As per my knowledge the best way is when a new Report gets generated we can trigger it specific Recepitants.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

[JChouinard2016]

Hello @rampprakash 

This doesn't really answer the question I proposed. I'm wondering if it's possible to set up a variable number of recurring outlook emails using only one flow. Sometimes there may be no emails setup, sometimes only one email, sometimes many emails.

Thanks

[JChouinard2016 · Accepted solution]

Old post, but I was able to find a solution to this on my own using a combination of Power Automate, Power Apps and a SharePoint list.

Here is the concept:

If you create a SharePoint list which saves the email data in separate columns

(recipients, subject, message, etc.)

and the recurrence schedule

(I made weekly recurrence with the option to select which weekday, so there were separate text columns for Sun, Mon, Tues... with either a "Y" or an "N", "Y" meaning send on that week day;

Plus I had time split up into 3 columns: hour, minute, am/pm)

and then use the SharePoint list with a Power Automate flow

(I used five separate flows, each scheduled to run every 5 minutes, all staggered by one minute, so there is a flow running every single minute - this was due to reaching the flow run limit)

where the flow checks each row/scheduled email in the SharePoint list and if the current datetime matches the hh:mm am/pm plus weekday of the scheduled email item in the SharePoint list, it sends the email to the recipients in the "recipient" column.

I used Power Apps to create the scheduled email items for the SharePoint list by creating a custom form with checkboxes for recurrence, a message box, and date/time pickers, along with a list to edit and add new scheduled emails.