You’re offline. This is a read only version of the page.
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
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.
Share
Report
All responses (
Answers (
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!
@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")
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.
Stay up to date on forum activity by subscribing.
#1
stampcoin
86
#2
DS-11051211-0
20
#3
MS.Ragavendar
9
