Change value in the field at the specific time

Brass Contributor

Hi!
I've a list with colum ExpiryDate and column TriggerFlow.
Screenshot_510.png
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!

 
 

 

 

1 Reply

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.