{"id":110732,"date":"2016-08-08T08:00:10","date_gmt":"2016-08-08T15:00:10","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/"},"modified":"2016-08-08T08:00:10","modified_gmt":"2016-08-08T15:00:10","slug":"flow-and-common-data-model","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/","title":{"rendered":"Microsoft Flow and the Microsoft Common Data Model"},"content":{"rendered":"<p>Today we are excited to announce the public preview of the Microsoft Common Data Model integrated in Microsoft Flow. Your flows can already connect to over 40 different services, but sometimes you want to capture new data that you&#8217;re not already storing somewhere, or, you have a process that needs to store some information independent of the data sources it is using.<\/p>\n<p>The Microsoft Common Data Model is an out-of-box business database for storing and managing business entities. The preview is available today as a first class business database for your flows, with more features rolled out incrementally. Today it provides not only standard entities, but also allows you to build custom entities either extending standard entities or adding new entities that can relate to standard entities. With the Common Data Model, enterprises can improve operational efficiency with a unified view of business data. For example, the Common Data Model is also integrated directly into Microsoft PowerApps, and PowerApps makes it easy to build views and applications on top of the data that you put in with Microsoft Flow.<\/p>\n<p><img decoding=\"async\" alt=\"Common Data Model\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/cdmcolored.png\" style=\"width: 400px; height: 499px;\"\/><\/p>\n<p>You can <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/blog\/announcing-powerapps-common-data-model\/\">learn more about the Common Data Model here<\/a>. To get an idea of how to start with the Common Data Model, you can see <a href=\"https:\/\/flow.microsoft.com\/en-us\/search\/?q=Common+Data+Model\">the list of templates that we have out of box here<\/a>. Below are two ways you can use the Common Data Model. In addition to these, you can build your own flow from scratch that leverages the Common Data Model.<\/p>\n<h3>Use the Common Data Model to collect data<\/h3>\n<p>If you want to collect data about your company, such as social media posts, the Common Data Model is a resilient place to store it. For example, you can store everything from Tweets to RSS news items.<\/p>\n<p>Some of the templates can be used to import and export data from other common services. For example, you can import data from:<\/p>\n<ul>\n<li>Microsoft Dynamics CRM<\/li>\n<li>Salesforce.com<\/li>\n<li>Microsoft Excel files stored in any cloud file provider<\/li>\n<li>A Microsoft SQL database, both in the cloud and on-premises<\/li>\n<li>A custom API that you define to connect to your own systems<\/li>\n<\/ul>\n<p>This can be very useful if you are building PowerApps on top the Common Data Model and need a way to get data in. <a href=\"https:\/\/flow.microsoft.com\/en-us\/documentation\/common-data-model-intro\/\">See this article to learn more about importing and exporting data.<\/a><\/p>\n<h3>Use the Common Data Model to build approvals<\/h3>\n<p>Approvals need a place to store the history and status of the pending approvals. You can use the Common Data Model to store this type of information. Although flow has built-in Send Approval Email actions, and, SharePoint has native approvals, if you are not currently a customer of Office 365 you&#8217;ll need somewhere else to store that information. A simple approval process over new files added to your OneDrive or Dropbox works like this:<\/p>\n<ol>\n<li><a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/data-platform-create-entity\/\">Create the Approval entity<\/a> in the Common Data Model<\/li>\n<li>Create a flow that, when a file is added (or any other event that you want), creates an object in the approval entity, and <em>waits until that object no longer has a Pending status<\/em><\/li>\n<li><a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/data-platform-create-app\/\">Create a PowerApp<\/a> that the approver can use to update the status of the entity to be approved or rejected<\/li>\n<\/ol>\n<p>Check out <a href=\"https:\/\/flow.microsoft.com\/en-us\/documentation\/common-data-model-intro\/\">this article for a full walkthough of building an approval process on top of the Common Data Model<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today we are excited to announce the public preview of the Microsoft Common Data Model integrated in Microsoft Flow. The Microsoft Common Data Model is an out-of-box business database for storing and managing business entities. The preview is available today as a first class business database for your flows.<\/p>\n","protected":false},"author":347,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","power-automate-category":[2752],"power-automate-tag":[],"coauthors":[2913],"class_list":["post-110732","power-automate","type-power-automate","status-publish","hentry","power-automate-category-product-updates"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Microsoft Flow and the Microsoft Common Data Model - 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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Flow and the Microsoft Common Data Model - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Today we are excited to announce the public preview of the Microsoft Common Data Model integrated in Microsoft Flow. The Microsoft Common Data Model is an out-of-box business database for storing and managing business entities. The preview is available today as a first class business database for your flows.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/cdmcolored.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 min read\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"Stephen Siciliano\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/\",\"name\":\"Microsoft Flow and the Microsoft Common Data Model - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/cdmcolored.png\",\"datePublished\":\"2016-08-08T15:00:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/cdmcolored.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/cdmcolored.webp\",\"width\":676,\"height\":844,\"caption\":\"graphical user interface, diagram\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Automate\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft Flow and the Microsoft Common Data Model\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Flow and the Microsoft Common Data Model - 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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft Flow and the Microsoft Common Data Model - Microsoft Power Platform Blog","og_description":"Today we are excited to announce the public preview of the Microsoft Common Data Model integrated in Microsoft Flow. The Microsoft Common Data Model is an out-of-box business database for storing and managing business entities. The preview is available today as a first class business database for your flows.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/","og_site_name":"Microsoft Power Platform Blog","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/cdmcolored.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 min read","Written by":"Stephen Siciliano"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/","name":"Microsoft Flow and the Microsoft Common Data Model - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/cdmcolored.png","datePublished":"2016-08-08T15:00:10+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/cdmcolored.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/cdmcolored.webp","width":676,"height":844,"caption":"graphical user interface, diagram"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-and-common-data-model\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Power Automate","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/"},{"@type":"ListItem","position":3,"name":"Microsoft Flow and the Microsoft Common Data Model"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}}]}},"msxcm_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:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/110732","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/power-automate"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/347"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=110732"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/110732\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110732"}],"wp:term":[{"taxonomy":"power-automate-category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-category?post=110732"},{"taxonomy":"power-automate-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-tag?post=110732"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}