{"id":12206,"date":"2018-07-05T18:08:25","date_gmt":"2018-07-05T12:38:25","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=12206"},"modified":"2025-05-05T15:07:11","modified_gmt":"2025-05-05T09:37:11","slug":"update-smart-sheet-at-the-time-of-entity-records-creation-in-dynamics-365","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2018\/07\/update-smart-sheet-at-the-time-of-entity-records-creation-in-dynamics-365\/","title":{"rendered":"Update Smart Sheet at the time of entity records creation in Dynamics 365"},"content":{"rendered":"<h2><strong>Introduction:<\/strong><\/h2>\n<p style=\"text-align: justify;\">In our\u00a0<a href=\"https:\/\/www.inogic.com\/blog\/category\/microsoft-flow\/\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft Flow blog series<\/a>, we have explored various topics related to Microsoft Flow and will keep on exploring more.<\/p>\n<p style=\"text-align: justify;\">Microsoft flow helps us to create\u00a0a backup\u00a0of our data in smart sheet. So user don\u2019t need to download excel from CRM for further analysis. Recently while working in Microsoft Flow we found something amazing where we can create records in Smart Sheet at\u00a0the time\u00a0of creating\u00a0a Lead entity record\u00a0of Dynamic CRM.<\/p>\n<p style=\"text-align: justify;\">In this blog will walk through the steps to create records in a smart sheet at the same time of creating Entity records.<\/p>\n<p style=\"text-align: justify;\">Let\u2019s see the steps to create flow in Dynamics CRM:<\/p>\n<p style=\"text-align: justify;\">1.\u00a0<a href=\"https:\/\/unitedkingdom.flow.microsoft.com\/en-us\/galleries\/public\/templates\/43e5ca10802f11e6b7882f151e4e7369\/when-a-new-lead-is-created-in-dynamics-365-add-it-to-a-smartsheet\/\" target=\"_blank\" rel=\"noopener noreferrer\">Click here<\/a> to open Flow template.<\/p>\n<p style=\"text-align: justify;\">2. Click on Use This Template button.<\/p>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-28086\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/00Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png\" alt=\"Update Smart Sheet at the time of Entity records creation in Dynamics 365 using Microsoft Flow\" width=\"751\" height=\"529\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/00Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png 751w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/00Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-300x211.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/00Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-660x465.png 660w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/00Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-200x140.png 200w\" sizes=\"(max-width: 751px) 100vw, 751px\" \/><\/p>\n<p style=\"text-align: justify;\">3. You will see below window. Click on Sign in and complete the sing in process.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-28087\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/01Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png\" alt=\"Update Smart Sheet at the time of Entity records creation in Dynamics 365 using Microsoft Flow\" width=\"437\" height=\"171\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/01Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png 437w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/01Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-300x117.png 300w\" sizes=\"(max-width: 437px) 100vw, 437px\" \/><\/p>\n<p>4. After successfully login, you will see below window.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-28072\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/3Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png\" alt=\"Update Smart Sheet at the time of Entity records creation in Dynamics 365 using Microsoft Flow\" width=\"624\" height=\"201\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/3Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png 624w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/3Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-300x97.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><img decoding=\"async\" class=\"aligncenter size-full wp-image-28072\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/3Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png\" alt=\"Update Smart Sheet at the time of Entity records creation in Dynamics 365 using Microsoft Flow\" width=\"624\" height=\"201\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/3Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png 624w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/3Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-300x97.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<p>5. Now you need to create one smart sheet<\/p>\n<p><a href=\"https:\/\/app.smartsheet.com\/b\/home\" target=\"_blank\" rel=\"noopener noreferrer\">Click Here<\/a> refer this link to Log in or Sign up into a smart sheet<\/p>\n<blockquote><p><em>Note: you can create a smart sheet by creating a new account or use existing Gmail account.<\/em><\/p><\/blockquote>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-28073\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/4Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png\" alt=\"Update Smart Sheet at the time of Entity records creation in Dynamics 365 using Microsoft Flow\" width=\"575\" height=\"270\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/4Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png 575w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/4Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-300x141.png 300w\" sizes=\"(max-width: 575px) 100vw, 575px\" \/>Once user successfully login in to smart sheet you will see below window. Now, we need to create smart sheet<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-28074\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/5Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png\" alt=\"Update Smart Sheet at the time of Entity records creation in Dynamics 365 using Microsoft Flow\" width=\"892\" height=\"331\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/5Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png 892w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/5Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-300x111.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/5Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-768x285.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/5Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-660x245.png 660w\" sizes=\"(max-width: 892px) 100vw, 892px\" \/><\/p>\n<p style=\"text-align: justify;\">In this example, we created record for Lead entity so we will create columns related to lead entity such as Last Name, Topic, Mobile Number, Company Name, First Name and Job Title.<\/p>\n<blockquote><p><em>Note: Here column name is used for mapping CRM Entity Record.<\/em><\/p><\/blockquote>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-28085\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/6Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png\" alt=\"Update Smart Sheet at the time of Entity records creation in Dynamics 365 using Microsoft Flow\" width=\"1151\" height=\"503\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/6Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png 1151w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/6Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-300x131.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/6Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-768x336.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/6Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-1024x447.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/6Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-660x288.png 660w\" sizes=\"(max-width: 1151px) 100vw, 1151px\" \/><\/p>\n<p>6. Now we finish the first part of the process that is Create Smart Sheet. Next, we need to create flow.<\/p>\n<p>After creating smart sheet you will see in below window both connections has been done successfully. Now for creating flow click on continue button.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-28076\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/7Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png\" alt=\"Update Smart Sheet at the time of Entity records creation in Dynamics 365 using Microsoft Flow\" width=\"624\" height=\"229\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/7Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png 624w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/7Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-300x110.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<p>Once we click on continue flow steps are visible for us and we will be able to create actual flow as shown in the screenshot below.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-28077\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/8Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png\" alt=\"Update Smart Sheet at the time of Entity records creation in Dynamics 365 using Microsoft Flow\" width=\"623\" height=\"371\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/8Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png 623w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/8Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-300x179.png 300w\" sizes=\"(max-width: 623px) 100vw, 623px\" \/><\/p>\n<p>Now to create records in smart sheet from the records created in Lead entity Dynamic CRM we need follow the below steps.<\/p>\n<p style=\"padding-left: 30px;\">1. Select the sheet from list.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-28078\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/9Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png\" alt=\"Update Smart Sheet at the time of Entity records creation in Dynamics 365 using Microsoft Flow\" width=\"619\" height=\"381\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/9Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png 619w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/9Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-300x185.png 300w\" sizes=\"(max-width: 619px) 100vw, 619px\" \/><\/p>\n<p>Organization Name list will pop up from Dynamic CRM that we provided in Step 3.<\/p>\n<p style=\"padding-left: 30px;\">2. Select the Entity Name<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-28079\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/10Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png\" alt=\"Update Smart Sheet at the time of Entity records creation in Dynamics 365 using Microsoft Flow\" width=\"619\" height=\"441\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/10Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png 619w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/10Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-300x214.png 300w\" sizes=\"(max-width: 619px) 100vw, 619px\" \/><\/p>\n<p>Entity List contains CRM OOB entity and Custom entity both.<\/p>\n<p style=\"padding-left: 30px;\">3. Now Select sheet from list.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-28084\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/111Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png\" alt=\"Update Smart Sheet at the time of Entity records creation in Dynamics 365 using Microsoft Flow\" width=\"866\" height=\"399\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/111Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png 866w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/111Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-300x138.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/111Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-768x354.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/111Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-660x304.png 660w\" sizes=\"(max-width: 866px) 100vw, 866px\" \/><\/p>\n<p style=\"text-align: justify;\">Sheet directory will pop up from the smart sheet portal that we created in Step 5 and 6. Once we select the sheet all the columns in sheet are visible which we created at the time of smart sheet creation.<\/p>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"aligncenter wp-image-12222\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/1Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365.png\" alt=\"Update Smart Sheet at the time of Entity records creation in Dynamics 365\" width=\"822\" height=\"802\" \/><\/p>\n<p style=\"text-align: justify; padding-left: 30px;\">4.\u00a0Now we need to map Smart Sheet columns to Dynamic CRM entity attributes as shown in the screenshot below.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-28081\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/13Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png\" alt=\"Update Smart Sheet at the time of Entity records creation in Dynamics 365 using Microsoft Flow\" width=\"924\" height=\"547\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/13Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png 924w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/13Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-300x178.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/13Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-768x455.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/13Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-660x391.png 660w\" sizes=\"(max-width: 924px) 100vw, 924px\" \/><\/p>\n<p style=\"text-align: justify;\">At the time of filling smart sheet columns the Dynamics CRM entity column list will auto populate in right side panel where we need to match the respective columns.<\/p>\n<p style=\"text-align: justify;\">And finally, click on save button to save the flow details.<\/p>\n<p style=\"text-align: justify;\">7. Now let\u2019s go into Dynamic CRM for creating Lead entity Record. Here we have created two lead entity records as shown in below screenshot<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-28082\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/14Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png\" alt=\"Update Smart Sheet at the time of Entity records creation in Dynamics 365 using Microsoft Flow\" width=\"1097\" height=\"701\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/14Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png 1097w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/14Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-300x192.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/14Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-768x491.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/14Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-1024x654.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/14Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-660x422.png 660w\" sizes=\"(max-width: 1097px) 100vw, 1097px\" \/><\/p>\n<p>8. Now let\u2019s check smart sheet in smart sheet online portal. Two smart sheet record is created for lead entity.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-28083\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/15Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png\" alt=\"Update Smart Sheet at the time of Entity records creation in Dynamics 365 using Microsoft Flow\" width=\"1090\" height=\"327\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/15Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow.png 1090w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/15Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-300x90.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/15Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-768x230.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/15Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-1024x307.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/07\/15Update-Smart-Sheet-at-the-time-of-Entity-records-creation-in-Dynamics-365-using-Microsoft-Flow-660x198.png 660w\" sizes=\"(max-width: 1090px) 100vw, 1090px\" \/><\/p>\n<h2><strong>Conclusion: <\/strong><\/h2>\n<p>This will help users to direct analysis of your CRM data on excel where user don\u2019t need to download excel from Dynamics CRM every time and it also helps us to get back up of Dynamic CRM entity Records.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction: In our\u00a0Microsoft Flow blog series, we have explored various topics related to Microsoft Flow and will keep on exploring more. Microsoft flow helps us to create\u00a0a backup\u00a0of our data in smart sheet. So user don\u2019t need to download excel from CRM for further analysis. Recently while working in Microsoft Flow we found something amazing\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2018\/07\/update-smart-sheet-at-the-time-of-entity-records-creation-in-dynamics-365\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":12221,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[16,18,19,36,1985],"tags":[561,742,1150,1153,1155],"class_list":["post-12206","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365","category-dynamics-365-v9-2","category-dynamics-crm","category-microsoft-flow","category-power-automate","tag-dynamics-365-microsoft-flow","tag-entity-records-creation-in-dynamics-365","tag-microsoft-flow","tag-microsoft-flow-dynamics-365","tag-microsoft-flow-dynamics-crm"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/12206","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=12206"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/12206\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/12221"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=12206"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=12206"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=12206"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}