Forum Discussion

Pavel2235's avatar
Pavel2235
Brass Contributor
Aug 18, 2023

Change value in the field at the specific time

Hi!
I've a list with colum ExpiryDate and column TriggerFlow.

When the fields in column TriggerFlow change, my Power Automate flow runs. 
So, I'd like to change value in the column fields TriggerFlow, on the specific date and time set on the column fields ExpiryDate.
Subject to date and time!
I tried to use JSON Formatting 

 

 

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=if([$ExpiryDate] != @now, 'Blank', if([$ExpiryDate] == @now, 'Expired', 'Active'))",
  "attributes": {
    "class": "=if([$ExpiryDate] != @now, 'sp-field-severity--warning', if([$ExpiryDate] == @now, 'sp-field-severity--blocked', 'sp-field-severity--good'))"
  }
}

 

 

But it doesn't work at certain times.
The values don't change in the column.
Please help me set up this process. Or maybe suggest other implementation ideas.
Thank you!

 
 

 

 

developer
SharePoint Online
Usage
  • nimesht's avatar
    nimesht
    Iron Contributor
    Aug 22, 2023

    Hi Pavel2235,

     

    I see a logical error here.

     

    The variable "@now" will contain the date as well as time (probably in seconds, or atleast in minutes), so comparing any date with this variable using "=" operator will return true only when the whole part matches.

     

    Try checking this with ">=" and "<" operators if it gives the required output.

     

    Use Like if this post helped to solve your issue and Mark as Best Response if the request can be closed.

Resources