When specifying a Datavers column in a canvas app, an error occurs if the column display name contains a Full-width Space. Previously there were no errors.   Correct so that the error does not occur even if the display name contains Full-width Space. ... View more

Apparently it is by design of Adxstudio Portals / Dynamics Portals / Power Apps Portals that: "If EntityList has ViewDetails and Edit item action configured then the hyperlink will work similarly to the edit button. And if there is only the ViewDetails button configured then it will work as a ViewDetails item action.".   So Options configuration of a List could be: . You see two options resulting in a Portal User experience of: However the default clickable column will now go to the Edit page instead of the View page. We can debate if this is good or it could be different --> this idea is to let a Citizen Developer configure the default clickable column action. ... View more

Dear Microsoft Support,   for security purposes it would be helpful to also activate OAuth 2.0 on PowerApps Custom Connectors even if you use the local datagateway option.   Currently if you don't use local data gw, you're able to select the OAuth 2.0 option on the security tab. After activating the "Use Local Data Gateway" Option on the first tab of the custom connector, you're only allowed to use Windows or Basic Auth.   Without this option, effort to support security standards on local APIs can be significantly higher for a low/no code developer to integrate local data on a PowerApp solution.   Best regards, Julius ... View more

I would like to suggest that the Power Apps custom forms clear the data cache once an item has been submitted to a SP list. Currently, while in the same browser session, opening a series of forms first displays the data from the form previously opened. Power Apps forms are the only ones I have seen do this. This is the preferred product to replace InfoPath and yet, InfoPath does not display prior data when switching from one item to another, nor do the built in data entry forms, Nintex and others. I would like to request that the forms data be cleared from the cache when the form is submitted, saved, or cancelled. When opening a form, New, to Edit or View, users should never see data from any other record than the one they are engaging. ... View more

Could you please allow "Microsoft PowerApps Office Add-in" to be installed offline? According to our system department, it seems that installation from the Office Store is not permitted due to security reasons, and I requested that it be available for offline installation.   ... View more

In the modern form editor, when adding a subgrid component, you are by default presented with the option to select any table. To only show tables that have an actual relationship to the current form's table, you need to tick the box "show related records". In practice you ALWAYS need to select this. Ever since 2011 when the subgrid feature was introduced, I don't think I've ever ran into a requirement to show records from another table on the form that have absolutely no connection with the current record. I believe ~99% of app makers are therefore required to now remember to tick the filter box, so that they don't need to browse through all the thousand tables within the environment. Besides, since there is now a table named "[Deprecated] Dynamics Customer Service Analytics" in every environment, it is alphabetically sorted to be the first thign every app makers sees in the subgrid configuration experience. All of this could be easily hidden if the "show related records" filter would be on by default. ... View more

Hi,   Since we use Business Process Flow (BPFs) in Model-Driven Apps for a while now, I think it's ideal to be able to mark fields as Read-Only in the Editor itself while adding Data Steps. Currently, we can only make fields Required or Optional but not Read-Only on the BPF This will help us save the effort to write JS for making this fields Read-Only.  Idea is to have these field be populated from elsewhere and not change on BPF directly be end user.  Hope this helps! Thanks in advance. ... View more

I would like to input data in an Excel like grid control like the one below. Note that this is not a pivot table because there is only one record at the intersection of a production type and a month (it's a matrix). It would be nice if users could copy paste the values from Excel sometime. No control exists in Power Apps to input data in this way. The above grid is an example. In my apps I have more than 12 months and more than 2 Production type. The row name and column name have to be generated based on two different lists (Month list and Production Type list) The final table, where I write data at the end is a normal database table with a primary composite key on [Day] and [ProductionType]. You can see this three-column table below. The three columns are [Month], [ProductionType] and [Production].   Table   ... View more

The formula bar in the Power Apps studio already does syntax highlighting, IntelliSense and has options to format/beautify Power Fx formulas.   It would be great to have similar capabilities in Visual Studio Code, as formulas are recognized as Plain Text today. Making edits or reviewing code within VSCode is something professional developers often do. As Power Fx has moved to an open-source language, this would also be useful for use cases beyond Power Apps. ... View more

When multiple values are selected from the list of references to be displayed by a condition, the selected values are displayed correctly if they are not the first value, but if the first value is removed, all are hidden. I would like the correct value to be displayed in the custom form even when the first value is opened.   Create the following listings in SharePoint and add a title column and a YESNO column. When the YESNO column is checked, add an Aggregate Values (calculated based on other columns) column that displays the values in the Title column.   Create a SharePoint list that references a column of aggregate values (results of a calculation based on other columns) and allows multiple selections. If I create a custom form, select multiple values, and then uncheck the first item in the referenced list, all the selected values are shown in the view of the referenced SharePoint list, but are hidden in the custom form. <View of Referenced List>.   <reference custom form>.   However, when an item other than the first in the list of references is released, it is displayed normally. <View of list of references>.   <Referer's custom form>.   I would like all selected items to be displayed even when the first item A is unchecked.   ... View more

To interact with relational databases like SQL Server, I think that standard data manipulation language (DML) function must be added in Power Apps to interact efficiently with databases. Instead of offering only "Patch", a kind of MERGE, all other DML function must be offered: INSERT UPDATE DELETE SELECT MERGE. Actually, to do efficient insert in an SQL Server database, we have to send JSON to PowerAutomate and call a Store Proc with the JSON as parameters. This is really cumbersome. The PowerApps way of doing this is by using "Patch" but this is really inefficient. (https://powerusers.microsoft.com/t5/Building-Power-Apps/Inserting-records-from-PowerApps-to-SQL-Server-Azure-SQL/m-p/1565410) ... View more

We can already drive most security configuration from outside of Dataverse in Azure Active Directory (AAD) through group teams, but we can't assign a business unit to a user without a manual intervention on the environment.   Workarounds exist, but they involve implementing custom logic.   Business unit assignment to users is a crucial piece of Dataverse security modeling, as the records created by a user are by default owned by the user's business unit. Also, as all users are created in the root business unit, this means that without any configuration, all records are by default owned by the root business unit. Ask is to support user business unit assignment from Azure AD security groups. ... View more

Currently the language pack is limited. For example we had a use case than required it-ch ->this is the swiss italian language and we noticed it's missing.  Could we extend the language pack to include different regions? We have countries with more then one language spoken. For example in Switzerland we have 4 official languages and a lot of people speak only 1 of them.  It will be really nice to have more granularity: For example: it-CH ->Italian fr-CH ->French de-CH -> Deutch   ... View more

I just found out that the command pac paportal upload XXX only adds new files and does not do a differential and subsequent removal of any old code that is in the target environment.    I would like to suggest the addition of an -o overwrite flag similar to that on pac paportal download XXX. This would essentially make portal uploads work like managed solutions. As we are uploading an entire website as code it should not be too difficult to work out the diff and delete out the records that do not form part of the current website content.   This is really import for healthy and secure DevOps practices.   ... View more

Under the current scenario, any solution that uses a Pen Input will always show a Medium severity warning in the solution checker.   The rule name triggering this is "app-include-alternative-input".    It recommends that a TextBox be included as an alternative input method for accessibility purposes. However, there is no way way for the checker to know whether a TextBox has been included on the screen for this purpose.   There is a problem with the expected behaviour as a developer should be able to use a Pen Input control without always then having a Medium severity warning raised in the solution.   Proposal: Add an extra property to the Pen Input control that allows a user to reference which TextBox (if any) has been made available for alternative input. Then, update the logic of the "app-include-alternative-input" rule to only display a warning if this property is empty. ... View more

If we display filter conditions, we will see items other than the ones we want to fix. We would like the user to be able to see only the views with fixed filter conditions. ... View more

With the current display, users who want to use only Power Apps have access to other applications. If the App Launcher could be hidden, this concern would be eliminated. ... View more

Please implement the function to retain the app ID of the canvas app even after the environment is restored.   Restoring the environment will change the app ID of the canvas app. If you have the app ID or his web link for the app embedded in the flow or app, it will not work properly after the environment is restored. The behavior of retaining the app ID of the canvas app after the environment is restored is convenient for all users.   Title : Are Power Apps app identifiers the same after backup and restore operations? URL : https://docs.microsoft.com/en-us/power-platform/admin/backup-restore-environments#are-power-apps-app-identifiers-the-same-after-backup-and-restore-operations > No for canvas apps. The app ID for a canvas app is different in a restored environment than the ID value when an environment was backed up. ... View more

Refer to the Microsoft Documentation that mentioned that “client_credentials” grant type is not supported: https://docs.microsoft.com/en-us/connectors/custom-connectors/connection-parameters   This is needed for us to be able to use PingFed Oauth Is there a plan to add the ability to pass this grant_type in the future? If so, what is that timeline for that to be implemented?  I opened a support ticket (2204220040005522) with Microsoft support on the same issue asking for a timeline to add this and was asked to open an idea on this.    Refer to the attached PDF for detailed screenshots of issue.  ... View more