I have a condition if Department ID (TEXT column) = 100
but it is always resulting false.
I have a condition if Department ID (TEXT column) = 100
but it is always resulting false.
You are trying to compare a text/string to a integer/number.
You need to either use the int() integer function on the value. Or put the 100 in a string() function so that it is converted to text.
See Reference Guide for Expression Functions for more details on the int() and string() functions.
int({TextDynamicContent}) is equal to 100
or
{TextDynamicContent} is equal to string(100)