{"id":1647,"date":"2019-02-07T13:55:26","date_gmt":"2019-02-07T21:55:26","guid":{"rendered":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/relate-records-in-many-to-many-relationships\/"},"modified":"2025-06-11T08:05:14","modified_gmt":"2025-06-11T15:05:14","slug":"relate-records-in-many-to-many-relationships","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/relate-records-in-many-to-many-relationships\/","title":{"rendered":"Relate records in Many-to-Many relationships"},"content":{"rendered":"<p>Canvas app authors have new tools for working with Common Data Service for Apps relationships: <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/functions\/function-relate-unrelate\"><strong>Relate<\/strong> and <strong>Unrelate<\/strong> functions<\/a>.<\/p>\n<h2>Many-to-Many relationships<\/h2>\n<p>Since December, you have been able to <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/blog\/option-sets-and-many-to-many-relationships-for-canvas-apps\/\">read Many-to-Many relationships<\/a> using the experimental and then preview CDS connector.\u00a0 But it has been impossible to relate or unrelate two records and the join table is not exposed to do it manually.\u00a0 These new functions do exactly these operations.<\/p>\n<p>Many-to-Many relationships appear as a One-to-Many table on both entities.\u00a0 For example, <em>Products<\/em> has a <strong>Contacts<\/strong> field that is a table of <em>Contacts<\/em> for each\u00a0<em>Product<\/em>, and <em>Contacts<\/em> has a <strong>Products<\/strong> field that is a table of <em>Products<\/em> for that each <em>Contact<\/em>.\u00a0 Many-to-Many relationship are symmetric.<\/p>\n<p>The first argument to these functions is the One-to-Many table that you want to add to or remove from.\u00a0 Since there can be more than one Many-to-Many relationship between two entities we need to know which one you wish to change, hence we need to know which One-to-Many relationship to manipulate.\u00a0 The second argument is the record in the other entity that you wish to add or remove.<\/p>\n<p>For example, imagine you have a Products entity with a Many-to-Many relationship to the Contacts entity.\u00a0 You might have a Gallery control with <strong>Items = Products<\/strong>, and then a second\u00a0\u00a0Gallery control with <strong>Items = Gallery1.Selected.Contacts<\/strong> to show the Contacts for a selected Product:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone size-full wp-image-1656\" height=\"527\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/02\/contacts-gallery.png\" width=\"1161\" srcset=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/02\/contacts-gallery.webp 1161w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/02\/contacts-gallery-300x136.webp 300w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/02\/contacts-gallery-1024x465.webp 1024w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/02\/contacts-gallery-768x349.webp 768w\" sizes=\"auto, (max-width: 1161px) 100vw, 1161px\" \/><\/p>\n<p>If you want to add a Contact to a Product, you ultimately want it to appear in <strong>Gallery1.Selected.Contacts<\/strong>.\u00a0 To accomplish this, you write the formula as if you were going to use the Collect function to add a record to a table, but with the Relate function instead:<\/p>\n<pre>Relate( Gallery1.Selected.Contacts, First( Contacts ) )<\/pre>\n<p>Where <strong>First( Contacts )<\/strong> is the record you&#8217;d like to add.<\/p>\n<p>You can do the reverse with the <strong>Unrelate<\/strong> function.\u00a0 This will remove <strong>First( Contacts )<\/strong> with:<\/p>\n<pre>Unrelate( Gallery1.Selected.Contacts, First( Contacts ) )<\/pre>\n<p>The <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/functions\/function-set\">documentation for <strong>Relate<\/strong> and <strong>Unrelate<\/strong><\/a> have all the details and step-by-step examples.\u00a0 \u00a0One of the examples shows relating the same contact to multiple products:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone size-full wp-image-1650\" height=\"748\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/02\/contacts-relate-unrelate.gif\" width=\"1328\"\/><\/p>\n<h2>Many-to-Many in reverse<\/h2>\n<p>Since Many-to-Many relationships are symmetric, you can also relate a Product with a Contact in the opposite direction, starting from the Contact entity:<\/p>\n<pre>Relate( First( Contacts ).Products, Gallery1.Selected )\nUnrelate( First( Contacts ).Products, Gallery1.Selected )<\/pre>\n<p>The final example is the docs is an app that relates and unrelates records in both directions and shows the results from both directions.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone size-full wp-image-1649\" height=\"748\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/02\/contacts-reverse.gif\" width=\"1328\"\/><\/p>\n<h2>One-to-Many relationships<\/h2>\n<p>These new functions can also be applied to One-to-Many relationships.\u00a0 \u00a0Since there is a foreign key field in One-to-Many relationships you can already relate and unrelate today by simply manipulating this field.\u00a0 \u00a0These functions give you another way to accomplish this.<\/p>\n<p>Imagine you have a Reservations entity that is in a One-to-Many relationship with Products.\u00a0 Just as you did above, you can use <strong>Relate<\/strong> and <strong>Unrelate<\/strong> to add and remove a Reservation from the selected Product in a Gallery control:<\/p>\n<pre>Relate( Gallery1.Selected.Reservations, First( Reservations ) )<\/pre>\n<p>which does the equivalent of:<\/p>\n<pre>Patch( Reservations, First( Reservations ), { 'Associated Product': Gallery1.Selected } )<\/pre>\n<p>And to unrelate:<\/p>\n<pre>Unrelate( Gallery1.Selected.Reservations, First( Reservations ) )<\/pre>\n<p>which does the equivalent of:<\/p>\n<pre>Patch( Reservations, First( Reservations ), { 'Associated Product': blank() } )<\/pre>\n<p>Another of the documentation examples, the app below will perform <strong>Relate<\/strong> and <strong>Unrelate<\/strong> operations on a One-to-Many relationship, showing how a Reservation can be moved from one product to another and how Reservations that are not related to a product can be managed:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone size-full wp-image-1653\" height=\"748\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/02\/reservations-lostandfound.gif\" width=\"1328\"\/><\/p>\n<h2><span style=\"font-size: 1.5rem;\">Requirements<\/span><\/h2>\n<p>This feature only works with the Common Data Service for Apps.\u00a0 The new Relational features preview switch must also be turned on (it is by default for new apps):<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone size-full wp-image-1205\" height=\"163\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/01\/2019-01-17_09h02_52c.png\" width=\"598\" srcset=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/01\/2019-01-17_09h02_52c.webp 598w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/01\/2019-01-17_09h02_52c-300x82.webp 300w\" sizes=\"auto, (max-width: 598px) 100vw, 598px\" \/><\/p>\n<h2>Feedback<\/h2>\n<p>Any and all feedback here and in the community forum is most welcome!<\/p>\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Canvas app authors have new tools for working with Common Data Service for Apps relationships: Relate and Unrelate functions. Many-to-Many relationships Since December, you have been able to read Many-to-Many relationships using the experimental and then preview CDS connector.<\/p>\n","protected":false},"author":86,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","ms-ems-related-posts":[],"footnotes":""},"audience":[3378],"content-type":[],"job-role":[],"product":[3473],"property":[],"topic":[3421],"coauthors":[2104],"class_list":["post-1647","post","type-post","status-publish","format-standard","hentry","audience-it-professional","product-power-apps","topic-application-modernization"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Relate records in Many-to-Many relationships - Microsoft Power Platform Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Relate records in Many-to-Many relationships - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Canvas app authors have new tools for working with Common Data Service for Apps relationships: Relate and Unrelate functions. Many-to-Many relationships Since December, you have been able to read Many-to-Many relationships using the experimental and then preview CDS connector.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/relate-records-in-many-to-many-relationships\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-07T21:55:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:05:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/02\/contacts-gallery.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1161\" \/>\n\t<meta property=\"og:image:height\" content=\"527\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Greg Lindhorst\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Greg Lindhorst\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/\"},\"author\":[{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/greg-lindhorst\/\",\"@type\":\"Person\",\"@name\":\"Greg Lindhorst\"}],\"headline\":\"Relate records in Many-to-Many relationships\",\"datePublished\":\"2019-02-07T21:55:26+00:00\",\"dateModified\":\"2025-06-11T15:05:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/\"},\"wordCount\":564,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/02\/contacts-gallery.png\",\"keywords\":[\"Dataverse\",\"Formulas\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/\",\"name\":\"Relate records in Many-to-Many relationships - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/02\/contacts-gallery.png\",\"datePublished\":\"2019-02-07T21:55:26+00:00\",\"dateModified\":\"2025-06-11T15:05:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/#primaryimage\",\"url\":\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/02\/contacts-gallery.png\",\"contentUrl\":\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/02\/contacts-gallery.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Relate records in Many-to-Many relationships\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/person\/dbd4cb8af4503e696f240353831f05d4\",\"name\":\"Greg Lindhorst\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/d2e26bc357423265c4eeeb6a4ed51bd71fb29b8eced3e31f4bc1ccd5bedaf80f?s=96&d=mm&r=g0133d144d5ed416197bd3b29ccd9a59c\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d2e26bc357423265c4eeeb6a4ed51bd71fb29b8eced3e31f4bc1ccd5bedaf80f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d2e26bc357423265c4eeeb6a4ed51bd71fb29b8eced3e31f4bc1ccd5bedaf80f?s=96&d=mm&r=g\",\"caption\":\"Greg Lindhorst\"},\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/gregli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Relate records in Many-to-Many relationships - Microsoft Power Platform Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/","og_locale":"en_US","og_type":"article","og_title":"Relate records in Many-to-Many relationships - Microsoft Power Platform Blog","og_description":"Canvas app authors have new tools for working with Common Data Service for Apps relationships: Relate and Unrelate functions. Many-to-Many relationships Since December, you have been able to read Many-to-Many relationships using the experimental and then preview CDS connector.","og_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/relate-records-in-many-to-many-relationships\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2019-02-07T21:55:26+00:00","article_modified_time":"2025-06-11T15:05:14+00:00","og_image":[{"width":1161,"height":527,"url":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/02\/contacts-gallery.png","type":"image\/png"}],"author":"Greg Lindhorst","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greg Lindhorst","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/#article","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/"},"author":[{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/greg-lindhorst\/","@type":"Person","@name":"Greg Lindhorst"}],"headline":"Relate records in Many-to-Many relationships","datePublished":"2019-02-07T21:55:26+00:00","dateModified":"2025-06-11T15:05:14+00:00","mainEntityOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/"},"wordCount":564,"commentCount":0,"publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/#primaryimage"},"thumbnailUrl":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/02\/contacts-gallery.png","keywords":["Dataverse","Formulas"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/","name":"Relate records in Many-to-Many relationships - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/#primaryimage"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/#primaryimage"},"thumbnailUrl":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/02\/contacts-gallery.png","datePublished":"2019-02-07T21:55:26+00:00","dateModified":"2025-06-11T15:05:14+00:00","breadcrumb":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/#primaryimage","url":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/02\/contacts-gallery.png","contentUrl":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/02\/contacts-gallery.png"},{"@type":"BreadcrumbList","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/02\/07\/relate-records-in-many-to-many-relationships\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Relate records in Many-to-Many relationships"}]},{"@type":"WebSite","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/person\/dbd4cb8af4503e696f240353831f05d4","name":"Greg Lindhorst","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d2e26bc357423265c4eeeb6a4ed51bd71fb29b8eced3e31f4bc1ccd5bedaf80f?s=96&d=mm&r=g0133d144d5ed416197bd3b29ccd9a59c","url":"https:\/\/secure.gravatar.com\/avatar\/d2e26bc357423265c4eeeb6a4ed51bd71fb29b8eced3e31f4bc1ccd5bedaf80f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d2e26bc357423265c4eeeb6a4ed51bd71fb29b8eced3e31f4bc1ccd5bedaf80f?s=96&d=mm&r=g","caption":"Greg Lindhorst"},"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/gregli\/"}]}},"bloginabox_animated_featured_image":null,"bloginabox_display_generated_audio":false,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/1647","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/86"}],"replies":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=1647"}],"version-history":[{"count":1,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/1647\/revisions"}],"predecessor-version":[{"id":130951,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/1647\/revisions\/130951"}],"wp:attachment":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=1647"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=1647"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=1647"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=1647"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=1647"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=1647"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=1647"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=1647"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}