Especially when SharePoint lists need to be kept separate for security reasons, this Power Automate flow tutorial will help you keep both lists up-to-date.

So if you wanted to filter by multiple columns, you could either concatenate columns together in your Excel spreadsheet or you may have to use the earlier mentioned Filter Array action. Eq ...