Please implement a function to skip the target query and execute another query when an error occurs in one or more queries in a data flow.   When multiple queries are configured in a single dataflow, if an error occurs in one or more of the queries, the message "No table updated" will be displayed. This behavior is inconvenient because processing of queries that have not encountered errors will not be executed either. Therefore, please implement a feature that allows the rest of the query to be executed even if the query encounters an error. ... View more

It would be great if PowerApps Canvas had a feature for galleries to be able to drag data items in order to reorder rows/ columns or drag data items between different galleries.    Such features would make it much easier to build out interactive Kanban boards in PowerApps Canvas. ... View more

Allow the Patch function to work with Attachments so that a user can patch an attachment to a SharePoint List using a form. ... View more

Our design team and UX designers are mostly familiar with Figma to design component for an App. However, our Dev team would like to use Power App to develop the app in the cloud.. Given current features in PowerApp, there is no easy way to import already built Figma components into PowerApp for the dev to add functionality to the component.. Please create a plug and play solution to add Figma components/layers (third party components) into PowerApp easily.. Given this new feature in PowerApp (Figma component import), our design and dev team can work together within PowerApp environment, without replicating the elements of an already built components, which would speed up the App building process in PowerApp by a lot... Thanks, ... View more

Hi lovely community,   especially when building dataflows, theres always the case to cancel them (e.g. if you know that a dataflow will probably take more than 2 hours). Of course I know to preparing Dataflows via Power Query in Power Bi or Excel, but of course I wanna see the result of my query in Dataflow especially for some mystery error messages in Excel refresh protocol...:)   It would be great to be able to intervene here as a user in order to be able to cancel the dataflow.   BR, Sven ... View more

Would like to create an environment variable for a solution and then use that variable inside a dataflow query.  ... View more

While the PowerShell-module "MicrosoftPowerBIMgmt.Data" contains cmdlets for the management of dataflow ( Get-PowerBIDataflow, Export-PowerBiDataflow), the PowerShell-modules for the Power Platform  ("Microsoft.PowerApps.Administration.PowerShell" / " Microsoft.PowerApps.PowerShell")  do not contain any cmdlet that allows the managemet of dataflows.   Please add PowerShell-cmdlets to the PowerShell-modules for the Power Platform, that allow the management of dataflows in the Power Platform, e.g.  Get-AdminPowerAppDataflow. ... View more

Power Apps Dataflows needs to support upsert (insert and/or update). Currently Dataflows only supports insert/create and delete operations (if enabled). This means that every time a Dataflow is ran will insert duplicate records. If an alternate key is defined then those records will fail during the run because of duplicate key. If delete records is enabled, then all records will be deleted and created per run. There are several keys issues with this: Upon delete, all history and auditing history are lost Harder to determine records that changed after a Dataflow run. Modified On will always be the Created On  Unnecessary triggers (i.e. plugins, flows, workflows, etc) could be invoked upon create and/or delete Performance: additional redundant delete and create transactions are executed when nothing changed ... View more

Would be very handy to have the ability to trigger Dataverse Dataflow from Power Automate. Sometimes the Dataflow refresh/scheduled run  do not satisfy the requirements and the trigger needs to run based on some business logic such as when a file is uploaded or when an event occurs in the system.   ... View more

Currently a CDS Dataflow can have only one owner - the person who created the dataflow. If you use this technique to get data into CDS on a schedule you want to be able to share the ownership with multiple people, like you do with Apps and Flows.    Please add the ability to share ownership. Please add the ability for environment admins to see all Dataflows in their environment. ... View more

Dataflows is such a nice addition to loading data into CDS and Azure data lake. However, there is a limitation of importing 6000 records per 300 seconds. Users get below error when exceeding the limit.   Number of requests exceeded the limit of 6000, measured over time window of 300 seconds.   The above limit may sound reasonable for third party API integrations but not suitable for dataflows which deal with importing large chunks of data. Since dataflow is an inherent feature of the product, there should not be any throttling limits in the first place. As there is no source code available to tweak, we neither control exceptions nor delay the execution as per the API limits.   Please upvote and let's see what Microsoft has to say about it. ... View more

A simple Time Picker input. 12 or 24 hour option.   But if you want to get fancy: Maybe have it attached to the Date Picker as well. Then based on the DateTimeFormat selected, it adjusts the way you pick. Current Date Picker already allows you to format date as .ShortTime as well as .ShortTime24. Which makes no sense.. each date is defaulted at 12:00AM or 0:00. Just a tease.   Stuck using a series of dropdowns at the moment 😕 Functional but not as pretty. ... View more

It would be great to show a notification on the Dataflows page in the maker portal when the Dataflow / Power Query server is experiencing problems. Example:     Presently, when dataflows are running unusually slowly or failing mysteriously, there is no way to know if these issues are due to server-related problems or problems with dataflow itself (mashup code or data source problems). By showing a notification,  makers would not uselessly troubleshoot dataflows when the the issue is out of their control (ie, problems with servers).   There is some precedent to this... The Azure Service Health portal in Azure is used to this effect for issues relating to Azure.  ... View more

When running a DataFlow, it should be possible to select the Application User for "run as". The normal users in Dynamics don't have enough API's pr 24 hours.      While the application user has 100,000 SSIS integrations with KingsWaySoft can do Application User, and would by that be more logical to choose for a larger scale deployment, even though I would prefer to user DataFlow because of simplicity 🙂 ... View more

OAuth 2.0 Resource Owner Password Credentials (ROPC), also known in Postman as the 'Password Credentials' OAuth 2.0 Grant Type. See here for more information: https://docs.microsoft.com/en-us/azure/active-directory/develop/v2-oauth-ropc The current allowed method from the Generic OAuth 2.0 - Generic Oauth 2 Identity Provider only allows for: Client id & Client secret. This does not grant access to OAuth 2.0 APIs that use a 'Password Credentials' method, using 'Username' and 'Password' This is a necessary feature addition to Custom Connectors enable developers to use API authentication that have expiration on their bearer tokens, and can only be logged in via Username and Password.   Original Thread: https://powerusers.microsoft.com/t5/Building-Power-Apps/OAuth-2-0-Resource-Owner-Password-Credentials-on-Custom/m-p/490451 ... View more

Documentation states the following limitation:    Using gateways in dataflows is only supported for people with  Admins  permissions.  Can use  and  Can use + share  permissions levels are not currently supported.   Please lift this limitation because it basically kills every ambition to move data into CDS when there are more than an handful of users in the company. ... View more

Hi!   Like already asked for here: https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Dataflows-Authentication-using-API-Key-or-OAuth-2-0/m-p/568602#M5297 I would like to be able to push some big data via Rest API (json) into my Common Data Service. I'm already able to do that with Power Automate, but here I just can do it for each record via slowly "Apply to each" loop (think about running time with over 10000 records..) and without nice Power Query options.   So I can image there some different options:   - Power Automate Flow: Flexible triggered REST APi with "Upload JSON records" CDS Action incl. Power Query ETF process - Dataflow Web API with API Key / OAUTH2.0 Authentification - Dataflow Custom Connection Option   BR, Sven ... View more

As per my query I would suggest the ability to link new contact Entity records to existing Account Entity records during a dataflow import.   I understand that this can be accomplished via a manual import from Data Management in the PowerApps Admin Center, however this lacks the Transform and schedule functionality of dataflows. ... View more

Please improve the error messaging when a Dataflow fails on setup.    I spent over 3hr attempting to debug a Dataflow error with the only message being an "unexpected error" has occurred. After reviewing the network logs within Edge I noticed the far more helpful error, namely that I had a leading or trailing space in one of the entity headers.    This was a 5min fix to 3hr due to a lack of actionable error messaging within the UI experience.          ... View more