I am attempting to prevent zero value records from being entered into my report list. I have a flow that triggers when items are created or modified and then it evaluates a JSON field for the data to be inserted into my report list. I have a condition that checks for an empty Project field and I would like to also check for the Total Hours field to make sure it does not contain any zero values. My condition currently is not working when I pass in the field name TotalHours and set it if it is equal to zero.
This is what my flow looks like:
The TotalHours field in JSON is defined to be either Null or Numeric.
I have run this JSON a few times in this configuration and it still inserts records even when they contain a Total Hours field with a zero value.

Report
All responses (
Answers (