This video is demonstrates the process of using the Current User Filter web part to filter a list or library dynamically based on the Department property of whoever views the page.
Please feel free to provide feedback, comments or questions below.
Contact us via the 3grow SharePoint Training website: https://3grow.net
Or by email:
[email protected]