How to FILTER one SharePoint List with another?

In this video, I will show you how to filter a SharePoint List by another SharePoint List. In this showcase, we have one #sharepointonline list with some schools listed and another with some teachers and their school IDs. With the help of a #powerautomate #flow we will get all the items from the first list (Schools) and save them in an array variable. Then we will grab all items from the second list (Teachers) with their SchoolID column = ID from the School list.

This way we end up with two array variables containing the IDs from the first table and the matching from the second, having prepared a left join. The next step would be to create a new list with merged IDs. Since the viewer asked how to filter with Power Automate, the creation of a new list and writing the merged data is not part of the video.

If you want to learn more about Power Automate in cooperation with SharePoint, you are welcome to follow the channel and subscribe to the playlist here: https://www.youtube.com/channel/UCPjs69d9ahFE0P-edf5chYQ

Feel Free to follow me on other social media platforms as well:
https://linktr.ee/EneaLicaj