{"id":24350,"date":"2020-08-07T13:17:40","date_gmt":"2020-08-07T13:17:40","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=24350"},"modified":"2021-05-31T09:35:43","modified_gmt":"2021-05-31T09:35:43","slug":"how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/","title":{"rendered":"How to get additional column values in PCF Dataset Control using addColumn()"},"content":{"rendered":"<h2><strong>Introduction<\/strong><\/h2>\n<p>In our previous blog, <a href=\"https:\/\/www.inogic.com\/blog\/2020\/07\/how-to-create-configurable-pcf-dataset-control-using-property-set-and-property\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Create Configurable PCF Dataset control using Property-set and Property<\/strong><\/a> we asked users about which attributes they would like to visualize. Similarly in this blog, we\u2019ll see how to programmatically get the record value in the context along with the other column values.<\/p>\n<p>In the previous blog we have seen how to get additional data using property-set with the help of user configuration. But there are some attributes which you don\u2019t want the end-user to provide like Created On, Created by and Status, etc. that are common for all the entities.<\/p>\n<p><strong>Prerequisites:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/developer\/component-framework\/get-powerapps-cli\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft Powerapps CLI<\/a> should be installed.<\/li>\n<li><a href=\"https:\/\/reactjs.org\/tutorial\/tutorial.html\" target=\"_blank\" rel=\"noopener noreferrer\">React JS<\/a> basic knowledge<\/li>\n<li>Should be familiar to create <a href=\"https:\/\/www.inogic.com\/blog\/2020\/07\/how-to-work-with-pcf-dataset-control-using-fluent-uis-detail-list\/\" target=\"_blank\" rel=\"noopener noreferrer\">Basic dataset control<\/a>.<\/li>\n<\/ul>\n<p>For the above mentioned scenario, we will be using <strong>\u2018addColumn\u2019<\/strong> method available in the context.<\/p>\n<p>Below is the syntax for additional columns. You would need to pass the logical name of the field present in the entity record.<\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<p>context.parameters.sampleDataSet.addColumn(fieldLogicalName)<\/p>\n<p>These values are loaded synchronously. But one thing to keep in mind is that the <strong>addColumn ()<\/strong> doesn\u2019t return value first time when the <strong>updateView<\/strong> is called rather it returns value when the grid has been refreshed.<\/p>\n<p>This might not be ideal for the end-user experience.<\/p>\n<p>So, to load the required columns immediately we need to refresh the grid programmatically using the below function:<\/p>\n<p>context.parameters.sampleDataSet.refresh();<\/p>\n<p>Now, when the refresh method is called, it will call the updateView() method with the columns which we have added using <strong>context.parameters.sampleDataSet.addColumn(fieldLogicalName).<\/strong><\/p>\n<p><strong>Code:<\/strong><\/p>\n<p>In the <strong>index.ts<\/strong> file you can create a method to add multiple columns or use the code in your existing functions as well.<\/p>\n<p>Ideal place to use the addColumn() is to call it in beginning of the <strong>UpdateView() <\/strong>before the rest of the logic is executed<strong>.<\/strong><\/p>\n<p>\/\/ Add more column other than property-set and default colmn on views<\/p>\n<p>public addMoreColumns(context: ComponentFramework.Context&lt;IInputs&gt;) {<\/p>\n<p>let functionName: string = &#8220;addMoreColumns&#8221;;<\/p>\n<p>try {<\/p>\n<p>if (context.parameters.sampleDataSet.addColumn) {<\/p>\n<p>context.parameters.sampleDataSet.addColumn(&#8220;createdon&#8221;);<\/p>\n<p>context.parameters.sampleDataSet.addColumn(&#8220;createdby&#8221;);<\/p>\n<p>context.parameters.sampleDataSet.refresh();<\/p>\n<p>}<\/p>\n<p>}\u00a0catch\u00a0(error)\u00a0{<\/p>\n<p>console.log(functionName\u00a0+\u00a0&#8220;&#8221;\u00a0+\u00a0error.message);<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p>Before using addColumns() in code we are getting six column values in context.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-24351\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/08\/1PCF-Dataset-control.png\" alt=\"PCF Dataset control\" width=\"927\" height=\"169\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/08\/1PCF-Dataset-control.png 927w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/08\/1PCF-Dataset-control-300x55.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/08\/1PCF-Dataset-control-768x140.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/08\/1PCF-Dataset-control-660x120.png 660w\" sizes=\"(max-width: 927px) 100vw, 927px\" \/><\/p>\n<p>After using addColumns() we got two more additional columns that we added.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-24352\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/08\/2PCF-Dataset-control.png\" alt=\"PCF Dataset control\" width=\"924\" height=\"201\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/08\/2PCF-Dataset-control-300x65.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/08\/2PCF-Dataset-control-768x166.png 768w\" sizes=\"(max-width: 924px) 100vw, 924px\" \/><\/p>\n<h2><strong>Conclusion<\/strong><\/h2>\n<p>Thus, we have seen how to get column values which are not available on view programmatically using addColumns().<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction In our previous blog, Create Configurable PCF Dataset control using Property-set and Property we asked users about which attributes they would like to visualize. Similarly in this blog, we\u2019ll see how to programmatically get the record value in the context along with the other column values. In the previous blog we have seen how\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/\">Read More: How to get additional column values in PCF Dataset Control\u2026 &raquo;<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":24354,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1929],"tags":[2290,2291],"class_list":["post-24350","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pcf","tag-get-additional-column-values","tag-pcf-dataset-control"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"Introduction In our previous blog, Create Configurable PCF Dataset control using Property-set and Property we asked users about which attributes they would like to visualize. Similarly in this blog, we\u2019ll see how to programmatically get the record value in the context along with the other column values. In the previous blog we have seen how\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Tushar\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Microsoft Dynamics 365 CRM Tips and Tricks - By Inogic\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"How to get additional column values in PCF Dataset Control using addColumn() - Microsoft Dynamics 365 CRM Tips and Tricks\" \/>\n\t\t<meta property=\"og:description\" content=\"Introduction In our previous blog, Create Configurable PCF Dataset control using Property-set and Property we asked users about which attributes they would like to visualize. Similarly in this blog, we\u2019ll see how to programmatically get the record value in the context along with the other column values. In the previous blog we have seen how\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/08\/1PCF-Dataset-control.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/08\/1PCF-Dataset-control.png\" \/>\n\t\t<meta property=\"og:image:width\" content=\"927\" \/>\n\t\t<meta property=\"og:image:height\" content=\"169\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-08-07T13:17:40+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2021-05-31T09:35:43+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inogicindia\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@inogic\" \/>\n\t\t<meta name=\"twitter:title\" content=\"How to get additional column values in PCF Dataset Control using addColumn() - Microsoft Dynamics 365 CRM Tips and Tricks\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Introduction In our previous blog, Create Configurable PCF Dataset control using Property-set and Property we asked users about which attributes they would like to visualize. Similarly in this blog, we\u2019ll see how to programmatically get the record value in the context along with the other column values. In the previous blog we have seen how\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@inogic\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/08\/1PCF-Dataset-control.png\" \/>\n\t\t<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t\t<meta name=\"twitter:data1\" content=\"Tushar\" \/>\n\t\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2020\\\/08\\\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\\\/#blogposting\",\"name\":\"How to get additional column values in PCF Dataset Control using addColumn() - Microsoft Dynamics 365 CRM Tips and Tricks\",\"headline\":\"How to get additional column values in PCF Dataset Control using addColumn()\",\"author\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/PCF-Dataset-Control1.png\",\"width\":150,\"height\":150,\"caption\":\"PCF Dataset Control\"},\"datePublished\":\"2020-08-07T13:17:40+05:30\",\"dateModified\":\"2021-05-31T09:35:43+05:30\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2020\\\/08\\\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2020\\\/08\\\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\\\/#webpage\"},\"articleSection\":\"PCF, get additional column values, PCF Dataset Control\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2020\\\/08\\\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.inogic.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/power-apps\\\/#listItem\",\"name\":\"Microsoft PowerApps\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/power-apps\\\/#listItem\",\"position\":2,\"name\":\"Microsoft PowerApps\",\"item\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/power-apps\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/power-apps\\\/pcf\\\/#listItem\",\"name\":\"PCF\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/power-apps\\\/pcf\\\/#listItem\",\"position\":3,\"name\":\"PCF\",\"item\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/power-apps\\\/pcf\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2020\\\/08\\\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\\\/#listItem\",\"name\":\"How to get additional column values in PCF Dataset Control using addColumn()\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/power-apps\\\/#listItem\",\"name\":\"Microsoft PowerApps\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2020\\\/08\\\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\\\/#listItem\",\"position\":4,\"name\":\"How to get additional column values in PCF Dataset Control using addColumn()\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/power-apps\\\/pcf\\\/#listItem\",\"name\":\"PCF\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#organization\",\"name\":\"Microsoft Dynamics 365 CRM Tips and Tricks\",\"description\":\"By Inogic\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/inogic-logo.png\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2020\\\/08\\\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\\\/#organizationLogo\",\"width\":1000,\"height\":325,\"caption\":\"inogic logo\"},\"image\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2020\\\/08\\\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\\\/#organizationLogo\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/inogicindia\",\"https:\\\/\\\/twitter.com\\\/inogic\",\"https:\\\/\\\/www.instagram.com\\\/inogicindia\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCM4V7ousgLSu1hbOEv4DUuQ\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/inogicindia\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/\",\"name\":\"Tushar\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2020\\\/08\\\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/839d9ae7d2b941d2d09e91df322267a429821f2ce5494302b53bd5ca3679f1a0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Tushar\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2020\\\/08\\\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\\\/#webpage\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2020\\\/08\\\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\\\/\",\"name\":\"How to get additional column values in PCF Dataset Control using addColumn() - Microsoft Dynamics 365 CRM Tips and Tricks\",\"description\":\"Introduction In our previous blog, Create Configurable PCF Dataset control using Property-set and Property we asked users about which attributes they would like to visualize. Similarly in this blog, we\\u2019ll see how to programmatically get the record value in the context along with the other column values. In the previous blog we have seen how\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2020\\\/08\\\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/PCF-Dataset-Control1.png\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2020\\\/08\\\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\\\/#mainImage\",\"width\":150,\"height\":150,\"caption\":\"PCF Dataset Control\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2020\\\/08\\\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\\\/#mainImage\"},\"datePublished\":\"2020-08-07T13:17:40+05:30\",\"dateModified\":\"2021-05-31T09:35:43+05:30\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/\",\"name\":\"Microsoft Dynamics 365 CRM Tips and Tricks\",\"alternateName\":\"Inogic\",\"description\":\"By Inogic\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"How to get additional column values in PCF Dataset Control using addColumn() - Microsoft Dynamics 365 CRM Tips and Tricks","description":"Introduction In our previous blog, Create Configurable PCF Dataset control using Property-set and Property we asked users about which attributes they would like to visualize. Similarly in this blog, we\u2019ll see how to programmatically get the record value in the context along with the other column values. In the previous blog we have seen how","canonical_url":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/#blogposting","name":"How to get additional column values in PCF Dataset Control using addColumn() - Microsoft Dynamics 365 CRM Tips and Tricks","headline":"How to get additional column values in PCF Dataset Control using addColumn()","author":{"@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author"},"publisher":{"@id":"https:\/\/www.inogic.com\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/08\/PCF-Dataset-Control1.png","width":150,"height":150,"caption":"PCF Dataset Control"},"datePublished":"2020-08-07T13:17:40+05:30","dateModified":"2021-05-31T09:35:43+05:30","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/#webpage"},"isPartOf":{"@id":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/#webpage"},"articleSection":"PCF, get additional column values, PCF Dataset Control"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/www.inogic.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/power-apps\/#listItem","name":"Microsoft PowerApps"}},{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/power-apps\/#listItem","position":2,"name":"Microsoft PowerApps","item":"https:\/\/www.inogic.com\/blog\/category\/power-apps\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/power-apps\/pcf\/#listItem","name":"PCF"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/power-apps\/pcf\/#listItem","position":3,"name":"PCF","item":"https:\/\/www.inogic.com\/blog\/category\/power-apps\/pcf\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/#listItem","name":"How to get additional column values in PCF Dataset Control using addColumn()"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/power-apps\/#listItem","name":"Microsoft PowerApps"}},{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/#listItem","position":4,"name":"How to get additional column values in PCF Dataset Control using addColumn()","previousItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/power-apps\/pcf\/#listItem","name":"PCF"}}]},{"@type":"Organization","@id":"https:\/\/www.inogic.com\/blog\/#organization","name":"Microsoft Dynamics 365 CRM Tips and Tricks","description":"By Inogic","url":"https:\/\/www.inogic.com\/blog\/","logo":{"@type":"ImageObject","url":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/02\/inogic-logo.png","@id":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/#organizationLogo","width":1000,"height":325,"caption":"inogic logo"},"image":{"@id":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/#organizationLogo"},"sameAs":["https:\/\/www.facebook.com\/inogicindia","https:\/\/twitter.com\/inogic","https:\/\/www.instagram.com\/inogicindia\/","https:\/\/www.youtube.com\/channel\/UCM4V7ousgLSu1hbOEv4DUuQ","https:\/\/www.linkedin.com\/company\/inogicindia"]},{"@type":"Person","@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author","url":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/","name":"Tushar","image":{"@type":"ImageObject","@id":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/839d9ae7d2b941d2d09e91df322267a429821f2ce5494302b53bd5ca3679f1a0?s=96&d=mm&r=g","width":96,"height":96,"caption":"Tushar"}},{"@type":"WebPage","@id":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/#webpage","url":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/","name":"How to get additional column values in PCF Dataset Control using addColumn() - Microsoft Dynamics 365 CRM Tips and Tricks","description":"Introduction In our previous blog, Create Configurable PCF Dataset control using Property-set and Property we asked users about which attributes they would like to visualize. Similarly in this blog, we\u2019ll see how to programmatically get the record value in the context along with the other column values. In the previous blog we have seen how","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.inogic.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/#breadcrumblist"},"author":{"@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author"},"creator":{"@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/08\/PCF-Dataset-Control1.png","@id":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/#mainImage","width":150,"height":150,"caption":"PCF Dataset Control"},"primaryImageOfPage":{"@id":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/#mainImage"},"datePublished":"2020-08-07T13:17:40+05:30","dateModified":"2021-05-31T09:35:43+05:30"},{"@type":"WebSite","@id":"https:\/\/www.inogic.com\/blog\/#website","url":"https:\/\/www.inogic.com\/blog\/","name":"Microsoft Dynamics 365 CRM Tips and Tricks","alternateName":"Inogic","description":"By Inogic","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.inogic.com\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"Microsoft Dynamics 365 CRM Tips and Tricks - By Inogic","og:type":"article","og:title":"How to get additional column values in PCF Dataset Control using addColumn() - Microsoft Dynamics 365 CRM Tips and Tricks","og:description":"Introduction In our previous blog, Create Configurable PCF Dataset control using Property-set and Property we asked users about which attributes they would like to visualize. Similarly in this blog, we\u2019ll see how to programmatically get the record value in the context along with the other column values. In the previous blog we have seen how","og:url":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/","og:image":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/08\/1PCF-Dataset-control.png","og:image:secure_url":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/08\/1PCF-Dataset-control.png","og:image:width":927,"og:image:height":169,"article:published_time":"2020-08-07T13:17:40+00:00","article:modified_time":"2021-05-31T09:35:43+00:00","article:publisher":"https:\/\/www.facebook.com\/inogicindia","twitter:card":"summary_large_image","twitter:site":"@inogic","twitter:title":"How to get additional column values in PCF Dataset Control using addColumn() - Microsoft Dynamics 365 CRM Tips and Tricks","twitter:description":"Introduction In our previous blog, Create Configurable PCF Dataset control using Property-set and Property we asked users about which attributes they would like to visualize. Similarly in this blog, we\u2019ll see how to programmatically get the record value in the context along with the other column values. In the previous blog we have seen how","twitter:creator":"@inogic","twitter:image":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2020\/08\/1PCF-Dataset-control.png","twitter:label1":"Written by","twitter:data1":"Tushar","twitter:label2":"Est. reading time","twitter:data2":"2 minutes"},"aioseo_meta_data":{"post_id":"24350","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2023-02-02 07:30:56","updated":"2025-07-04 07:45:02","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.inogic.com\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.inogic.com\/blog\/category\/power-apps\/\" title=\"Microsoft PowerApps\">Microsoft PowerApps<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.inogic.com\/blog\/category\/power-apps\/pcf\/\" title=\"PCF\">PCF<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tHow to get additional column values in PCF Dataset Control using addColumn()\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.inogic.com\/blog"},{"label":"Microsoft PowerApps","link":"https:\/\/www.inogic.com\/blog\/category\/power-apps\/"},{"label":"PCF","link":"https:\/\/www.inogic.com\/blog\/category\/power-apps\/pcf\/"},{"label":"How to get additional column values in PCF Dataset Control using addColumn()","link":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-get-additional-column-values-in-pcf-dataset-control-using-addcolumn\/"}],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/24350","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=24350"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/24350\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/24354"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=24350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=24350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=24350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}