How to filter SharePoint lists dynamically
SharePoint List web part available in modern SharePoint pages is provided with a filtering option that allows you to dynamically filter the data from one list using data stored in another list.
In this article I will show you how you can take advantage of this feature with, explaining all the steps using a predefined scenario to filter the company offices based on their location.