Value function converted an empty text to a blank value

(0) Share

Report

Posted on by JasonLane

261

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 @Anonymous

Categories:

Error handling

I have the same question (0)

All responses (3)

Answers (0)

Sort by

CarlosFigueira Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
JasonLane 261 on at

Like (0)

Report
Copy link

Link copied!

@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")

Was this reply helpful? Yes No
CarlosFigueira Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No