Forum Discussion
Calculate 3 Dates in a SharePoint List
I am trying to calculate the number of days between three items. I have a Purchase Date, a Renewal Date and Todays date. The formula looks like this? =IF(OR(PurchaseDate="",RenewalDate=""),"0",(Re...
bfry2461 What you want isn't possible with a calculated column because the value is actually static and doesn't update dynamically each day. It's only updated when the item is edited. To dynamically update your DaysToRenewal column you need to use JSON column formatting.
But in your scenario you can do this in Power Automate without the need for the days to renewal and just have the email sent to you 3 days before the renewal date. To save me having to do screenshots there is a good video from Reza Dorrani which shows you how to do it at https://www.youtube.com/watch?v=v54QozIEGyw
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)