Table Conditioning Formatting

[ijc999]

I have a table that used to work but it is not highlighting anymore. Any Ideas?
New-HTMLTableCondition -Name 'RefreshTokenDate' -ComparisonType 'date' -Operator lt -Value $DateDeleteCheck -BackgroundColor Red -Color Black -DateTimeFormat 'dd/MM/YYYY HH:mm:ss'

[PrzemyslawKlys]

Do you have any errors in html when you press F12?

[ijc999]

I couldnt see anything. The module I recently updated to the latest version. The script extracts disabled accounts from Azure and highlights any with a Refresh Token date older than 30 days

Dates are changed into UK format

[ijc999]

Full Panel code is
New-HTMLTab -TabName 'Disabled' -IconSolid times-circle -IconColor Red {
New-HTMLPanel {
New-HTMLTable -DataTable $AdminsDisabled -ExcludeProperty 'AccountEnabled' -ScrollX -AutoSize -HideFooter -DisablePaging -ScrollCollapse -DateTimeSortingFormat 'DD/MM/YYYY HH:mm:ss' {
New-HTMLTableHeader -BackGroundColor Blue -Color White -Title 'Disabled Azure non-Synced Accounts'
New-HTMLTableHeader -Names 'ObjectId', 'GivenName', 'Surname', 'DisplayName', 'Last Password Change', 'PasswordPolicy', 'RefreshTokenDate' , 'UserPrincipalName', 'createdDateTime', 'employeeId', 'Mail', 'AlternateMail', 'MFAEnabled', 'MFAType', 'MFAEnforced', 'Manager', 'Manager Enabled', 'Exclusion' -BackGroundColor Black -Color White
New-HTMLTableCondition -Name 'RefreshTokenDate' -ComparisonType 'date' -Operator lt -Value $DateDeleteCheck -BackgroundColor Red -Color Black -DateTimeFormat 'dd/MM/YYYY HH:mm:ss'
}
}
New-HTMLPanel -Invisible {
New-HTMLStatus {
New-HTMLStatusItem -ServiceName 'Accounts in RED' -ServiceStatus 'To Be Deleted' -Icon Bad -Percentage '0%'
}
}
}

[PrzemyslawKlys]

I mean open a browser and press F12, it should show you if you have any errors there (in console)

That would lead us to your issue

[ijc999]

There is nothing in the console. I recently updated the module from I think 1.27.0 to 1.39.0

[Chidoviskis]

I had the same problem. I thought it was related to the server, so I optimized my code. After trying many things, I checked the module version because it was working on another server, and that was the issue.

Version 1.38.0 works perfectly.

So in this case, do the following:

Uninstall-Module PSWriteHTML -Force
Install-Module PSWriteHTML -RequiredVersion 1.38.0

If you use Dashimo, you might also need to remove it and then reinstall it after installing PSWriteHTML:

Uninstall-Module Dashimo -Force
Install-Module Dashimo

This will downgrade to the stable version where table highlighting conditions work correctly.
This is a bug in the latest version; I hope they fix it in future versions.

[ijc999]

Thanks Chidoviskis .. Was on Holiday. Just tried it now and it works perfectly using the downgraded version