Get current date in SharePoint

Lel_999987 

You are correct, approach will not provide filter functionality, was not a feature requested in the first message from you.The approach I provided using column formatting will not allow you to filter the results based on the dynamically calculated status. Column formatting is primarily for changing the visual representation of data within a column, and it does not affect the underlying data or its filtering capabilities.

If you need to filter the results based on the "not due," "overdue," or "due" status, you may need to consider alternative methods:

1. Calculated Column (with Limitations): As you mentioned earlier, calculated columns have limitations in terms of when they update. However, if the limitation is acceptable for your use case (i.e., you do not need real-time updates), you can use a calculated column to determine the status based on the "Due Date." Then, you can use SharePoint's built-in filtering capabilities on this calculated column.
2. Custom Solutions (Development): If you have access to SharePoint development capabilities, you can create a custom solution using SharePoint Framework (SPFx) or other development tools. This would allow you to implement dynamic filtering and real-time status updates based on the current date.
3. PowerApps: Since you mentioned PowerApps, it is worth exploring this option further. PowerApps can be used to create custom forms and apps for SharePoint lists and can provide dynamic filtering and calculated field capabilities. It may be possible to achieve your desired functionality using PowerApps.
4. Third-Party Tools: There are third-party SharePoint add-ins and tools available that can extend SharePoint's functionality, including filtering and dynamic status updates. Some of these tools may offer the features you need out of the box.

Ultimately, the choice of method will depend on your specific requirements, technical capabilities, and constraints within your SharePoint environment. Consider the trade-offs and limitations of each approach to determine the best fit for your needs. The text and steps were created with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark them as helpful and like it!

This will help all forum participants