{"id":7209,"date":"2019-11-06T07:00:00","date_gmt":"2019-11-06T15:00:00","guid":{"rendered":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/whats-new-in-dataflows-in-power-apps-this-month\/"},"modified":"2025-06-11T08:01:21","modified_gmt":"2025-06-11T15:01:21","slug":"whats-new-in-dataflows-in-power-apps-this-month","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/whats-new-in-dataflows-in-power-apps-this-month\/","title":{"rendered":"What&#8217;s new in Dataflows in Power Apps this month?"},"content":{"rendered":"<p>Over the past few weeks we have released several new features in Dataflows, allowing users to seamlessly ingest and prepare data that can be widely reused by other users across the Power Platform, including:<\/p>\n<p><span style=\"text-decoration: underline;\">New Data Connectors:<\/span><\/p>\n<ul>\n<li>Local Folder<\/li>\n<li>SharePoint Folder<\/li>\n<li>Google BigQuery<\/li>\n<li>HDInsight Spark<\/li>\n<li>Apache Spark<\/li>\n<li>Generic ODBC<\/li>\n<\/ul>\n<p><span style=\"text-decoration: underline;\">New Data Transformations:<\/span><\/p>\n<ul>\n<li>Combine Files UX<\/li>\n<li>Additional Number\/Date\/DateTime\/Duration transformations UX<\/li>\n<\/ul>\n<p><span style=\"text-decoration: underline;\">Other Authoring Enhancements:<\/span><\/p>\n<ul>\n<li>Data Profiling<\/li>\n<li>Query Parameters UX<\/li>\n<li>Function Authoring UX<\/li>\n<\/ul>\n<p>You can continue reading the rest of this blog post for more details about each of these features.<\/p>\n<h3>New Data Connectors<\/h3>\n<p>This month we have added many new data connectors to Dataflows, including:<\/p>\n<ul>\n<li><strong>Folder<\/strong> \u2013 Use this connector in order to ingest data from files in local (or network-based) file systems, or to query and analyze files\u2019 metadata.<\/li>\n<li><strong>SharePoint Folder<\/strong> \u2013 Similar scenarios as the previous item, but available on top of a SharePoint folder (either on-prem or SharePoint Online).<\/li>\n<li><strong>HDInsight Spark<\/strong> \u2013 Read tables from HDInsight Spark databases.<\/li>\n<li><strong>Apache Spark<\/strong> \u2013 Read tables from any Apache Spark distribution database, either on-prem or cloud-based.<\/li>\n<li><strong>Generic ODBC<\/strong> \u2013 Plug in any ODBC driver, specify a connection string or DSN and connect from your dataflows to import and transform data from many different sources.<\/li>\n<\/ul>\n<p>You can find all of these new connectors within the Power Query Online Get Data experience in Dataflows:<\/p>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/1.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter size-full wp-image-7210\" height=\"1920\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/1.png\" width=\"3000\" srcset=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/1.webp 3000w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/1-300x192.webp 300w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/1-1024x655.webp 1024w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/1-768x492.webp 768w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/1-1536x983.webp 1536w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/1-2048x1311.webp 2048w\" sizes=\"auto, (max-width: 3000px) 100vw, 3000px\" \/><\/a><\/p>\n<h3>Combine Files<\/h3>\n<p>A very common use case within Data Preparation consists in combining data from multiple files within a folder in order to create a single logical view or table. For example, imagine being able to easily append files from a folder that have the same schema but contain rows of data for different time periods; with new files being dropped in the same location on a regular basis.<\/p>\n<p>This scenario can now be easily accomplished using Dataflows, in combination with the Folder, or SharePoint Folder connectors, or on top of any other tabular result in Power Query that contains a column with Binary data.<\/p>\n<p>Users can access the Combine Files experience directly from the Get Data preview for each of those connectors, or from the Power Query Editor by clicking the Combine icon in a Binary column\u2019s header or under the Combine menu in the toolbar.<\/p>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/2.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter size-full wp-image-7211\" height=\"1920\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/2.png\" width=\"3000\" srcset=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/2.webp 3000w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/2-300x192.webp 300w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/2-1024x655.webp 1024w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/2-768x492.webp 768w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/2-1536x983.webp 1536w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/2-2048x1311.webp 2048w\" sizes=\"auto, (max-width: 3000px) 100vw, 3000px\" \/><\/a><br \/>\n<a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/3.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter size-full wp-image-7212\" height=\"1920\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/3.png\" width=\"3000\" srcset=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/3.webp 3000w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/3-300x192.webp 300w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/3-1024x655.webp 1024w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/3-768x492.webp 768w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/3-1536x983.webp 1536w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/3-2048x1311.webp 2048w\" sizes=\"auto, (max-width: 3000px) 100vw, 3000px\" \/><\/a><\/p>\n<p>Upon entering the Combine Files dialog, users can preview and select the relevant data from each of the files, by using one of the files in the folder as the sample. Users can also decide to skip files with errors, generally caused by a different structure within that file that prevents the extraction logic from working.<\/p>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/4.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter size-full wp-image-7213\" height=\"1178\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/4.png\" width=\"1295\" srcset=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/4.webp 1295w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/4-300x273.webp 300w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/4-1024x931.webp 1024w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/4-768x699.webp 768w\" sizes=\"auto, (max-width: 1295px) 100vw, 1295px\" \/><\/a><\/p>\n<p>After closing the Combine Files dialog, users will see multiple queries generated in the Power Query Editor, allowing further transformations to be applied in order to extract data from each of the files, as well as the final output query that combines all files within the folder using the specified transformation steps.<\/p>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/10b.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter size-full wp-image-7225\" height=\"1920\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/10b.png\" width=\"3000\" srcset=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/10b.webp 3000w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/10b-300x192.webp 300w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/10b-1024x655.webp 1024w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/10b-768x492.webp 768w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/10b-1536x983.webp 1536w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/10b-2048x1311.webp 2048w\" sizes=\"auto, (max-width: 3000px) 100vw, 3000px\" \/><\/a><\/p>\n<p>You can learn more about Combine Files in this documentation article: <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-query\/combinefiles\">https:\/\/docs.microsoft.com\/en-us\/power-query\/combinefiles<\/a><\/p>\n<h3>Additional Number\/Date\/DateTime\/Duration transformations UX<\/h3>\n<p>We\u2019ve added UX support for several Number\/Date\/DateTime\/Duration transformations via the toolbar. These operations can now be accessed from the Power Query Editor and make it very easy to work with queries that yield scalar values of any of these types.<\/p>\n<ul>\n<li><strong>Number transformations<\/strong>:\n<ul>\n<li><strong>Standard<\/strong>: Add, Multiply, Subtract, Divide, Integer divide, Modulo, Percentage, Percent of<\/li>\n<li><strong>Scientific<\/strong>: Absolute value, Power (Square, Cube and Custom), Square root, Exponent, Logarithm (Base-10 and Natural) and Factorial.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Date transformations<\/strong>:\n<ul>\n<li><strong>Age<\/strong><\/li>\n<li><strong>Date only<\/strong><\/li>\n<li><strong>Year<\/strong>: Extract year, Start of Year, End of Year<\/li>\n<li><strong>Month<\/strong>: Extract month (number), start of month, end of month, days in month, name of the month.<\/li>\n<li><strong>Quarter<\/strong>: Quarter of year, Start of quarter, End of quarter.<\/li>\n<li><strong>Week<\/strong>: Week of year, Week of month, Start of week, End of week.<\/li>\n<li><strong>Day<\/strong>: Day, Day of week, Day of year, Start of day, End of day, Name of day.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Time transformations<\/strong>:\n<ul>\n<li><strong>Time only<\/strong><\/li>\n<li><strong>Hour<\/strong>: Extract hour, Start of hour, End of hour<\/li>\n<li><strong>Minute<\/strong><\/li>\n<li><strong>Second<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><strong>Duration transforms:<\/strong>\n<ul>\n<li><strong>Extract component: <\/strong>Days, Hours, Minutes, Seconds<\/li>\n<li><strong style=\"font-size: 1rem;\">Calculate total: <\/strong><span style=\"font-size: 1rem;\">Years, Days, Hours, Minutes, Seconds<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/10c.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter size-full wp-image-7226\" height=\"753\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/10c.png\" width=\"1914\" srcset=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/10c.webp 1914w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/10c-300x118.webp 300w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/10c-1024x403.webp 1024w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/10c-768x302.webp 768w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/10c-1536x604.webp 1536w\" sizes=\"auto, (max-width: 1914px) 100vw, 1914px\" \/><\/a><\/p>\n<h3>Data Profiling<\/h3>\n<p>Power Query provides hundreds of data transformations that can be applied by users to clean and reshape data into the desired output. However, it is sometimes hard for users to clearly identify issues within their data such as errors, empty values or duplicates. Additionally, it\u2019s also important for users to understand value distribution within a given column or other relevant statistics (such as average, median, min, max for a Number columns, or other type specific statistics).<\/p>\n<p>This month, we\u2019re bringing Data Profiling capabilities to Power Query Online that will help dataflows authors more easily understand their data and produce better data entities that can be reused by several other users within their organizations.<\/p>\n<p>The new Data Profiling capabilities can be enabled from the Global Options dialog in the Power Query Editor toolbar.<\/p>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/5.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter size-full wp-image-7214\" height=\"683\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/5.png\" width=\"2990\" srcset=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/5.webp 2990w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/5-300x69.webp 300w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/5-1024x234.webp 1024w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/5-768x175.webp 768w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/5-1536x351.webp 1536w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/5-2048x468.webp 2048w\" sizes=\"auto, (max-width: 2990px) 100vw, 2990px\" \/><\/a><\/p>\n<p>From the Global Options dialog, users can configure which Data Profiling capabilities they would like to enable, including inline Column Quality and Value Distribution information in the Data preview, as well as the Column Profile Details pane. Users can also select whether they would like these data profiles to be calculated on top of the top 1,000 rows of data or over the entire dataset.<\/p>\n<p>After enabling these features, they can be accessed from the main Power Query Editor surface, contextual to the table columns in the data preview.<\/p>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/7.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter size-full wp-image-7216\" height=\"1920\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/7.png\" width=\"3000\" srcset=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/7.webp 3000w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/7-300x192.webp 300w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/7-1024x655.webp 1024w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/7-768x492.webp 768w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/7-1536x983.webp 1536w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/7-2048x1311.webp 2048w\" sizes=\"auto, (max-width: 3000px) 100vw, 3000px\" \/><\/a><\/p>\n<p>The Data Profiling charts are interactive and allow users to take action directly from them via Smart Recommendations offered to users on hover \u2013 for example, to remove errors or duplicate values from the inline column quality details, or to exclude a specific value from the Value Distribution chart in the Column Profiles details pane.<\/p>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/8.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter size-full wp-image-7217\" height=\"1920\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/8.png\" width=\"3000\" srcset=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/8.webp 3000w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/8-300x192.webp 300w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/8-1024x655.webp 1024w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/8-768x492.webp 768w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/8-1536x983.webp 1536w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/8-2048x1311.webp 2048w\" sizes=\"auto, (max-width: 3000px) 100vw, 3000px\" \/><\/a><\/p>\n<h3>Query Parameters<\/h3>\n<p>With the new Query Parameters feature, users can now easily define one or multiple parameters to be used in their dataflows. Users can define new parameters by using the \u201cManage Parameters\u201d dialog in the Power Query Editor, accessible from the toolbar.<\/p>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/9.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter size-full wp-image-7218\" height=\"770\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/9.png\" width=\"2994\" srcset=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/9.webp 2994w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/9-300x77.webp 300w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/9-1024x263.webp 1024w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/9-768x198.webp 768w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/9-1536x395.webp 1536w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/9-2048x527.webp 2048w\" sizes=\"auto, (max-width: 2994px) 100vw, 2994px\" \/><\/a><\/p>\n<p>From the Manage Parameters dialog, users can create new parameters and specify metadata and settings for each parameter:<\/p>\n<ul>\n<li><strong>Parameter Name<\/strong>.<\/li>\n<li><strong>Parameter Description<\/strong>: This will be displayed next to the parameter name in downstream experiences, and helps the user who is specifying the parameter value to better understand the purpose and semantics of this parameter.<\/li>\n<li><strong>Optional vs. Required<\/strong>: Users can specify whether a certain parameter is optional or a value for that parameter must be specified (required).<\/li>\n<li><strong>Parameter Type<\/strong>: This field applies a Data Type restriction on the input value for the parameter. For instance, users can define a parameter of type Text, or Date\/Time. Users can also specify Any type for more flexibility.<\/li>\n<li><strong>Parameter Accepted Values<\/strong>: In addition to Data Type restrictions, users can apply further restrictions to the allowed values for a given parameter. For instance, users could specify that the Data Type for a parameter is Text and restrict the acceptable values to a static list of Text values. Users will then be able to pick one of these values when specifying the parameter value to use. Users can preconfigure Accepted Values as a static list, or any value of the expected type, or dynamically binding the list of Accepted Values for a parameter to the output of another query returning a list of values. This enables dynamic sets of options to be displayed to the user, maybe even based on their selection for another parameter. A typical example for this would be making a \u201cCity\u201d parameter change the list of values to select from, based on another parameter that allows users to specify a \u201cState\u201d.<\/li>\n<li><strong>Default Value<\/strong>: This setting allows the Parameter creator to specify what the default value or selection should be for the user specifying the parameter value.<\/li>\n<li><strong style=\"font-size: 1rem;\">Current Value<\/strong><span style=\"font-size: 1rem;\">: This setting allows users to specify the value for this parameter in the current dataflow.<\/span><\/li>\n<\/ul>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/10.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter size-full wp-image-7219\" height=\"1080\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/10.png\" width=\"1077\" srcset=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/10.webp 1077w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/10-300x300.webp 300w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/10-1021x1024.webp 1021w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/10-150x150.webp 150w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/10-768x770.webp 768w\" sizes=\"auto, (max-width: 1077px) 100vw, 1077px\" \/><\/a><\/p>\n<p>Once a parameter has been created, it can be accessed and modified from the Queries pane. Additionally, users can create and bind parameters to input fields from specific dialogs in Power Query, including connector dialogs (e.g. Server), Filter Rows dialog and more.<\/p>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/11.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter size-full wp-image-7220\" height=\"1235\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/11.png\" width=\"1929\" srcset=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/11.webp 1929w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/11-300x192.webp 300w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/11-1024x656.webp 1024w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/11-768x492.webp 768w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/11-1536x983.webp 1536w\" sizes=\"auto, (max-width: 1929px) 100vw, 1929px\" \/><\/a><br \/>\n<a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/12.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter size-full wp-image-7221\" height=\"1537\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/12.png\" width=\"2567\" srcset=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/12.webp 2567w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/12-300x180.webp 300w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/12-1024x613.webp 1024w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/12-768x460.webp 768w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/12-1536x920.webp 1536w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/12-2048x1226.webp 2048w\" sizes=\"auto, (max-width: 2567px) 100vw, 2567px\" \/><\/a><\/p>\n<h3>Function Authoring UX<\/h3>\n<p>With this update, we\u2019re making it extremely easy to author functions in Power Query without writing a single line of code!<\/p>\n<p>Users can now create a function based on an existing query by using the \u201cCreate Function\u201d option in the query context menu.<\/p>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/13.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter size-full wp-image-7222\" height=\"913\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/13.png\" width=\"1827\" srcset=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/13.webp 1827w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/13-300x150.webp 300w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/13-1024x512.webp 1024w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/13-768x384.webp 768w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/13-1536x768.webp 1536w\" sizes=\"auto, (max-width: 1827px) 100vw, 1827px\" \/><\/a><\/p>\n<p>This option brings up a dialog that allows users to provide a function name. If the original query was bound to any query parameters, those query parameters will become function input parameters, inheriting the same name, type, description and restrictions from the original query parameter.<\/p>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/14.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter size-full wp-image-7223\" height=\"1533\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/14.png\" width=\"2565\" srcset=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/14.webp 2565w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/14-300x179.webp 300w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/14-1024x612.webp 1024w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/14-768x459.webp 768w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/14-1536x918.webp 1536w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/14-2048x1224.webp 2048w\" sizes=\"auto, (max-width: 2565px) 100vw, 2565px\" \/><\/a><\/p>\n<p>After that, the new function query is available for reuse within the Power Query Editor.<\/p>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/15.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter size-full wp-image-7224\" height=\"808\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/11\/15.png\" width=\"2993\" srcset=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/15.webp 2993w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/15-300x81.webp 300w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/15-1024x276.webp 1024w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/15-768x207.webp 768w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/15-1536x415.webp 1536w, https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/15-2048x553.webp 2048w\" sizes=\"auto, (max-width: 2993px) 100vw, 2993px\" \/><\/a><\/p>\n<p>That\u2019s all for this month! We hope that you find these feature valuable.<\/p>\n<p>We\u2019re looking forward to your feedback and suggestions that you might have in order to make Dataflows even better, please vote for them in our\u00a0<a href=\"https:\/\/powerusers.microsoft.com\/t5\/Power-Apps-Ideas\/idb-p\/PowerAppsIdeas\/label-name\/dataflows\/\">Power Apps Ideas Forum\u2019s Dataflows category<\/a>.<\/p>\n<p>Learn more:<\/p>\n<ul>\n<li>Power Query: <a href=\"https:\/\/www.powerquery.com\">www.powerquery.com<\/a><\/li>\n<li>Dataflows in Power Apps:\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/common-data-service\/create-and-use-dataflows\">https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/common-data-service\/create-and-use-dataflows<\/a><\/li>\n<li>Dataflows in Power BI:\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/service-dataflows-overview\">https:\/\/docs.microsoft.com\/en-us\/power-bi\/service-dataflows-overview<\/a><\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Over the past few weeks we have released several new features in Dataflows, allowing users to seamlessly ingest and prepare data that can be widely reused by other users across the Power Platform, including lots of new data connectors, data transformations and other Power Query enhancements.<\/p>\n","protected":false},"author":182,"featured_media":7217,"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":[3424],"job-role":[],"product":[3473],"property":[],"topic":[],"coauthors":[2166],"class_list":["post-7209","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","audience-it-professional","content-type-news","product-power-apps"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What&#039;s new in Dataflows in Power Apps this month? - 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:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What&#039;s new in Dataflows in Power Apps this month? - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Over the past few weeks we have released several new features in Dataflows, allowing users to seamlessly ingest and prepare data that can be widely reused by other users across the Power Platform, including lots of new data connectors, data transformations and other Power Query enhancements.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/whats-new-in-dataflows-in-power-apps-this-month\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-06T15:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:01:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/8.png\" \/>\n\t<meta property=\"og:image:width\" content=\"3000\" \/>\n\t<meta property=\"og:image:height\" content=\"1920\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Miguel Llopis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Miguel Llopis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/\"},\"author\":[{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/miguel-llopis\/\",\"@type\":\"Person\",\"@name\":\"Miguel Llopis\"}],\"headline\":\"What&#8217;s new in Dataflows in Power Apps this month?\",\"datePublished\":\"2019-11-06T15:00:00+00:00\",\"dateModified\":\"2025-06-11T15:01:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/\"},\"wordCount\":1544,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/8.webp\",\"keywords\":[\"Dataverse\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/\",\"name\":\"What's new in Dataflows in Power Apps this month? - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/8.webp\",\"datePublished\":\"2019-11-06T15:00:00+00:00\",\"dateModified\":\"2025-06-11T15:01:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/#primaryimage\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/8.webp\",\"contentUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/8.webp\",\"width\":3000,\"height\":1920},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What&#8217;s new in Dataflows in Power Apps this month?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cm-edgetun.pages.dev\/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:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/cm-edgetun.pages.dev\/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:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/person\/6251391b226568dced2079fdc0eccc12\",\"name\":\"Miguel Llopis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/4658d23d1c78d434d571261ae820d24327cd861390563d156834208039471d0f?s=96&d=mm&r=gd905e082f13e06f06dbbd215315601e8\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4658d23d1c78d434d571261ae820d24327cd861390563d156834208039471d0f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4658d23d1c78d434d571261ae820d24327cd861390563d156834208039471d0f?s=96&d=mm&r=g\",\"caption\":\"Miguel Llopis\"},\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/millopis\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What's new in Dataflows in Power Apps this month? - 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:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/","og_locale":"en_US","og_type":"article","og_title":"What's new in Dataflows in Power Apps this month? - Microsoft Power Platform Blog","og_description":"Over the past few weeks we have released several new features in Dataflows, allowing users to seamlessly ingest and prepare data that can be widely reused by other users across the Power Platform, including lots of new data connectors, data transformations and other Power Query enhancements.","og_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/whats-new-in-dataflows-in-power-apps-this-month\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2019-11-06T15:00:00+00:00","article_modified_time":"2025-06-11T15:01:21+00:00","og_image":[{"width":3000,"height":1920,"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/8.png","type":"image\/png"}],"author":"Miguel Llopis","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Miguel Llopis","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/#article","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/"},"author":[{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/miguel-llopis\/","@type":"Person","@name":"Miguel Llopis"}],"headline":"What&#8217;s new in Dataflows in Power Apps this month?","datePublished":"2019-11-06T15:00:00+00:00","dateModified":"2025-06-11T15:01:21+00:00","mainEntityOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/"},"wordCount":1544,"commentCount":0,"publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/#primaryimage"},"thumbnailUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/8.webp","keywords":["Dataverse"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/","name":"What's new in Dataflows in Power Apps this month? - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/#primaryimage"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/#primaryimage"},"thumbnailUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/8.webp","datePublished":"2019-11-06T15:00:00+00:00","dateModified":"2025-06-11T15:01:21+00:00","breadcrumb":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/#primaryimage","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/8.webp","contentUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/11\/8.webp","width":3000,"height":1920},{"@type":"BreadcrumbList","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/11\/06\/whats-new-in-dataflows-in-power-apps-this-month\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"What&#8217;s new in Dataflows in Power Apps this month?"}]},{"@type":"WebSite","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cm-edgetun.pages.dev\/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:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/cm-edgetun.pages.dev\/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:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/person\/6251391b226568dced2079fdc0eccc12","name":"Miguel Llopis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4658d23d1c78d434d571261ae820d24327cd861390563d156834208039471d0f?s=96&d=mm&r=gd905e082f13e06f06dbbd215315601e8","url":"https:\/\/secure.gravatar.com\/avatar\/4658d23d1c78d434d571261ae820d24327cd861390563d156834208039471d0f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4658d23d1c78d434d571261ae820d24327cd861390563d156834208039471d0f?s=96&d=mm&r=g","caption":"Miguel Llopis"},"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/millopis\/"}]}},"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:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/7209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/182"}],"replies":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=7209"}],"version-history":[{"count":1,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/7209\/revisions"}],"predecessor-version":[{"id":130740,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/7209\/revisions\/130740"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media\/7217"}],"wp:attachment":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=7209"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=7209"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=7209"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=7209"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=7209"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=7209"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=7209"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=7209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}