Power Platform Community Forum Thread Details

Description:

I need assistance in setting up a Power Automate flow to send holiday reminders to clients with the following requirements:

Database Setup:
- Holiday List: Stored in SharePoint with holiday dates.
- Client List: Stored in Excel with client details.
Reminder Timing:
- The reminder for an upcoming holiday should be sent 3 days before the holiday.
Manager Approval:
- Before sending the reminder, manager approval is required.
Business Day Reminder Logic:
- The reminder should only be sent on business days (Monday to Friday).
- If a holiday falls on Monday, the reminder should be sent on Wednesday (skipping Saturday and Sunday).
- If a holiday falls on Wednesday, the reminder should be sent on Friday, considering business days only.
- So on.
  
  Like this:
- Monday Holiday → Reminder on Wednesday (previous week).
- Tuesday Holiday → Reminder on Thursday (previous week).
- Wednesday Holiday → Reminder on Friday (previous week).
- Thursday Holiday → Reminder on Monday (same week).
- Friday Holiday → Reminder on Tuesday (same week).

I need help with the following:

Creating the logic to check the holiday date and adjust the reminder date accordingly to ensure it’s only sent on business days.
Ensuring the reminder is only sent for upcoming holidays 3 days in advance, but respecting business days.

Categories: