Functions in Microsoft Dataverse
A few days ago Microsoft announced the creation and use of function in Microsoft Dataverse (currently in preview). Functions use Power Fx to execute a set of commands within Dataverse that run on the server-side.
Category: Canvas Apps
SQL Server Environment Variables in Power Apps
A few weeks ago Microsoft announced the availability of SQL Server Environment variables which will be able to support your Power Apps deployments as part of an ALM Process
YAML Code view in Canvas Apps
With the Microsoft announcement of Code view in Power Apps Studio, developers can not view and use the source code in YAML format and Power FX format. This allows selection of particular controls and see the YAML code that makes up that control
Data Workspaces in Maker Portal
For IT pros that have worked with database modelling for much of their career, the latest feature available in the Maker Portal, Data Workspaces will be a great tool to start working with.
No more quotes for Power Fx column names
Until recently, there would be a certain subset of functions were you would need to enter the names of the column within double quotes. Starting with the latest version of Canvas Studio (version 3.24042), there will be a syntax change as to how the column names will be displayed within function arguments.
Complex Exporting to Excel using Power Automate
While working on a recent project to replace a low code platform with the Power Platform, one of the requirements that we had was to replace some of the Excel export and import functionalities that the existing system had to be able to send large Excel files into various other systems to be analyzed and consumed.
Calling Dataverse actions directly in Power Fx
Until recently, if we wanted to call a bound or unbound action from a Canvas app, we would have to create a Power Automate flow that would be triggered from the Canvas App and would then call a bound or unbound action from Power Automate. Not any more…
Cards for Power Apps are solution aware
Although cards for Power Apps were made Generally Available in March 2023, they were not available from within solutions, which made the deployment process more complex. Last week, on November 2nd, Microsoft announced that Cards for Power Apps have become solution aware.
AAD Users filtering limitations and workarounds
The AAD Users virtual table that was added to Dataverse has been a lifesaver for a lot of applications, especially when using Power Apps licensing as they provide the full subset of Active Directory users. When using Power Apps licensing, not all users are automatically synched to the Users table, so that is a great addition.
Modern Controls for Power Apps
through an opt-in preview. These controls are based on Microsoft’s Fluent design system, which most of the Microsoft product experiences follow (such as Microsoft Office and Microsoft Teams).