Power Platform Community Forum Thread Details

Hi Power Automate Community,

My goal is to sent a reminder email based on calendar events to the correct Business Group Approver from a separate list in SharePoint.

I want a reminder email sent out on the specific date based on an event. So on Jan 13, the Annuities, Life, and International approvers will receive reminders to complete an approval process. The next day, the SVP and VP will get reminders. The entry on the 17th should be ignored (anything not labelled with Reminder).

The people who would receive the reminders would be based on a SharePoint list. So for Annuities the email would go to Mike Smith, for Life the email would go to Mary Jane, etc.

So far, my flow is as follows.

What ends up happening here is that I get emails sent to each user for each email, so I know I need to add additional conditional logic in this section below. I tried running with this section updated to include a check to see what Category the event was listed as but that resulted in no matches and no email reminders sent.

Any help would be appreciated.

Thanks,

Hina

Categories:

Building flows

Hi @hinaahmad5 ,

Could you please share more details about your scenario? Would you like to send emails based on the time and status saved a SharePoint list?

If so, you should make sure that no event will be modified in the same day. For example, when the date time is matching, the flow scheduled to send Email to BG1 at 2 PM, but in the morning someone modified this event to BG2. So at 2 PM the flow will still send the email to BG1. So basically this is unachievable in Power Automate unless the schedule trigger could get timestamp from time column of SharePoint lists. There is already an idea in the forum so if you like it, you could vote for it:

Schedule flow based on SharePoint list Item values - Power Platform Community (microsoft.com)

Assume that you could confirm no event will be modified in the same day of the time column, there are some logical mistakes in your flow. Firstly, you should get the approvers based on each event that matches the status, so the get approver action should be under the condition. The whole approach should be like below: