Flow ISO 8601 format Error Message

[Anonymous]

I've got a Recurring flow that updates the 'ComplianceStatus' of each item in the list. I am getting the following error message on the 'Yes' side of the 'Condition'.

InvalidTemplate. Unable to process template language expressions in action 'Set_variable_-_varDaystoRenewal' inputs at line '1' and column '12907': 'In function 'ticks', the value provided for date time string 'Self-Contained Breathing Apparatus Fit Test' was not valid. The datetime string must match ISO 8601 format.'.

Set variable - varDaystoRenewal:

DIV(sub(ticks(utcNow()), ticks(items('Apply_to_each')?['CQTitle'])), 864000000000)

Set variable - ComplianceStatus:

if(and(less(variables('varDaystoRenewal'),1095), equals(variables('varCQTitle'),'Medical')) , 'Compliant', 
if(and(less(variables('varDaystoRenewal'),720), equals(variables('varCQTitle'),'Live Fire Refresher')) , 'Compliant', 
if(and(less(variables('varDaystoRenewal'),365), equals(variables('varCQTitle'),'Self-Contained Breathing Apparatus Fit Test')) , 'Compliant', 

if(and(less(variables('varDaystoRenewal'),365), equals(variables('varCQTitle'),'Fitness Test')), 'Compliant','Noncompliant'))))

[Jcook]

Hello @Anonymous 

What is the value of CQTitle? The error message is indicating that this value is not a date/time.

[Anonymous]

Yes, you are correct. I've made the update to the expression.

I am still have the original issue, all entries in the 'ComplainceStatus' column are returning "Certified". 

If the 'DteofCQ' is not blank - and the 'CQTitle' is a Certification (per the Condition string), the 'ComplianceStatus' should default to 'Certified'; - if the 'CQTitle' is a Qualification (per the Condition string), the varDaystoRenewal and varComplianceStatus should apply:

varDaystoRenewal 

DIV(sub(ticks(utcNow()), ticks(items('Apply_to_each')?['DteofCQ'])), 864000000000)

and

varComplianceStatus

if(and(less(variables('varDaystoRenewal'),1095), equals(variables('varCQTitle'),'Medical')) , 'Compliant', if(and(less(variables('varDaystoRenewal'),720), equals(variables('varCQTitle'),'Live Fire Refresher')) , 'Compliant', if(and(less(variables('varDaystoRenewal'),365), equals(variables('varCQTitle'),'Self-Contained Breathing Apparatus Fit Test')) , 'Compliant', if(and(less(variables('varDaystoRenewal'),365), equals(variables('varCQTitle'),'Fitness Test')), 'Compliant','Noncompliant'))))

Any thoughts one why all I get is 'Certified' in the column?

  

The 'Compliance' column is the one associated with the flow. The 'ComplianceStatus' column is a calculated column within the SP list that I'd like to replace with the flow. As can be seen, the flow results are not correct.