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.

[Dorinda]

No, it has last years name in it that is why I need to filter it to this years name

[Dorinda · Accepted solution]

I did it a different way and it is working now.

I changed the lookup list it was easier

If(IsEmpty(ComboBox2.Selected.Title), 
    Blank(), 
    LookUp(SafetyMeetingGroups_1, MeetingName = ComboBox2.Selected.MeetingName, Chairperson.DisplayName) 
)