Power Platform Community Forum Thread Details

Hi everyone,

I am a beginner in Power Automate. I am trying to build a flow to control the terms of the current contracts. Each contract has its own term. In order to automate that flow, I created a list in Sharepoint with three different collumns.

Term (Date Collumn): it contains the term of the contract
Current Date (Calculated Collumn): it contains the current date. I used the formula =today()
Days Until Due Date (Calculated Collumn): I used the formula DATADIF([Term];[Current Date];"D")+1

The problem is: the collumn Current Date is not updating, automatically, every day in my list. What it does is when I add a new item in the list, it considers the current day. But in the next day, it is not updating.

So, how can i fix that?

Thank you.

Categories:

Building flows

The reason your calculated column is not automatically updating daily is due to how SharePoint calculated columns work. Your Current Date column, only updates when an item is added, updated, or when the list itself is modified. The calculated column doesn't refresh on its own each day because SharePoint doesn't trigger updates or recalculate columns on a daily schedule.

You might be interested in some of these tutorials linked below:

How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks

Are you easily stumped when working with Dates in Power Automate? In this Power Automate tutorial, I’ll show you how to compose an expression that will return a future date, a past date, how to count the number of days between two dates, how to check for a birthdate and anniversary date as well as tips and tricks when working with dates in Power Automate. I’ll cover some common use cases and concepts that can help you to build better Power Automate flows.

Feel free to skip ahead using the timestamps listed below. I’ve also linked a few other tutorials that you might be interested in as well.

IN THIS VIDEO:
✓ 4 Date Functions You Need to Know
✓ How to use the Convert Time Zone Action
✓ How to Get a Future Date
✓ How to Get a Past Date
✓ How to Return SharePoint Items Due in a Number of Days
✓ How to Return SharePoint Items Due within a Date Range
✓ How to write a Filter Query for SharePoint Items Due in 30, 60 and 90 Days
✓ How to Calculate the Number of Days between Two Dates
✓ How to Check for a Birthdate and Anniversary Date
✓ How to work with Dates and Times in Excel
✓ How to use a Manual Trigger with Date Input
✓ How to Output Dynamic Text with an Expression
✓ How to Check if a Date Falls on a Weekend

Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate
In this Microsoft Power Automate tutorial, I’ll show you how to build a flow that will send a Happy Birthday email to a user based on a date column in a SharePoint list. The SharePoint list also contains a column with a Manager’s name which we’ll use to send a three-day and day of reminder to the user’s manager.
This automation will use the Filter Array action to filter out all SharePoint list items where the user’s birthday is today or in three days. This flow can apply to a variety of scenarios such as:

📅 Student Birthdays
📅 Project Due Dates
📅 Contract/Membership Renewals
📅 License Expirations
📅 Client Anniversaries
---
IN THIS VIDEO:
✓ How to Send an Email based on a Date Column in SharePoint
✓ Using the Recurrence Trigger in Power Automate
✓How to Use the Filter Array Action with multiple conditions
✓ How to Get Dynamic Content from a Filter Array Action
✓ How to Get a Date Three Days from Today
✓ How to Create a Dynamic Date Based on utcNow()
✓ How to Return a Count of Items
✓ How to initialize and set a variable
✓ How to use the Send an Email (V2) action
✓ How to send test emails

Hope this helps!