{"id":335,"date":"2020-03-08T18:48:05","date_gmt":"2020-03-08T17:48:05","guid":{"rendered":"https:\/\/dynamiacs.com\/?p=335"},"modified":"2021-02-22T22:05:20","modified_gmt":"2021-02-22T21:05:20","slug":"working-with-data-in-cds","status":"publish","type":"post","link":"https:\/\/dynamiacs.com\/?p=335","title":{"rendered":"Working with Data in Data Verse (aka CDS)"},"content":{"rendered":"\n<p>To&nbsp;manage&nbsp;data&nbsp;in&nbsp;Data Verse (formally know as &nbsp;Common Data Service)&nbsp;you&nbsp;always&nbsp;choose&nbsp;the&nbsp;way&nbsp;via&nbsp;the&nbsp;Excel Addin?&nbsp;&nbsp;<\/p>\n\n\n\n<p>You&nbsp;no&nbsp;longer&nbsp;need&nbsp;to&nbsp;do&nbsp;this.&nbsp;You&nbsp;can&nbsp;now&nbsp;create&nbsp;and&nbsp;edit&nbsp;data&nbsp;directly&nbsp;from&nbsp;the&nbsp;data&nbsp;entity.&nbsp;&nbsp;&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"596\" src=\"https:\/\/dynamiacs.com\/wp-content\/uploads\/2020\/03\/image-1.png\" alt=\"Power Apps \nHome \n(WI Learn \nApps \nCreate \nData \nEntities \nOption Sets \nDataflows \nExport to data lake \nConnections \nCustom Connectors \nGateways \n40 \nFlows \nAl Builder \nSolutions \n-4\u2014 Add record Edit record \nDelete record \nCD Refresh data \nEdit data in Excel \nEnvironment \nJan Timphaus's Environ... \nv Export data \nEntities &gt; Account \nFields \nRelationships \nAccount Name \nCustomer A \nBusiness rules \nViews \nForms \nDashboards \nCharts \nKeys \nGet data \nData \nPrimary Contact \nr-\u00f6 My Active Accounts v \nEmail (Primary \nMain Phone \n12345567688 \nAddress 1: City \" class=\"wp-image-338\" srcset=\"https:\/\/dynamiacs.com\/wp-content\/uploads\/2020\/03\/image-1.png 1024w, https:\/\/dynamiacs.com\/wp-content\/uploads\/2020\/03\/image-1-300x175.png 300w, https:\/\/dynamiacs.com\/wp-content\/uploads\/2020\/03\/image-1-768x447.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>The Main Form&nbsp;opens&nbsp;and&nbsp;you&nbsp;can&nbsp;add&nbsp;a&nbsp;new&nbsp;record&nbsp;or&nbsp;edit&nbsp;the&nbsp;selected&nbsp;record.&nbsp;&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"639\" src=\"https:\/\/dynamiacs.com\/wp-content\/uploads\/2020\/03\/image.png\" alt=\"\" class=\"wp-image-337\" srcset=\"https:\/\/dynamiacs.com\/wp-content\/uploads\/2020\/03\/image.png 1024w, https:\/\/dynamiacs.com\/wp-content\/uploads\/2020\/03\/image-300x187.png 300w, https:\/\/dynamiacs.com\/wp-content\/uploads\/2020\/03\/image-768x479.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Here&nbsp;you&nbsp;can&nbsp;manage&nbsp;the&nbsp;data&nbsp;record&nbsp;accordingly&nbsp;and&nbsp;leave&nbsp;it&nbsp;again&nbsp;via&nbsp;Save&amp;Close.&nbsp;&nbsp;<\/p>\n\n\n\n<p>To delete a record you only have to select the record and select Delete record. No Forms will open and the record will be deleted.<\/p>\n\n\n\n<p>Is&nbsp;this&nbsp;cool?&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To&nbsp;manage&nbsp;data&nbsp;in&nbsp;Data Verse (formally know as &nbsp;Common Data Service)&nbsp;you&nbsp;always&nbsp;choose&nbsp;the&nbsp;way&nbsp;via&nbsp;the&nbsp;Excel Addin?&nbsp;&nbsp; You&nbsp;no&nbsp;longer&nbsp;need&nbsp;to&nbsp;do&nbsp;this.&nbsp;You&nbsp;can&nbsp;now&nbsp;create&nbsp;and&nbsp;edit&nbsp;data&nbsp;directly&nbsp;from&nbsp;the&nbsp;data&nbsp;entity.&nbsp;&nbsp;&nbsp; The Main Form&nbsp;opens&nbsp;and&nbsp;you&nbsp;can&nbsp;add&nbsp;a&nbsp;new&nbsp;record&nbsp;or&nbsp;edit&nbsp;the&nbsp;selected&nbsp;record.&nbsp;&nbsp; Here&nbsp;you&nbsp;can&nbsp;manage&nbsp;the&nbsp;data&nbsp;record&nbsp;accordingly&nbsp;and&nbsp;leave&nbsp;it&nbsp;again&nbsp;via&nbsp;Save&amp;Close.&nbsp;&nbsp; To delete a record you only have to select the record and select Delete record. No Forms will open and the record will be deleted. Is&nbsp;this&nbsp;cool?&nbsp;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[8],"tags":[57,40,58,56],"class_list":["post-335","post","type-post","status-publish","format-standard","hentry","category-blog","tag-cds","tag-common-data-service","tag-data","tag-data-verse"],"taxonomy_info":{"category":[{"value":8,"label":"Blog"}],"post_tag":[{"value":57,"label":"CDS"},{"value":40,"label":"Common Data Service"},{"value":58,"label":"Data"},{"value":56,"label":"Data Verse"}]},"featured_image_src_large":false,"author_info":{"display_name":"Jan","author_link":"https:\/\/dynamiacs.com\/?author=2"},"comment_info":0,"category_info":[{"term_id":8,"name":"Blog","slug":"blog","term_group":0,"term_taxonomy_id":8,"taxonomy":"category","description":"","parent":0,"count":38,"filter":"raw","cat_ID":8,"category_count":38,"category_description":"","cat_name":"Blog","category_nicename":"blog","category_parent":0}],"tag_info":[{"term_id":57,"name":"CDS","slug":"cds","term_group":0,"term_taxonomy_id":57,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":40,"name":"Common Data Service","slug":"common-data-service","term_group":0,"term_taxonomy_id":40,"taxonomy":"post_tag","description":"","parent":0,"count":2,"filter":"raw"},{"term_id":58,"name":"Data","slug":"data","term_group":0,"term_taxonomy_id":58,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":56,"name":"Data Verse","slug":"data-verse","term_group":0,"term_taxonomy_id":56,"taxonomy":"post_tag","description":"","parent":0,"count":2,"filter":"raw"}],"_links":{"self":[{"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/posts\/335","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=335"}],"version-history":[{"count":4,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/posts\/335\/revisions"}],"predecessor-version":[{"id":781,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/posts\/335\/revisions\/781"}],"wp:attachment":[{"href":"https:\/\/dynamiacs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}