{"id":111024,"date":"2019-12-16T07:28:00","date_gmt":"2019-12-16T15:28:00","guid":{"rendered":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/power-automate\/work-better-with-the-common-data-service-in-power-automate\/"},"modified":"2025-06-11T08:00:52","modified_gmt":"2025-06-11T15:00:52","slug":"work-better-with-the-common-data-service-in-power-automate","status":"publish","type":"post","link":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/power-automate\/work-better-with-the-common-data-service-in-power-automate\/","title":{"rendered":"Work better with the Common Data Service in Power Automate"},"content":{"rendered":"<p>There are now a number of different features available in the <b>Common Data Service (current environment)<\/b> connector that bring automated flows closer to parity with the classic Common Data Service workflows &#8211; and in some cases, bring new functionality that was never possible with classic workflows.<\/p>\n<p>The\u00a0<strong>Common Data Service (current environment)\u00a0<\/strong>connector is available for all new flows created from the\u00a0<strong>Solutions<\/strong> tab in the left navigation in the Power Automate portal. Whenever you build a flow against CDS we strongly recommend using Solutions &#8211; as that provides you a way to group and package your flows, for example, to move them to a production environment after you&#8217;ve completed development. This connector is not available for flows built outside of Solutions.<\/p>\n<h2>Calling bound or unbound actions<\/h2>\n<p>Automated flows can now call <a href=\"https:\/\/docs.microsoft.com\/dynamics365\/customer-engagement\/web-api\/actions?view=dynamics-ce-odata-9\"><em>actions<\/em><\/a>\u00a0that are available in Common Data Service. This includes everything from fulfilling a sales order to exporting a solution. Actions represent operations that might have side effects in the database, such as creating or updating records. There are two new steps in a flow that you can use:<\/p>\n<ul>\n<li><strong>Perform an unbound action<\/strong> &#8211; Unbound actions aren\u2019t bound to an entity type and are called as static operations.<\/li>\n<li><strong>Perform a bound action<\/strong> &#8211; Bound actions target a single entity or a set of records for a single entity.<\/li>\n<\/ul>\n<header><\/header>\n<p>An action might require parameters and might return a value. You can see all of the actions that are supported, as well as their input and output parameters in <a href=\"https:\/\/docs.microsoft.com\/dynamics365\/customer-engagement\/web-api\/actions?view=dynamics-ce-odata-9\">the documentation<\/a>.<\/p>\n<h2>Working with relationships<\/h2>\n<p>Relationships are an important concept in the Common Data Service &#8211; and Power Automate allows you to work with them in a few different ways.<\/p>\n<p><strong>Updating or creating records directly with relationships<\/strong><\/p>\n<p>On the create or update of records there are fields that hold relationships. For example when you create an\u00a0<strong>Account<\/strong> there is a\u00a0<strong>Primary Contact<\/strong> field.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" height=\"313\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/relate-one-to-one.png\" width=\"616\"\/><\/p>\n<p>When you want to create or update a relationship you should use standard OData notation.\u00a0For example, while creating an account record, you should set the primary contact field to OData id of a contact record like <code>contacts(c96be312-4ac1-4358-99b6-1e14e2957b15)<\/code>.<\/p>\n<p>Note, if you try to just pass the guid from another step you&#8217;ll get an error like:\u00a0<em>Resource not found for the segment &lt;segmentname&gt;<\/em>. The Common Data Service (current environment) connector expects the full OData ID of the target record, including the type of the record.<\/p>\n<p>If the lookup field is polymorphic (meaning it can have more than one possible target types) then the target record OData ID should be provided in the right field. For example the <strong>Company name<\/strong> field for\u00a0<strong>Contacts<\/strong>\u00a0is polymorphic and can take either an <strong>Account<\/strong> or <strong>Contact<\/strong> but not both.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" height=\"616\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/relate-polymorphic.png\" width=\"612\"\/><br \/>\n<strong>Using the &#8220;Relate records&#8221; action<\/strong><\/p>\n<p>We have added support for the <a href=\"https:\/\/docs.microsoft.com\/en-us\/connectors\/commondataserviceforapps\/#relate-records\">relate<\/a> and\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/connectors\/commondataserviceforapps\/#unrelate-records\">unrelate<\/a> record actions in the <a href=\"https:\/\/docs.microsoft.com\/en-us\/connectors\/commondataserviceforapps\/\">Common Data Service (current environment)<\/a> connector. This makes it possible to associate or disassociate two CDS records whether they have one-to-many or many-to-many relationships.<\/p>\n<ol>\n<li>Like other actions in this connector, a dropdown list of supported entities will show up. Select the type of entity you want to relate to or enter your own custom value for the entity set name.<br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone wp-image-1825 size-full\" height=\"200\" src=\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/10\/Relate1-11152019.png\" width=\"603\"\/><\/li>\n<li>Enter the identifier of the record you want to relate to matching the entity type from 1 above.<br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone wp-image-1826 size-full\" height=\"226\" src=\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/10\/Relate2-11152019.png\" width=\"604\"\/><br \/>\n<em>NOTE: You can normally grab the record identifier from a previous request by using the dynamic content.<\/em><br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone wp-image-1828 size-full\" height=\"505\" src=\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/10\/Relate2-NotesNew-11152019.png\" width=\"1008\"\/><\/li>\n<li>The list of supported one-to-many and many-to-many relationships based on the entity type selected in 1 above will be populated in the format &lt;Related Entity Type&gt; &#8211; &lt;Relationship Schema Name&gt;. Select the relationship you want to relate the related entity to or enter your custom value of the relationship schema name.<br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone wp-image-1833 size-full\" height=\"204\" src=\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/10\/Relate3-New-11152019.png\" width=\"605\"\/><\/li>\n<li>Enter the full resource URL of the related entity you want to relate. This will be the full OData identifier of the resource.<br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone wp-image-1832 size-full\" height=\"249\" src=\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/10\/Relate4-New-11152019.png\" width=\"609\"\/><br \/>\n<em>NOTE: You can normally grab the OData identifier of the resource from a previous request by using the dynamic content.<\/em><br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone wp-image-1831 size-full\" height=\"462\" src=\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/10\/Relate4-Notes-11152019.png\" width=\"1005\"\/><\/li>\n<\/ol>\n<p><strong>Using the &#8220;Unrelate records&#8221; action<\/strong><\/p>\n<p>Like with relate records, this feature is available when you select the <a href=\"https:\/\/docs.microsoft.com\/en-us\/connectors\/commondataserviceforapps\/\">Common Data Service (current environment)<\/a> connector.<\/p>\n<ol>\n<li>Like other actions in this connector, a dropdown list of supported entities will show up. Select the type of entity you want to unrelate from or enter your own custom value for the entity set name.<br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone wp-image-1834 size-full\" height=\"201\" src=\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/10\/Unrelate1-11152019.png\" width=\"606\" srcset=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/10\/Unrelate1-11152019.webp 606w, https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/10\/Unrelate1-11152019-300x100.webp 300w\" sizes=\"auto, (max-width: 606px) 100vw, 606px\" \/><\/li>\n<li>Enter the identifier of the record you want to unrelate from matching the entity type from 1 above.<br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone wp-image-1835 size-full\" height=\"228\" src=\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/10\/Unrelate2-11152019.png\" width=\"605\"\/><br \/>\n<em>NOTE: You can normally grab the record identifier from a previous request by using the dynamic content.<\/em><br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone wp-image-1836 size-full\" height=\"500\" src=\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/10\/Unrelate2-Notes-11152019.png\" width=\"1008\" srcset=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/10\/Unrelate2-Notes-11152019.webp 1008w, https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/10\/Unrelate2-Notes-11152019-300x149.webp 300w, https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/10\/Unrelate2-Notes-11152019-768x381.webp 768w\" sizes=\"auto, (max-width: 1008px) 100vw, 1008px\" \/><\/li>\n<li>The list of supported one-to-many and many-to-many relationships based on the entity type selected in 1 above will be populated in the format &lt;Related Entity Type&gt; &#8211; &lt;Relationship Schema Name&gt;. Select the relationship you want to unrelate the related entity from or enter your custom value of the relationship schema name.<br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone wp-image-1837 size-full\" height=\"201\" src=\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/10\/Unrelate3-11152019.png\" width=\"604\" srcset=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/10\/Unrelate3-11152019.webp 604w, https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/10\/Unrelate3-11152019-300x100.webp 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/li>\n<li>Enter the full resource URL of the related entity you want to unrelate. This will be the full OData identifier of the resource.<br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone wp-image-1838 size-full\" height=\"251\" src=\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/10\/Unrelate4-11152019.png\" width=\"607\" srcset=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/10\/Unrelate4-11152019.webp 607w, https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/10\/Unrelate4-11152019-300x124.webp 300w\" sizes=\"auto, (max-width: 607px) 100vw, 607px\" \/><br \/>\n<em>NOTE: You can normally grab the OData identifier of the resource from a previous request by using the dynamic content.<\/em><br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone wp-image-1839 size-full\" height=\"471\" src=\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/10\/Unrelate4-Notes-11152019.png\" width=\"1006\" srcset=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/10\/Unrelate4-Notes-11152019.webp 1006w, https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/10\/Unrelate4-Notes-11152019-300x140.webp 300w, https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/10\/Unrelate4-Notes-11152019-768x360.webp 768w\" sizes=\"auto, (max-width: 1006px) 100vw, 1006px\" \/><\/li>\n<\/ol>\n<p><strong>Activity party relationships<\/strong><br \/>\n<a href=\"https:\/\/docs.microsoft.com\/dynamics365\/customer-engagement\/web-api\/activityparty\">Activity parties<\/a> are a special type of relationship in the Common Data Service, and are now supported as well. For example, when you create an\u00a0<strong>Appointment<\/strong> the Required Attendees and Optional Attendees are related to the System Users entity.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" height=\"710\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/activity-party-two-lookups.png\" width=\"586\"\/><\/p>\n<p>You can add multiple values for an activity party by selecting <strong>Add new items<\/strong> and entering data. As above &#8211; be sure to use the OData ID syntax of systemusers(&lt;ID of the user&gt;).<\/p>\n<p>You can also pass in a list of different activity parties by toggling from the item mode to the array mode (it&#8217;s the &#8220;T&#8221; button at the top-right). When you do that you can use expressions to pass in data from a previous action, for example, to send an array.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" height=\"451\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/activity-party-n-lookups.png\" width=\"619\"\/><\/p>\n<h2>Use change sets to run multiple actions at once<\/h2>\n<p>Change sets provide a way to bundle a number of operations that either succeed or fail as a group.\u00a0When multiple operations are contained in a change set, all the operations are considered <em>atomic<\/em>, which means that if any one of the operations fail, any completed operations will be rolled back.<\/p>\n<p>To get started with change sets &#8211; add the\u00a0<strong>Executes a changeset request<\/strong> scope to your flow.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" height=\"691\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/actionlist-changeset.png\" width=\"639\"\/><\/p>\n<p>You&#8217;ll notice that this is different from any other action you&#8217;ve added &#8211; instead of inputs and outputs, this is a container that you can add actions inside of. When you select\u00a0<strong>Add an action<\/strong> you&#8217;ll see just three different actions:<\/p>\n<ul>\n<li>Create a new record<\/li>\n<li>Delete a record<\/li>\n<li>Update a record<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" height=\"663\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/three-actions-changeset.png\" width=\"677\"\/><\/p>\n<p>You cannot have additional built-in actions inside of a change set scope because all actions are evaluated together inside of CDS. You will see that there are no arrows between each of the actions, indicating that there are no dependencies between these actions (they&#8217;ll all be executed at once).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" height=\"343\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/actions-inside-changeset.png\" width=\"649\"\/><\/p>\n<h2>Upload or download from image and file datatypes<\/h2>\n<p>Last week we <a href=\"https:\/\/powerapps.microsoft.com\/blog\/introducing-improvements-to-data-storage-in-common-data-services\/\">released two new field datatypes<\/a> in the Common Data Service:<\/p>\n<ul>\n<li><strong>File<\/strong> &#8211; this allows you to have an attribute that stores arbitrary file data for your entity (<a href=\"https:\/\/docs.microsoft.com\/powerapps\/developer\/common-data-service\/file-attributes\">read more here<\/a>).<\/li>\n<li><strong>Image<\/strong> &#8211; in addition to an attribute for storing the full sized image as a file, the image datatype also can include thumbnail information (<a href=\"https:\/\/docs.microsoft.com\/powerapps\/developer\/common-data-service\/image-attributes\">read more here<\/a>).<\/li>\n<\/ul>\n<p>You can work with both of these new datatypes in Power Automate when you use the\u00a0<strong>Common Data Service (current environment)<\/strong> connector.<\/p>\n<p><strong>Using &#8220;Get file or image content&#8221;<\/strong><\/p>\n<p>The <strong>Get file or image content<\/strong> action is for downloading content from corresponding file or image fields in CDS records so you can use the file content elsewhere in your flow.<\/p>\n<ol>\n<li>As with any action in this connector, a dropdown list of supported entities will show up. Select the type of entity you want to download file\/image content for or enter your own custom value for the entity set name.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" height=\"207\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Download1.png\" width=\"604\"\/><\/li>\n<li>Enter the identifier of the record you want to get the file or image content from matching the entity type from 1 above.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" height=\"212\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Download2.png\" width=\"605\"\/><br \/>\n<em><em>NOTE: You can normally grab the record identifier from a previous request by using the dynamic content.<\/em><\/em><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" height=\"398\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Download2Note.png\" width=\"1010\"\/><\/li>\n<li>The list of supported file and image fields based on the entity type selected in 1 above will be populated for selection. Select the field you want to download the content for or enter your custom value.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" height=\"209\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Download3.png\" width=\"602\"\/><\/li>\n<li>With the content output of the action you can pass it to any action as you want.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" height=\"500\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Download4.png\" width=\"1010\"\/><\/li>\n<\/ol>\n<p><strong>Using &#8220;Upload file or image content&#8221;<\/strong><\/p>\n<ol>\n<li>As with any action in this connector, a dropdown list of supported entities will show up. Select the type of entity you want to upload file\/image content to or enter your own custom value for the entity set name.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" height=\"240\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Upload1.png\" width=\"601\"\/><\/li>\n<li>Enter the identifier of the record you want to upload the file or image content to matching the entity type from 1 above.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" height=\"267\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Upload2.png\" width=\"603\"\/><br \/>\n<em>NOTE: You can normally grab the record identifier from a previous request by using the dynamic content.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" height=\"399\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Upload2Note.png\" width=\"1011\"\/><br \/>\n<\/em><\/li>\n<li>The list of supported file and image fields based on the entity type selected in 1 above will be populated for selection. Select the field you want to upload the content to or enter your custom value.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" height=\"326\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Upload3.png\" width=\"602\"\/><\/li>\n<li>Enter the content you want to upload to the record field.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" height=\"376\" src=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Upload4.png\" width=\"1010\"\/><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>There are now a number of new features available in the Common Data Service (current environment) connector that bring automated flows closer to parity with the classic Common Data Service workflows &#8211; and in some cases, bring new functionality that was never possible with classic workflows, such as working with the new image and file data types.<\/p>\n","protected":false},"author":379,"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":[3424],"job-role":[],"product":[3474],"property":[],"topic":[],"coauthors":[2948],"class_list":["post-111024","post","type-post","status-publish","format-standard","hentry","audience-it-professional","content-type-news","product-power-automate"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Work better with the Common Data Service in Power Automate - 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:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Work better with the Common Data Service in Power Automate - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"There are now a number of new features available in the Common Data Service (current environment) connector that bring automated flows closer to parity with the classic Common Data Service workflows - and in some cases, bring new functionality that was never possible with classic workflows, such as working with the new image and file data types.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/power-automate\/work-better-with-the-common-data-service-in-power-automate\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-16T15:28:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:00:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/relate-one-to-one.png\" \/>\n<meta name=\"author\" content=\"Jimmy Tu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jimmy Tu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/\"},\"author\":[{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/author\/jimmy-tu\/\",\"@type\":\"Person\",\"@name\":\"Jimmy Tu\"}],\"headline\":\"Work better with the Common Data Service in Power Automate\",\"datePublished\":\"2019-12-16T15:28:00+00:00\",\"dateModified\":\"2025-06-11T15:00:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/\"},\"wordCount\":1560,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/relate-one-to-one.png\",\"keywords\":[\"Connectors\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/\",\"url\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/\",\"name\":\"Work better with the Common Data Service in Power Automate - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/relate-one-to-one.png\",\"datePublished\":\"2019-12-16T15:28:00+00:00\",\"dateModified\":\"2025-06-11T15:00:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/#primaryimage\",\"url\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/relate-one-to-one.webp\",\"contentUrl\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/relate-one-to-one.webp\",\"width\":616,\"height\":313,\"caption\":\"graphical user interface, text, application, email\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Work better with the Common Data Service in Power Automate\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/new-cm-edgedigital.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:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/new-cm-edgedigital.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:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/person\/6ba47b5fef276d2683fb153b554491bb\",\"name\":\"Jimmy Tu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/6cdb3e3bf930fd66d3bd3cdcb7d03e983697019c379aeabd8cddfe9bfbc5f039?s=96&d=mm&r=g958aa02337230f0f05a432a439e76372\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6cdb3e3bf930fd66d3bd3cdcb7d03e983697019c379aeabd8cddfe9bfbc5f039?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6cdb3e3bf930fd66d3bd3cdcb7d03e983697019c379aeabd8cddfe9bfbc5f039?s=96&d=mm&r=g\",\"caption\":\"Jimmy Tu\"},\"url\":\"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/author\/jimmytu\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Work better with the Common Data Service in Power Automate - 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:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/","og_locale":"en_US","og_type":"article","og_title":"Work better with the Common Data Service in Power Automate - Microsoft Power Platform Blog","og_description":"There are now a number of new features available in the Common Data Service (current environment) connector that bring automated flows closer to parity with the classic Common Data Service workflows - and in some cases, bring new functionality that was never possible with classic workflows, such as working with the new image and file data types.","og_url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/power-automate\/work-better-with-the-common-data-service-in-power-automate\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2019-12-16T15:28:00+00:00","article_modified_time":"2025-06-11T15:00:52+00:00","og_image":[{"url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/relate-one-to-one.png","type":"","width":"","height":""}],"author":"Jimmy Tu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jimmy Tu","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/#article","isPartOf":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/"},"author":[{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/author\/jimmy-tu\/","@type":"Person","@name":"Jimmy Tu"}],"headline":"Work better with the Common Data Service in Power Automate","datePublished":"2019-12-16T15:28:00+00:00","dateModified":"2025-06-11T15:00:52+00:00","mainEntityOfPage":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/"},"wordCount":1560,"commentCount":0,"publisher":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/#primaryimage"},"thumbnailUrl":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/relate-one-to-one.png","keywords":["Connectors"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/","url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/","name":"Work better with the Common Data Service in Power Automate - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/#primaryimage"},"image":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/#primaryimage"},"thumbnailUrl":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/relate-one-to-one.png","datePublished":"2019-12-16T15:28:00+00:00","dateModified":"2025-06-11T15:00:52+00:00","breadcrumb":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/#primaryimage","url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/relate-one-to-one.webp","contentUrl":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/relate-one-to-one.webp","width":616,"height":313,"caption":"graphical user interface, text, application, email"},{"@type":"BreadcrumbList","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/2019\/12\/16\/work-better-with-the-common-data-service-in-power-automate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Work better with the Common Data Service in Power Automate"}]},{"@type":"WebSite","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#website","url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/new-cm-edgedigital.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:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/new-cm-edgedigital.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:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/person\/6ba47b5fef276d2683fb153b554491bb","name":"Jimmy Tu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/6cdb3e3bf930fd66d3bd3cdcb7d03e983697019c379aeabd8cddfe9bfbc5f039?s=96&d=mm&r=g958aa02337230f0f05a432a439e76372","url":"https:\/\/secure.gravatar.com\/avatar\/6cdb3e3bf930fd66d3bd3cdcb7d03e983697019c379aeabd8cddfe9bfbc5f039?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6cdb3e3bf930fd66d3bd3cdcb7d03e983697019c379aeabd8cddfe9bfbc5f039?s=96&d=mm&r=g","caption":"Jimmy Tu"},"url":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/author\/jimmytu\/"}]}},"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:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/111024","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/379"}],"replies":[{"embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=111024"}],"version-history":[{"count":1,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/111024\/revisions"}],"predecessor-version":[{"id":130716,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/111024\/revisions\/130716"}],"wp:attachment":[{"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=111024"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=111024"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=111024"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=111024"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=111024"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=111024"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=111024"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/new-cm-edgedigital.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=111024"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}