Filter Lookup

[Dorinda]

I have this formula and it works great except I need to to filter for the year 2022

If(IsEmpty(ComboBox2.Selected.Title), 
    Blank(), 
    LookUp(ChairSurvey_1, 'Meeting Group'= ComboBox2.Selected.MeetingName , ChairPerson.DisplayName )
)

 I tried to add && 'Service Year'=2022 but that didnt work and I am not sure how to get this to work.

[fatjosh35]

Did you try adding ".Value" after service year:

&& 'Service Year'.Value = 2022

What data type is the Service Year field?

[Dorinda]

Yes and it gave me "False" as the return value not a name I was expecting.

[fatjosh35]

Is service year a date field? a text field? or a number field?

[Dorinda]

Text

[fatjosh35]

Try wrapping 2022 in double quotes then. 

&& 'Service Year' = "2022"

Otherwise it would give you that false value since it's trying to compare a string (or text) to a number, which doesnt work.

[Dorinda]

Yeah tried that and still got the false

If(IsEmpty(ComboBox2.Selected.Title), 
    Blank(), 
    LookUp(ChairSurvey_1, 'Meeting Group'= ComboBox2.Selected.MeetingName , ChairPerson.DisplayName && 'Service Year' = "2022"
))

[fatjosh35]

Try moving it into the second parameter of the LookUp() function. That's where the filter logic goes.

If(IsEmpty(ComboBox2.Selected.Title), 
    Blank(), 
    LookUp(ChairSurvey_1, 'Meeting Group'= ComboBox2.Selected.MeetingName && 'Service Year' = "2022", ChairPerson.DisplayName
))

[Dorinda]

Now I just get a "Blank" as the response.

[fatjosh35]

Is ComboBox2 empty?