Power Platform Community Forum Thread Details

Power Automate Flow for Sending Holiday Reminders on Business Days with Manager Approval

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.

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:

Quick Links

Leaderboard