Filtering users based on a list of email addresses

[sjlee]

I currently have a gallery where I'm showing a list of Office365 users which can be filtered based on search criteria.  I'd like to limit this list to just Office365 users whose email addresses exists in a table. 

How can I do this?

I thought about using Filter(Office365Users.SearchUser({searchTerm:SearchTerm.txt}), Formula), but I wasn't sure how to search against a list in the Formula.

Thanks in advance for any help.

[sjlee]

Luke,

Thanks for spending the time helping me troubleshoot this.  I took your advice and compared the data in the first two collections and found a discrepancy with collection1.  The view does not appear to be pulling in all the data.  I'm working with the developer who created the data pull to find out the issue, but it appears that the code in PowerApps is fine... just a data issue.