I have this formula and it works great except I need to to filter for the year 2022
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.
Go to Solution.
No, it has last years name in it that is why I need to filter it to this years name
I did it a different way and it is working now.
I changed the lookup list it was easier
LookUp(SafetyMeetingGroups_1, MeetingName = ComboBox2.Selected.MeetingName, Chairperson.DisplayName)
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!