{"id":39,"date":"2018-09-20T10:10:51","date_gmt":"2018-09-20T17:10:51","guid":{"rendered":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/power-apps\/editable-tables\/"},"modified":"2025-06-11T08:06:57","modified_gmt":"2025-06-11T15:06:57","slug":"editable-tables","status":"publish","type":"post","link":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/power-apps\/editable-tables\/","title":{"rendered":"Editable Tables"},"content":{"rendered":"<p>Designing a productivity application to have related data and functions in one place is good practice because more can be done without having to switch back and fourth between screens. That is why many people like Excel \u2014 there is the ability to edit data real-time in a fast and efficient way.<\/p>\n<p>In PowerApps, you can implement the same concept by providing it as a front end to any data source, with the ability to customize it even more.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/blogcode.blob.core.windows.net\/editable-tables\/Final.PNG?st=2018-09-20T21%3A01%3A09Z&amp;se=2023-09-21T21%3A01%3A00Z&amp;sp=rl&amp;sv=2018-03-28&amp;sr=b&amp;sig=SUjSU%2FF62%2BLuYjZaWK2IYmqT9zNJUXIQITyd5UHHMHM%3D\" style=\"height: 451px; width: 800px; border-width: 1px; border-style: solid; border-color: rgb(245, 245, 245);\"\/><\/p>\n<h1>Scenario<\/h1>\n<p>A small business owner has a catalog of product information that is updated each time she gets a new shipment. Needing to input every item herself, these logging processes can be time-consuming, and sometimes error-prone. She builds a quick PowerApp that can log new items and change item data in line on the same screen, directly to the data source. With this app, she can interact with the data in the database quickly without having to connect through a separate interface, and she can include other important data and functions in the same application to host everything in the same space.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/blogcode.blob.core.windows.net\/editable-tables\/Editing.PNG?st=2018-09-20T16%3A44%3A32Z&amp;se=2023-09-21T16%3A44%3A00Z&amp;sp=rl&amp;sv=2018-03-28&amp;sr=b&amp;sig=pE%2BivaDpr1bHoLhSTpYzUo%2FTbccllPuuju82%2FquCyhY%3D\" style=\"width: 599px; height: 353px;\"\/><\/p>\n<h2>\nImplementation<\/h2>\n<h3>Components<\/h3>\n<ul>\n<li>\n<p>A data source (this example uses the Common Data Service)<\/p>\n<\/li>\n<li>\n<p>Form \u2013 used for new items<\/p>\n<\/li>\n<li>\n<p>Gallery \u2013 used to display existing items and<\/p>\n<\/li>\n<li>\n<p>Text input controls \u2013 used to update existing items<br \/>\n\t\u00a0<\/p>\n<\/li>\n<\/ul>\n<h3>Step 1: Add a data source<\/h3>\n<ul>\n<li>\n<p>Go to <strong>View &gt; Data sources<\/strong><\/p>\n<\/li>\n<li>\n<p>Add an existing connection or create a new one to the desired data source<\/p>\n<\/li>\n<li>\n<p>View <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/add-data-connection\">documentation on adding data sources in canvas apps<\/a><\/p>\n<p>\t\u00a0<\/p>\n<\/li>\n<\/ul>\n<h3>Step 2: Set up a form control<\/h3>\n<p>This step adds a form control to add new items.<\/p>\n<ul>\n<li>\n<p>Insert a new Form control by clicking <strong>Insert &gt; Forms &gt; Edit Form<\/strong><\/p>\n<\/li>\n<li>\n<p>In the flyout, connect the data source to the one you just connected to, or manually update the DataSource property in the formula bar.<br \/>\n<img decoding=\"async\" alt=\"\" src=\"https:\/\/blogcode.blob.core.windows.net\/editable-tables\/Flyout.PNG?st=2018-09-20T16%3A45%3A28Z&amp;se=2023-09-21T16%3A45%3A00Z&amp;sp=rl&amp;sv=2018-03-28&amp;sr=b&amp;sig=NYxlYt9khkZsCwIf3HrwW7SDwdxqSjhqCutqmySp6J4%3D\" style=\"width: 317px; height: 766px; border-width: 1px; border-style: solid; border-color: rgba(245,245,245,1);\"\/><\/p>\n<\/li>\n<li>\n<p>Change the <strong>Form.DisplayMode<\/strong> property to <strong>New<\/strong> (or FormMode.New)<\/p>\n<\/li>\n<li>\n<p>Make sure to add a button to submit the form \u2013 Button.OnSelect = NewForm(Form)<\/p>\n<\/li>\n<li>\n<p>See <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/controls\/control-form-detail\">additional documentation on the form control here<\/a><\/p>\n<p>\t\u00a0<\/p>\n<\/li>\n<\/ul>\n<h3>Step 3: Set up the gallery<\/h3>\n<p>To edit items in-line, insert a gallery control with text input boxes.<\/p>\n<ul>\n<li>\n<p>Insert a new gallery &#8211; <strong>Insert &gt; Gallery &gt; Blank vertical<\/strong><\/p>\n<\/li>\n<li>\n<p>In the template, add a text input for each field in the table you want to be able to edit &#8211; <strong>Insert &gt; Text &gt; Text input<\/strong><\/p>\n<\/li>\n<li>\n<p>For each text input box:<\/p>\n<ul>\n<li>\n<p>Set TextInput.<strong>Default<\/strong> = <strong>ThisItem.&lt;fieldName&gt;<\/strong><br \/>\n<a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/9917f6e5-364b-4cac-b806-59156f679ce6.png\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/blogcode.blob.core.windows.net\/editable-tables\/DefaultProperty.PNG?st=2018-09-20T16%3A46%3A25Z&amp;se=2023-09-21T16%3A46%3A00Z&amp;sp=rl&amp;sv=2018-03-28&amp;sr=b&amp;sig=fBxEPcPQK1MfC2Kcf1584Esm3rPIjDiu3cCjwtbKyVg%3D\" style=\"width: 669px; height: 392px;\"\/><\/a><\/p>\n<\/li>\n<li>\n<p>Set TextInput.OnChange = <strong>Patch(Products, ThisItem, { &lt;fieldName&gt;: TextInput.Text })<br \/>\n<a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/c7ed95cf-4bbe-4026-80de-d07941c22aec.png\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/blogcode.blob.core.windows.net\/editable-tables\/OnChange.PNG?st=2018-09-20T16%3A47%3A14Z&amp;se=2023-09-21T16%3A47%3A00Z&amp;sp=rl&amp;sv=2018-03-28&amp;sr=b&amp;sig=5mjkxMzKw42cvUYHHSW8Qv8KXHkwZBIVtM2oNOCgo%2BQ%3D\" style=\"width: 800px; height: 336px;\"\/><\/a><\/strong><\/p>\n<p>\t\t\u00a0<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3>Step 4: Toggle the display mode (optional)<\/h3>\n<p>In some cases it is a good idea to disable the gallery until the user specifies they want to update the data.<\/p>\n<ul>\n<li>\n<p>Add an \u2018edit\u2019 icon and set the following:<\/p>\n<ul>\n<li>\n<p><strong>icon.OnSelect = Set(galleryDisplayMode = DisplayMode.Edit)<\/strong><\/p>\n<\/li>\n<li>\n<p><strong>icon.Visible = galleryDisplayMode = DisplayMode.Disabled<\/strong><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<p>Add a \u2018stop edit\u2019 icon and set the following<\/p>\n<ul>\n<li>\n<p><strong>icon.OnSelect = Set(galleryDisplayMode = DisplayMode.Disabled)<\/strong><\/p>\n<\/li>\n<li>\n<p><strong>icon.Visible = galleryDisplayMode = DisplayMode.Edit<\/strong><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<p>Update the following properties:<\/p>\n<ul>\n<li>\n<p><strong>Gallery.DisplayMode = galleryDisplayMode<\/strong><\/p>\n<\/li>\n<li>\n<p><strong>Screen.OnStart = Set(galleryDisplayMode, DisplayMode.Disabled)<\/strong><\/p>\n<p>\t\t\u00a0<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2>Example resources<\/h2>\n<p>\u200bYou can download the <a href=\"https:\/\/blogcode.blob.core.windows.net\/editable-tables\/ProductCatalogApp.zip?st=2018-09-20T21%3A26%3A37Z&amp;se=2024-09-21T21%3A26%3A00Z&amp;sp=rl&amp;sv=2018-03-28&amp;sr=b&amp;sig=OWSePNVFGr7vH5RAhIMj8dWPV9aZxwFxdaGUcjqkCGg%3D\">PowerApp <\/a>and <a href=\"https:\/\/blogcode.blob.core.windows.net\/editable-tables\/ProductSchema.zip?st=2018-09-20T21%3A27%3A20Z&amp;se=2023-09-21T21%3A27%3A00Z&amp;sp=rl&amp;sv=2018-03-28&amp;sr=b&amp;sig=yprWIQLp%2FxcVcpv81qMYkR9gkik7OoKCCmAnAGeXH18%3D\">CDS Products entity<\/a> schema shown in the blog here. If you use the accompanying CDS entity, import the solution to add it to your Environment with a CDS 2.0 instance.<\/p>\n<ul>\n<li>\n<p>Import the CDS entity &#8216;Products&#8217;<\/p>\n<ul>\n<li style=\"font-size: 13.008px;\">\n<p>by going to\u00a0<strong style='font-style: normal; font-size: 13.008px; font-family: Tahoma, \"Helvetica Neue\", Arial, Helvetica, sans-serif;'>https:\/\/web.powerapps.com\/ &gt; [Gear icon in top right] &gt; Advanced customizations &gt; All solutions<\/strong><\/p>\n<\/li>\n<li style=\"font-size: 13.008px;\">\n<p>Click on <strong>Import<\/strong>, upload the <a href=\"https:\/\/blogcode.blob.core.windows.net\/editable-tables\/ProductSchema.zip?st=2018-09-20T21%3A27%3A20Z&amp;se=2023-09-21T21%3A27%3A00Z&amp;sp=rl&amp;sv=2018-03-28&amp;sr=b&amp;sig=yprWIQLp%2FxcVcpv81qMYkR9gkik7OoKCCmAnAGeXH18%3D\"><strong>ProductSchema.zip<\/strong><\/a> file in the dialog window, then click <strong>Import<\/strong><\/p>\n<\/li>\n<li style=\"font-size: 13.008px;\">\n<p>Select <strong>Publish all customizations<\/strong>, then <strong>Close <\/strong>the window when complete.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<p>Import the PowerApp to the same Environment<\/p>\n<ul>\n<li>\n<p>by going to<strong> https:\/\/web.powerapps.com\/ &gt; Apps &gt; Import app (preview)<\/strong><\/p>\n<\/li>\n<li>\n<p>Select the\u00a0<a href=\"https:\/\/blogcode.blob.core.windows.net\/editable-tables\/ProductCatalogApp.zip?st=2018-09-20T21%3A26%3A37Z&amp;se=2024-09-21T21%3A26%3A00Z&amp;sp=rl&amp;sv=2018-03-28&amp;sr=b&amp;sig=OWSePNVFGr7vH5RAhIMj8dWPV9aZxwFxdaGUcjqkCGg%3D\"><strong>ProductCatalogApp.zip<\/strong><\/a><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><!--EndFragment--><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This blog post highlights how one can create a PowerApps Canvas app to create an editable table to interact with the data in the database quickly without having to connect through a separate interface.<\/p>\n","protected":false},"author":103,"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":[3423],"job-role":[],"product":[3473],"property":[],"topic":[],"coauthors":[2136],"class_list":["post-39","post","type-post","status-publish","format-standard","hentry","audience-it-professional","content-type-tips-and-guides","product-power-apps"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Editable Tables - 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:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/2018\/09\/20\/editable-tables\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Editable Tables - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"This blog post highlights how one can create a PowerApps Canvas app to create an editable table to interact with the data in the database quickly without having to connect through a separate interface.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/power-apps\/editable-tables\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-20T17:10:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:06:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blogcode.blob.core.windows.net\/editable-tables\/Final.PNG?st=2018-09-20T21%3A01%3A09Z&amp;se=2023-09-21T21%3A01%3A00Z&amp;sp=rl&amp;sv=2018-03-28&amp;sr=b&amp;sig=SUjSU%2FF62%2BLuYjZaWK2IYmqT9zNJUXIQITyd5UHHMHM%3D\" \/>\n<meta name=\"author\" content=\"Denise Moran\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Denise Moran\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/09\\\/20\\\/editable-tables\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/09\\\/20\\\/editable-tables\\\/\"},\"author\":[{\"@id\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/author\\\/demora\\\/\",\"@type\":\"Person\",\"@name\":\"Denise Moran\"}],\"headline\":\"Editable Tables\",\"datePublished\":\"2018-09-20T17:10:51+00:00\",\"dateModified\":\"2025-06-11T15:06:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/09\\\/20\\\/editable-tables\\\/\"},\"wordCount\":601,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/09\\\/20\\\/editable-tables\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/blogcode.blob.core.windows.net\\\/editable-tables\\\/Final.PNG?st=2018-09-20T21%3A01%3A09Z&amp;se=2023-09-21T21%3A01%3A00Z&amp;sp=rl&amp;sv=2018-03-28&amp;sr=b&amp;sig=SUjSU%2FF62%2BLuYjZaWK2IYmqT9zNJUXIQITyd5UHHMHM%3D\",\"keywords\":[\"Building UI\",\"Templates\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/09\\\/20\\\/editable-tables\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/09\\\/20\\\/editable-tables\\\/\",\"url\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/09\\\/20\\\/editable-tables\\\/\",\"name\":\"Editable Tables - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/09\\\/20\\\/editable-tables\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/09\\\/20\\\/editable-tables\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/blogcode.blob.core.windows.net\\\/editable-tables\\\/Final.PNG?st=2018-09-20T21%3A01%3A09Z&amp;se=2023-09-21T21%3A01%3A00Z&amp;sp=rl&amp;sv=2018-03-28&amp;sr=b&amp;sig=SUjSU%2FF62%2BLuYjZaWK2IYmqT9zNJUXIQITyd5UHHMHM%3D\",\"datePublished\":\"2018-09-20T17:10:51+00:00\",\"dateModified\":\"2025-06-11T15:06:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/09\\\/20\\\/editable-tables\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/09\\\/20\\\/editable-tables\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/09\\\/20\\\/editable-tables\\\/#primaryimage\",\"url\":\"https:\\\/\\\/blogcode.blob.core.windows.net\\\/editable-tables\\\/Final.PNG?st=2018-09-20T21%3A01%3A09Z&amp;se=2023-09-21T21%3A01%3A00Z&amp;sp=rl&amp;sv=2018-03-28&amp;sr=b&amp;sig=SUjSU%2FF62%2BLuYjZaWK2IYmqT9zNJUXIQITyd5UHHMHM%3D\",\"contentUrl\":\"https:\\\/\\\/blogcode.blob.core.windows.net\\\/editable-tables\\\/Final.PNG?st=2018-09-20T21%3A01%3A09Z&amp;se=2023-09-21T21%3A01%3A00Z&amp;sp=rl&amp;sv=2018-03-28&amp;sr=b&amp;sig=SUjSU%2FF62%2BLuYjZaWK2IYmqT9zNJUXIQITyd5UHHMHM%3D\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/09\\\/20\\\/editable-tables\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Editable Tables\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/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:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/03\\\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/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:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/#\\\/schema\\\/person\\\/5f6e0fb13909510246536d2caca3fef0\",\"name\":\"Denise Moran\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e4a8472e51ce5115523b909b72e4c7b0dfbc8ecc786782f0957710a11eb42472?s=96&d=mm&r=ga3d6aa44f46b70b250b2d4cd555e1861\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e4a8472e51ce5115523b909b72e4c7b0dfbc8ecc786782f0957710a11eb42472?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e4a8472e51ce5115523b909b72e4c7b0dfbc8ecc786782f0957710a11eb42472?s=96&d=mm&r=g\",\"caption\":\"Denise Moran\"},\"url\":\"https:\\\/\\\/newed.any0.dpdns.org\\\/en-us\\\/power-platform\\\/blog\\\/author\\\/demora\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Editable Tables - 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:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/2018\/09\/20\/editable-tables\/","og_locale":"en_US","og_type":"article","og_title":"Editable Tables - Microsoft Power Platform Blog","og_description":"This blog post highlights how one can create a PowerApps Canvas app to create an editable table to interact with the data in the database quickly without having to connect through a separate interface.","og_url":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/power-apps\/editable-tables\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2018-09-20T17:10:51+00:00","article_modified_time":"2025-06-11T15:06:57+00:00","og_image":[{"url":"https:\/\/blogcode.blob.core.windows.net\/editable-tables\/Final.PNG?st=2018-09-20T21%3A01%3A09Z&amp;se=2023-09-21T21%3A01%3A00Z&amp;sp=rl&amp;sv=2018-03-28&amp;sr=b&amp;sig=SUjSU%2FF62%2BLuYjZaWK2IYmqT9zNJUXIQITyd5UHHMHM%3D","type":"","width":"","height":""}],"author":"Denise Moran","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Denise Moran","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/2018\/09\/20\/editable-tables\/#article","isPartOf":{"@id":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/2018\/09\/20\/editable-tables\/"},"author":[{"@id":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/author\/demora\/","@type":"Person","@name":"Denise Moran"}],"headline":"Editable Tables","datePublished":"2018-09-20T17:10:51+00:00","dateModified":"2025-06-11T15:06:57+00:00","mainEntityOfPage":{"@id":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/2018\/09\/20\/editable-tables\/"},"wordCount":601,"commentCount":0,"publisher":{"@id":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/2018\/09\/20\/editable-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/blogcode.blob.core.windows.net\/editable-tables\/Final.PNG?st=2018-09-20T21%3A01%3A09Z&amp;se=2023-09-21T21%3A01%3A00Z&amp;sp=rl&amp;sv=2018-03-28&amp;sr=b&amp;sig=SUjSU%2FF62%2BLuYjZaWK2IYmqT9zNJUXIQITyd5UHHMHM%3D","keywords":["Building UI","Templates"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/2018\/09\/20\/editable-tables\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/2018\/09\/20\/editable-tables\/","url":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/2018\/09\/20\/editable-tables\/","name":"Editable Tables - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/2018\/09\/20\/editable-tables\/#primaryimage"},"image":{"@id":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/2018\/09\/20\/editable-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/blogcode.blob.core.windows.net\/editable-tables\/Final.PNG?st=2018-09-20T21%3A01%3A09Z&amp;se=2023-09-21T21%3A01%3A00Z&amp;sp=rl&amp;sv=2018-03-28&amp;sr=b&amp;sig=SUjSU%2FF62%2BLuYjZaWK2IYmqT9zNJUXIQITyd5UHHMHM%3D","datePublished":"2018-09-20T17:10:51+00:00","dateModified":"2025-06-11T15:06:57+00:00","breadcrumb":{"@id":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/2018\/09\/20\/editable-tables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/2018\/09\/20\/editable-tables\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/2018\/09\/20\/editable-tables\/#primaryimage","url":"https:\/\/blogcode.blob.core.windows.net\/editable-tables\/Final.PNG?st=2018-09-20T21%3A01%3A09Z&amp;se=2023-09-21T21%3A01%3A00Z&amp;sp=rl&amp;sv=2018-03-28&amp;sr=b&amp;sig=SUjSU%2FF62%2BLuYjZaWK2IYmqT9zNJUXIQITyd5UHHMHM%3D","contentUrl":"https:\/\/blogcode.blob.core.windows.net\/editable-tables\/Final.PNG?st=2018-09-20T21%3A01%3A09Z&amp;se=2023-09-21T21%3A01%3A00Z&amp;sp=rl&amp;sv=2018-03-28&amp;sr=b&amp;sig=SUjSU%2FF62%2BLuYjZaWK2IYmqT9zNJUXIQITyd5UHHMHM%3D"},{"@type":"BreadcrumbList","@id":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/2018\/09\/20\/editable-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Editable Tables"}]},{"@type":"WebSite","@id":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/#website","url":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/newed.any0.dpdns.org\/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:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/newed.any0.dpdns.org\/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:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/#\/schema\/person\/5f6e0fb13909510246536d2caca3fef0","name":"Denise Moran","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e4a8472e51ce5115523b909b72e4c7b0dfbc8ecc786782f0957710a11eb42472?s=96&d=mm&r=ga3d6aa44f46b70b250b2d4cd555e1861","url":"https:\/\/secure.gravatar.com\/avatar\/e4a8472e51ce5115523b909b72e4c7b0dfbc8ecc786782f0957710a11eb42472?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e4a8472e51ce5115523b909b72e4c7b0dfbc8ecc786782f0957710a11eb42472?s=96&d=mm&r=g","caption":"Denise Moran"},"url":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/author\/demora\/"}]}},"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:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/39","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/103"}],"replies":[{"embeddable":true,"href":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=39"}],"version-history":[{"count":1,"href":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/39\/revisions"}],"predecessor-version":[{"id":131024,"href":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/39\/revisions\/131024"}],"wp:attachment":[{"href":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=39"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=39"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=39"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=39"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=39"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=39"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=39"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/newed.any0.dpdns.org\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=39"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}