Share your ideas and vote for future features

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

Currently we have two types for time in manifest( DateAndTime.DateOnly and DateAndTime.DateAndTime), however they are about same. I would like to declarate only one DateTime field in my control instead two. It makes setup step for user easier and compomponent more flexible. For example, we have start time and end time, and that is mean we need four fields, because 2x2 ... View more

I am trying to extract the entire P2P calls info from MS Teams in one single File and save them somewhere like Azure Blob. Calls info like: Call Start time Call Endtime Person Call type etc... I’ve tried to use MS graph and Logic App to solve this problem but with the GET Request from MS Graph, they can only export one Call's info with single calls-ID. What I need is to export all the call info at one time and save them in one file.   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

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

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

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

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

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

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

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

Currently, Power App Dataflow works fine while loading lookup columns by defining a single column Alternate Key. However, if we add multiple fields/columns in a single Alternate Key, Dataflows does not support it. Please add this functionality.   Refer below scenario for reference -  https://powerusers.microsoft.com/t5/Power-Platform-Integrations/Dataflow-errors-with-Alternate-Keys-of-multiple-columns/td-p/756177   ... View more

Apparently the Auto-map button works only for built-in CDM tables but I wouldn't know because I don't use them.  One think I can say is that it never works for custom tables. (maybe because of the publisher's prefix?).  It might be considered a bug but I'm publishing it here as an idea because it will greatly improved the current auto-map feature.     see also : Solved: Re: Auto-map never works in dataflows, doesn't it? - Power Platform Community (microsoft.com)   Thank you --mo ... 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

currently it is possible to map source columns in the Field mapping of dataflows to fields of a dataverse-table (aka CDS-entity) with data-type Text, Date,  Floating Point Number, etc- but it is not possible to map to fields of data-type Lookup. Please add support for fields of data-type Lookup to the Field mapping of dataflows. ... 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

Currently we need to manually refresh a dataflow or set it for a scheduled refresh.   However, it would be great if we can do so via a Rest API. By that we can programatically make an HTTP post request to invoke the API for the dataflow refresh   The similar functionality is available for Power BI dataflows : https://docs.microsoft.com/en-us/rest/api/power-bi/dataflows/refreshdataflow   It would be great to have the same feature for Power Apps dataflows as well.   Thanks, Raj ... 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