{"id":2681,"date":"2023-02-16T09:22:00","date_gmt":"2023-02-16T09:22:00","guid":{"rendered":"https:\/\/m365news.net\/?p=2681"},"modified":"2023-02-15T15:26:14","modified_gmt":"2023-02-15T15:26:14","slug":"how-to-filter-one-sharepoint-list-with-another","status":"publish","type":"post","link":"https:\/\/m365news.net\/how-to-filter-one-sharepoint-list-with-another\/","title":{"rendered":"How to Filter one SharePoint List with another"},"content":{"rendered":"\n<p>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.<\/p>\n\n\n\n<p>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.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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<\/p>\n","protected":false},"author":5,"featured_media":2682,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[134,1,148],"tags":[29],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/posts\/2681"}],"collection":[{"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/comments?post=2681"}],"version-history":[{"count":1,"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/posts\/2681\/revisions"}],"predecessor-version":[{"id":2683,"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/posts\/2681\/revisions\/2683"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/media\/2682"}],"wp:attachment":[{"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/media?parent=2681"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/categories?post=2681"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/tags?post=2681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}