Good afternoon - I unfortunately have not solved my problem.
To answer your first question - yes - I want to filter 'Core Courses' SharePoint list based on 'Core Course' and 'Electives' columns from the 'Certificate' SharePoint List.
The "Core Courses SP List" is organized out by each course, with additional details such as descriptions, audience, and duration. The "Certificates SP List" is organized by Certificate, with multiple Core Courses and Electives listed out for each certificate.
The main challenge is that some of the courses apply to one or more certificates, which is why I was trying to use a filter function and an in text function to help organize the gallery.
Additionally, the dropdown menu in the first post is a dropdown of certificates and not courses. Here is what I was trying to do but did not work:
Filter('CELA eCornell Courses', field_Course_x0020_Title in 'CELA eCornell Certificates'.'Core Courses')
Hopefully that makes sense. I have attached some more screenshots below for reference!
