Others

How to Require Approval for SharePoint Dates Within 45 Days

WPS Editor Sep 28, 2026 870 views

Question details

The user needs to route SharePoint leave or calendar requests for manager or administrator approval specifically when the requested date is within 45 days from today.

How to Require Approval for SharePoint Dates Within 45 Days

Product: Microsoft SharePoint & Power Automate
Device & OS: not provided
Scenario: Managing calendar events, time-off requests, or scheduling in SharePoint requiring conditional date-based approvals.
Observed behavior: Standard SharePoint calendars do not automatically restrict or route requests based on dynamic date calculations out of the box, requiring a custom automated solution.

Before you start

Ensure you have adequate permissions to create and manage Power Automate flows within your Microsoft 365 environment, and that your target SharePoint list or calendar is already set up with the necessary date fields.

Solution 1Recommended

Create a Power Automate Flow for Date-Based Approval

Since SharePoint does not offer this logic natively, you can build a Power Automate flow that calculates the difference between today's date and the requested date, triggering an approval process if it falls within the 45-day window.

This solution utilizes Microsoft Power Automate to intercept the creation of a new item in your SharePoint list, evaluate the dates, and route the approval automatically.

Trigger the Flow

Log in to Power Automate and create an automated cloud flow. Set the trigger to 'When an item is created or modified' and select your specific SharePoint Site Address and List Name.

Initialize the Date Variables

Add a step to get the current time using the 'utcNow()' expression. Then, calculate the 45-day threshold by using the 'addDays' expression (e.g., addDays(utcNow(), 45)) to define your cut-off date.

Add a Condition Control

Insert a 'Condition' action. Configure it to check if the requested date from your SharePoint item is less than or equal to your 45-day calculated date variable.

Configure the Approval Action

In the 'If yes' branch of the condition, add the 'Start and wait for an approval' action. Assign it to the designated administrator or manager who needs to review short-notice requests.

Update the SharePoint Item

Following the approval action, add an 'Update item' step to change the item's status in SharePoint to Approved or Rejected based on the manager's response.

Create a Power Automate Flow for Date-Based Approval

Community Support: For specific expression syntax or advanced workflow troubleshooting, the Microsoft Power Automate Community forums are highly recommended for detailed guidance.

Free Microsoft Office alternative

Enhance Your Daily Productivity with WPS Office

While SharePoint and Power Automate handle your backend approval workflows, you still need a reliable office suite for drafting request documents, analyzing leave data, and creating reports. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office, letting you seamlessly edit Word, Excel, and PowerPoint files without a subscription.

1. Download the Software: Visit the official WPS Office website and download the free installation package tailored for your operating system.
2. Install and Launch: Run the downloaded installer and follow the simple on-screen instructions to set up the suite in just a few minutes.
3. Edit Your Documents: Instantly open your exported SharePoint lists, Excel reports, or Word documents directly in WPS Office to begin editing.

Fully compatible with Microsoft Office document formats (.docx, .xlsx, .pptx) commonly stored in SharePoint.Lightweight design that runs smoothly on Windows, Mac, and Linux without heavy system requirements.Familiar user interface ensuring zero learning curve for users accustomed to Microsoft Office.Built-in PDF editing tools for managing signed approval documents easily.

microsoft office alternative - wps office

Frequently Asked Questions

Can I achieve this 45-day approval restriction using only SharePoint out-of-the-box features?

No, standard SharePoint calendars and lists do not have built-in conditional logic to trigger varying approval routes based on dynamic date calculations. Power Automate or a custom script is required.

What happens if a user submits a request for a date 50 days in the future?

If you configure your Power Automate flow condition to only trigger approvals for dates within 45 days, requests beyond 45 days will follow the 'If no' branch, where you can set it to automatically approve the item or bypass the secondary manager review.

Which Power Automate trigger should I use for a SharePoint calendar?

Use the 'When an item is created' or 'When an item is created or modified' trigger, pointing directly to the specific SharePoint Site Address and List Name where your calendar is hosted.

Office Quick Solutions