Value function converted an empty text to a blank value

[JasonLane]

HI,

I have the same issue here and provide my code below that appears to be creating the issue. Does anyone have anything thoughts as i cannot fix my issue with the above idea:

 

@Bug @warning

[CarlosFigueira]

The Value function (and its similar type conversion functions: ColorValue, DateValue, DateTimeValue, TimeValue) will return a blank value if its input is blank - or if it is an empty string. I can't read your code (it's too small), so I can't tell exactly what you are trying to do.

The post at Power Fx: Experimental error handling update | Microsoft Power Apps has more details about this behavior.

[JasonLane]

@CarlosFigueira  This is the code below - Sorry for the poor screen shot - 

Search(Filter(SearchDateRange,FormID = Value(txtQAFormIDSearch.Text) Or txtQAFormIDSearch.Text="",AgentPersonNumber = cboAgentSearch.Selected.PersonNumber Or IsBlank(cboAgentSearch.Selected.PersonNumber),QualityCoachName = cboQACoachSearch.Selected.QualityCoachName Or IsBlank(cboQACoachSearch.Selected.QualityCoachName)),txtPolicyReferenceSearch.Text,"CallReference","PolicyReference")

[CarlosFigueira]

If you don't want to see that warning (I'm guessing you see it on the monitor), you can switch the order of the first condition for the Filter expression (see below). The Or operator can "short-circuit" the evaluation: if the first operand is true, then it will not evaluate the other operands, so in this case it will not call the Value function with an empty value.

Search(
    Filter(
        SearchDateRange,
        FormID = IsBlank(txtQAFormIDSearch.Text) Or Value(txtQAFormIDSearch.Text),
        AgentPersonNumber = cboAgentSearch.Selected.PersonNumber Or IsBlank(cboAgentSearch.Selected.PersonNumber),
        QualityCoachName = cboQACoachSearch.Selected.QualityCoachName Or IsBlank(cboQACoachSearch.Selected.QualityCoachName)
    ),
    txtPolicyReferenceSearch.Text,
    "CallReference",
    "PolicyReference"
)

Hope this helps!