Building Power Apps Archives - Microsoft Power Platform Blog Innovate with Business Apps Wed, 22 Jan 2025 00:09:41 +0000 en-US hourly 1 SQL Server environment variables available for Power Apps http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/sql-server-environment-variables-available-for-power-apps/ http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/sql-server-environment-variables-available-for-power-apps/#respond Wed, 22 Jan 2025 00:09:39 +0000 We are excited to announce that SQL Server environment variables (Entra) for Power Apps support is currently rolling out and will be in Preview regions by Jan 22 and in all regions – including sovereign – by Feb 3. SQL Server environment variables (Entra) for Power Apps will save you time moving your solutions from

The post SQL Server environment variables available for Power Apps appeared first on Microsoft Power Platform Blog.

]]>
We are excited to announce that SQL Server environment variables (Entra) for Power Apps support is currently rolling out and will be in Preview regions by Jan 22 and in all regions – including sovereign – by Feb 3.

SQL Server environment variables (Entra) for Power Apps will save you time moving your solutions from one environment to another. For example, from an environment used for dev or test to a different environment used for test or production. Manually create environment variables in your solution or set a switch in your app to auto-create them for you when you add a data source to your app while in your solution. Note that this feature is specifically for Entra. Power Apps with shared connections (e.g., SQL Auth) continue with connection references.

There are two environment variables to set for SQL connections: server and database. The database environment variable depends on the server environment variable. First you create an environment variable for your server. Once that is created you can create an environment variable for the database that attaches to the server environment variable.

A screenshot of a computer
A screenshot of a computer

Use an environment variable by selecting to create data source and instead of creating a new server database combo, use the ‘Advanced’ tab to select the environment variable to bind to the controls in your app.

A screenshot of a computer

Use SQL Server environment variables (Entra) to easily enable professional deployment patterns. See the documentation for this feature for an in-depth discussion: Use environment variables in Power Platform solutions – Power Apps | Microsoft Learn

The post SQL Server environment variables available for Power Apps appeared first on Microsoft Power Platform Blog.

]]>
http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/sql-server-environment-variables-available-for-power-apps/feed/ 0
GA announcement: 6 additional modern controls in Canvas!  http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/ga-announcement-6-additional-modern-controls-in-canvas/ http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/ga-announcement-6-additional-modern-controls-in-canvas/#respond Fri, 17 Jan 2025 18:35:59 +0000 We are pleased to announce a significant milestone in the control’s modernization journey for Canvas. Today, we are announcing the general availability (GA) of the following modern controls: Text, Text input, Number input, Combobox, Date picker, and Form. Utilizing these controls enables creators to enhance their applications with faster, accessible, and modern elements.  Visit overview

The post GA announcement: 6 additional modern controls in Canvas!  appeared first on Microsoft Power Platform Blog.

]]>
We are pleased to announce a significant milestone in the control’s modernization journey for Canvas. Today, we are announcing the general availability (GA) of the following modern controls: Text, Text input, Number input, Combobox, Date picker, and Form. Utilizing these controls enables creators to enhance their applications with faster, accessible, and modern elements. 

Visit overview of modern controls to learn more about all modern controls.  

As part of this milestone, we would like to highlight the following: 

  • Text input has a trigger output property which can be used to control its onChange behavior 
  • Date picker’s custom format can be achieved by editing the “format” property with a valid date format, i.e. format = “dd/mm/YY”, format = “MM/YY” 
  • Combobox has a default limit of 800 records when using the dataset directly. However, makers can leverage PowerFX formulas in junction with the control’s searchText property to achieve dynamic searching and filtering on larger datasets, i.e.: Filter(<Dataset>, StartsWith(<Column name>, Combobox.SearchText)) 
  • When a Number input is used standalone (outside of a form), its value will never exceed the max or min boundaries and will always round values to either one of the closest boundaries 

We look forward to hearing your feedback and seeing the amazing apps that will be created with these controls!  

The post GA announcement: 6 additional modern controls in Canvas!  appeared first on Microsoft Power Platform Blog.

]]>
http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/ga-announcement-6-additional-modern-controls-in-canvas/feed/ 0
User defined functions, user defined types, and enhanced component properties move forward http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/user-defined-functions-user-defined-types-and-enhanced-component-properties-move-forward/ http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/user-defined-functions-user-defined-types-and-enhanced-component-properties-move-forward/#respond Thu, 16 Jan 2025 18:52:35 +0000 More Power Fx formula reuse! User defined functions can now call behavior functions with side effects and be chained. User defined types enable passing records and tables in and out of user defined functions and can type JSON and untyped objects. And enhanced component properties move to preview.

The post User defined functions, user defined types, and enhanced component properties move forward appeared first on Microsoft Power Platform Blog.

]]>
I’m pleased to announce updates that will make Power Fx formula reuse and maintenance easier than ever:

  • User defined functions (UDFs) can now include behavior functions with side effects, such as Set, Collect, Reset, and Notify. Declarative is always best, so use this facility only when you must. When you do, wrap the formula in { } and you can then use the ; (or ;;) chaining operator.
  • User defined types (UDTs) enable tables and records to be passed in and out of UDFs. UDTs also enable bulk conversion of JSON untyped objects to typed objects, particularly useful with web APIs. Welcome the new Type and RecordOf functions, an expanded role for the AsType and IsType functions, and a new parameter for ParseJSON.
  • Enhanced component properties (ECPs) have moved to preview. With any remaining feedback, we plan to take them to general availability in the next few months. ECPs enable the ability to share logic across apps through a component library.

This is the last major update to UDFs planned before we start down the road to general availability. UDTs will be on the same timeline. Now is the time to take this functionality through its final paces and provide feedback before the design is locked; please leave feedback in the community experimental features forum. Both features are experimental and require turning on these switches in Settings > Updates > Experimental:

A screenshot of a computer

Behavior UDFs

Named formulas depend on being declarative, something the system can defer and recalc based on changes in the app. They can’t have side effects, such as incrementing a variable, or this wouldn’t be possible. UDFs to date have built on top of named formulas by adding parameters, but still had to be declarative.

Obviously, that is limiting for an app. We need buttons, buttons that do important things like updating a database. We’d like to be able to put that logic in a UDF too. And now you can, by wrapping the UDF in curly braces:

CountUp( increment : Number ) : Void = {
    Set( x, x+increment );
    Notify( $"Count: {x}" );
};

This simple example will increment the global variable x and display a notification with the result each time CountUp(1) is called from, say, the OnSelect formula of a Button control.

This is a huge step for reuse and manageability. Now you can extract and parameterize your action logic and reuse it throughout your app, having only one source of truth for that logic that is easier to maintain.

For more information and examples, see Behavior user defined functions.

User Defined Types

User defined types enable UDFs to take in and return records and tables. Until now, UDFs were limited to scalar data types, such as Number, Text, DateTime, etc.

The new Type function is the key. Use it to define a named formula for a type, using the same syntax you would use for a literal record or table value. For example, imagine you had a table of paper sizes:

PaperSizes =
[ { Name: "A4", Width: 210, Height: 297 },
  { Name: "Letter", Width: 216, Height: 279 },
  { Name: "Legal", Width: 216, Height: 356 } ];

We can define types for a single paper as a special kind of named formula that uses the := assignment operator and Type function. The syntax used within the Type function is the same as the literal record values in the PaperSizes definition, with specific values replaced by their data type names:

PaperType := Type( { Name: Text, Width: Number, Height: Number } );

We can now use this type to pass a single paper size into a UDF:

PaperArea( Paper: PaperType ): Number = Paper.Width * Paper.Height;

And we can call our UDF with:

PaperArea( First( PaperSizes ) ) // returns the number 62370

We can define a type for a table, matching the type of PaperSizes:

MultiPaperType := Type( [ PaperType ] );

And then define a function to filter a table of paper sizes:

LargePaperSizes( Papers: MultiPaperType ) : MultiPaperType =
    Filter( Papers, PaperArea( ThisRecord ) > 70000

And then we can call it with:

LargePaperSizes( PaperSizes )
// returns [ { Name: "Legal", Width: 216, Height: 356 } ]

For more information and examples, see User defined types.

JSON and Untyped ❤️ UDTs

UDTs are great for UDFs. But they have another great use case: converting an untyped object to a typed object. Imagine that JSON was returned from a web API for another set of paper sizes:

MorePaperSizes =
"[ { ""Name"": ""A0"", ""Width"": 841, ""Height"": 1189 },
{ ""Name"": ""A6"", ""Width"": 105, ""Height"": 148 } ]";

You probably know that you can use the ParseJSON function to convert this to an Untyped object.

MoreUntyped = ParseJSON( MorePaperSizes )

From which you can extract individual elements from the JSON by casting them explicitly or implicitly at the point of use. But since the structure is untyped and potentially heterogenous, it cannot be used with functions such as AddColumns which requires a homogenous Power Fx table:

AddColumns( MoreUntyped, InStock, true ) // error

With UDTs, we can now convert this JSON directly to a Power Fx typed object by providing the type as the second parameter to ParseJSON:

MoreTyped = ParseJSON( MorePaperSizes, MultiPaperType )

And now we can add a column:

AddColumns( MoreTyped, InStock, true ) // OK

The IsType and AsType functions have also been overloaded to take an untyped object and type arguments. Web APIs that return an untyped object can now be easily converted to a typed object.

Feedback, please!

These are experimental features, and for good reason, we are still making changes. There are a lot of nuanced details with UDFs and UDTs we want to make sure we get right. We’d love to hear your feedback on how it works, please let us know in the community experimental features forum.

The post User defined functions, user defined types, and enhanced component properties move forward appeared first on Microsoft Power Platform Blog.

]]>
http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/user-defined-functions-user-defined-types-and-enhanced-component-properties-move-forward/feed/ 0
Unlock new possibilities by customizing Copilot chat in your apps with Copilot Studio (Preview) http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/unlock-new-possibilities-by-customizing-copilot-chat-in-your-apps-with-copilot-studio-preview/ http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/unlock-new-possibilities-by-customizing-copilot-chat-in-your-apps-with-copilot-studio-preview/#respond Thu, 09 Jan 2025 18:53:31 +0000 Microsoft Power Apps announces public preview of feature that allows customizing of in-app chat leveraging custom agent and Microsoft Copilot Studio.

The post Unlock new possibilities by customizing Copilot chat in your apps with Copilot Studio (Preview) appeared first on Microsoft Power Platform Blog.

]]>
Customization plays a vital role for organizations aiming to implement AI solutions at scale. With the help of Microsoft Power Apps and Copilot Studio, businesses can now design tailored and efficient experiences specific to each app, thereby boosting productivity and enhancing user satisfaction.

We are thrilled to announce the public preview of Copilot chat extensibility for model-driven apps. This new capability empowers partners and customers to tailor and extend the in-app chat, making it more context-aware and more aligned with organization’s unique needs.

Power Apps backed by Agent built in Copilot Studio

By harnessing the capabilities of Copilot Studio, you can incorporate additional topics, knowledge sources, connectors, custom prompt guide and more, greatly enriching your Copilot chat experience. A dedicated agent is provisioned when customizing the Copilot chat to ensure that each model-driven app has a tailored and context-specific AI assistant. This extensibility approach ensures that your AI solutions are not only more pertinent but also scalable in tackling your unique business challenges.

timeline

It’s easy to get started. Go to https://make.preview.powerapps.com in any early release environment. Open the model-driven app whose Copilot chat you want to customize. Click on the ellipsis (…) in the left navigation bar and then select Configure in Copilot Studio. You will be directed to Copilot Studio with the appropriate agent ready for customization.

The animation below demonstrates a use case where, with just a few clicks, makers can enhance Copilot chat capabilities to answer any question from the Power Apps official documentation. Additionally, they can easily customize the Copilot UI to assist end users through prompt guides.

End to end demo for Power Apps Copilot chat customization using Copilot Studio.

For more information about the capabilities being made available with this release, please refer to the Power Apps documentation under Customize Copilot chat using Copilot Studio. Please use Power Apps Pro Dev forum or reach out via LinkedIn for any feedback or questions.

The expansive potential of extensibility is truly exciting. We look forward to this journey with our partners and customers, as we incrementally roll out additional features.

Note: This feature is currently available in early release environments and will be gradually rolled out to all makers over the coming weeks.

The post Unlock new possibilities by customizing Copilot chat in your apps with Copilot Studio (Preview) appeared first on Microsoft Power Platform Blog.

]]>
http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/unlock-new-possibilities-by-customizing-copilot-chat-in-your-apps-with-copilot-studio-preview/feed/ 0
React and Fluent based virtual code components are now generally available http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/react-and-fluent-based-virtual-code-components-are-now-generally-available/ Wed, 04 Dec 2024 20:45:09 +0000 We are excited to announce the general availability of React and Fluent-based virtual code components in Microsoft Power Apps

The post React and Fluent based virtual code components are now generally available appeared first on Microsoft Power Platform Blog.

]]>
We are excited to announce the general availability of React and Fluent-based virtual code components. This feature allows customers and partners to leverage the Microsoft Power Apps platform libraries for React and Fluent, enabling the creation of a diverse set of code components without the need to package these libraries.

Key Benefits:

  • Unified Control Styling: Virtual controls with Fluent ensure consistent styling across multiple apps and app types.
  • Improved Performance: By eliminating the need for isolated React trees and smaller control bundle.
  • Simplified Development: The need to include React or Fluent libraries in individual component bundles is removed, streamlining the development process.
Diagram showing standard and virtual code components with them using individually packaged and shared platform libraries respectively.
Diagram showing standard and virtual code components

Note that code components created earlier via preview are backward compatible and will continue to work. Please rebuild them using the latest version of PAC tooling so that they are ready for future platform library upgrades.

graphical user interface, text
Creating a virtual component

You can find more details about this feature including supported platform library versions in our documentation for React controls & platform libraries. Please use Power Apps Pro Dev forum for any input or questions.

The post React and Fluent based virtual code components are now generally available appeared first on Microsoft Power Platform Blog.

]]>
What’s new in Power Apps: November 2024 Feature Update http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/whats-new-in-power-apps-november-2024-feature-update/ Wed, 04 Dec 2024 18:08:29 +0000 AI-powered Development Check out some of our latest improvements in this month’s Power Apps Pulse! This month, it’s all about adding that shine! Power Apps Studio has a fresh new look, we’ve given you more ways to add web resources, and now you can customize your modern themes to get exactly the right color at each

The post What’s new in Power Apps: November 2024 Feature Update appeared first on Microsoft Power Platform Blog.

]]>

Summary: Welcome to the Power Apps monthly feature update! We will use this blog to share what’s new in Power Apps. A summary of product, community, and learning updates from throughout the month so you can access it in one easy place. This month we’re excited to shared a simplified approach to writing Power Fx with Copilot, Performance improvements to the Canvas designer, Studio visual updates, and smart paste for model driven apps!

Get started with the latest updates today!

Jump into Power Apps to try the latest updates, you can use an existing environment or get started for free using the Developer plan.

AI-powered Development

Check out some of our latest improvements in this month’s Power Apps Pulse!

This month, it’s all about adding that shine! Power Apps Studio has a fresh new look, we’ve given you more ways to add web resources, and now you can customize your modern themes to get exactly the right color at each step of the ramp. Get in the know with this month’s Power Apps Pulse!

Power Apps Formula Creation with Natural Language Input

Animated Gif Image

The latest update to the Power Apps formula bar introduces a new “Create a Formula” option, allowing users to craft Power Fx formulas using natural language. This innovation simplifies the formula creation process, making it more accessible for users of all skill levels. Enable this preview feature in your app settings, and then by typing a desired action in plain language, the AI suggests the appropriate formula, which can then be applied to the selected control and property.

Additionally, the update enhances the formula explanation capability, enabling users to select a portion of a formula and receive a plain language explanation of the selected part. This is particularly beneficial for understanding long or complex formulas. The Copilot in the formula bar now supports more languages, broadening the feature’s accessibility.

Modernization and visual update of the Power Apps Studio

In the effort to provide better out of the box accessibility, performance, and alignment with Microsoft product set we’ve updated the Power Apps Studio across both the canvas and model driven designers. This milestone creates a modern look and feel, as well as improved coherence throughout the Power Apps authoring experience for makers working across multiple app types, the plan designer and data workspace. No action is required to see the new updates, rolling out now.

Improved Studio performance with the new analysis engine

While you edit or play your app in Studio, a continuous analysis of app elements and their interactions is happening in the background. For example, this allows us to know that if you change an expression `Set(x, 5)` to `Set(x, {Lorem: “Ipsum”})` that the type of `x` is now a record instead of a number, and any references in your app to `x + 1` will therefore be marked as erroneous.  

To improve performance and reliability while building apps, we released the updated analysis engine, Generally Available and will be on by default for all Canvas apps, starting February 2025. To migrate ahead of this, go to app settings, and turn on ‘New analysis engine’ setting under Updates > New.

Performance Boost: The New Analysis Engine optimizes how we approach that analysis, complex Canvas apps that previously took minutes to load should now load much faster. Note that this is an authoring load time and edit time performance improvement and has no impact on app run time performance.

Accuracy: The New Analysis Engine enables more accurate determination of variable and collection types, reliably identifies the columns used in your app, and enhances Data Source call performance in published apps.

Intelligent Apps

New smart paste available in your model-driven apps

Animated Gif Image

Smart paste is designed to make form-filling in model-driven apps as simple as copy & paste. Now you can effortlessly fill forms based on the information you already have, transforming the tedious task of filling forms with a smarter, faster, and more intuitive way to handle forms. We are also introducing citations so you can easily identify where suggestions come from, and expanding form fill assistance (including the new smart paste) to quick create forms.  

To learn more, read the blog at New smart paste makes filling forms as easy as copy & paste – Microsoft Power Platform Blog and documentation at Use Copilot’s form fill assistance feature in model-driven apps – Power Apps | Microsoft Learn.  

Learning and Documentation Updates

Training Paths and Labs

Updated Training

Documentation Updates

Developer
Connect to SQL Server from Power Apps overview
Access data in SQL Server
View results in SQL Server
View source code files for canvas apps (preview)
Disconnect Git version control to edit canvas apps
Use Copilot to create and edit Power Fx formulas in Power Apps
Use Microsoft SQL Server securely with Power Apps
Create virtual tables using the virtual connector provider
Transition from legacy data integration services
Create or edit model-driven app dashboards
Create a model-driven app using the classic app designer
Solution view
Sort rows in a model-driven app view
Types of columns
Use Live monitor to troubleshoot model-driven app behavior
Navigate to advanced model-driven app making and customization areas
Use environment variables for Azure Key Vault secrets
Create and edit tables using Power Apps
Known limitations and troubleshooting with virtual tables
Solution layers
Share a canvas app with your organization
Catalog in Power Platform for developers
Retrieve data about the catalog in Power Platform
Submit and approve catalog items
Install items from the catalog in Power Platform using code
Catalog item submission document reference
Catalog in Power Platform Events reference
Catalog in Power Platform table/entity reference
Admin
Managed security
Security page overview
Use network security features
Use access control features
Use threat detection features
Use compliance features
Managed operations
Monitor page (preview)
View event logs and error logs (preview)
Use the new and improved Power Platform admin center (preview)
Overview of Dataverse Git integration (preview)
Dataverse Git integration setup (preview)
Source control repository operations (preview)
FAQs about Dataverse and Git integration (preview)
Power Platform and SAP
What is Microsoft Power Platform integration with SAP?
SAP + Power Platform white paper
Connect Microsoft Power Platform and SAP
Get started with the SAP ERP connector
Get started with the SAP OData Connector
Set up Secure Network Communications
Set up Microsoft Entra ID with Kerberos for SSO
Microsoft Entra ID (with certificates) – single sign-on
Set up Microsoft Entra ID, Azure API Management, and SAP for SSO from SAP OData connector
Microsoft Entra ID using SuccessFactors (Preview)
Integrating SAP data with Power Platform for app makers
Building integrated Power Platform applications for SAP consultants
Managing compliance and security for Microsoft Power Platform and SAP integration
Enabling Power Platform applications integrated with SAP for SAP Basis Administrators
Microsoft Entra ID using SuccessFactors (Preview)
Telemetry events for mobile app synchronization and actions (preview)
IP firewall in Power Platform environments
Safeguarding Dataverse sessions with IP cookie binding
Business continuity and disaster recovery for Dynamics 365 SaaS apps
Virtual Network support overview
Known limitations for data loss prevention (DLP) policies
Policies and communications for Power Platform and Dynamics 365 Services
Column-level security
Tenant-to-tenant migrations
Manage feature settings
Turn on copilots and generative AI features
Configure user security in an environment
Create users
Teams in Dataverse
Environment routing
Secure the default environment
Microsoft Power Platform admin documentation
Manage Copilot
Solution checker enforcement in Managed Environments
Power Apps operated by 21Vianet and Power Automate operated by 21Vianet
Dynamics 365 service description
Manage email notifications
Use Copilot to generate deployment notes in pipelines
Important changes (deprecations) coming in Power Platform
App object in Power Apps
End User
Use Copilot’s form fill assistance feature in model-driven apps
Modern, refreshed look for model-driven apps
Explore data on a grid page
Frequently asked questions about Dataverse search
Search for records by using Dataverse search

The post What’s new in Power Apps: November 2024 Feature Update appeared first on Microsoft Power Platform Blog.

]]>
Creating and explaining formulas with Copilot now even easier http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/creating-and-explaining-formulas-with-copilot-now-even-easier/ Tue, 12 Nov 2024 21:55:55 +0000 Power Apps introduces the new 'Create a Formula' feature, making it easier than ever to build and edit Power Fx formulas. Plus, now you can explain partial formulas too!

The post Creating and explaining formulas with Copilot now even easier appeared first on Microsoft Power Platform Blog.

]]>
We are excited to announce the launch of the new “Create a formula” preview feature in Power Apps, designed to make building and editing Power Fx formulas easier and more intuitive than ever before.

Copilot can now also explain partial formulas, which is especially useful for longer formulas where you need an explanation on a specific part of the code.

And to top it off, Copilot in the formula bar will now support more languages, enabling most of our worldwide makers to take advantage of these powerful features.

Create a formula with ease

With the new “Create a Formula” feature, you can now generate Power Fx formulas directly from natural language. Simply select the Copilot button, ask it to create a formula, type your desired action in plain language, and the AI will suggest the appropriate formula and append it wherever the cursor was located when the request was made after you click apply.

This functionality is perfect for both seasoned developers and those new to Power Apps, providing a seamless experience for all users. Remember, formulas are specific to the control and property that is selected, and some actions require working across controls and properties.

Animated Gif Image

Additionally, the maker can use the thumb up/down icons to provide feedback that will help to make the product and AI interactions better over time. By sharing the prompt and response along with your feedback, it helps us understand what we can do to improve.

To enable the Create a Formula Capability, turn on the “Copilot for formulas” flag in Canvas App Settings > Updates > Preview.

Explain a partial formula

In addition to creating formulas, we’ve expanded our formula explanation capability to include the ability to explain a partial formula.

By selecting a formula before clicking the Copilot icon, instead of the “Explain this formula” option, you have the option to “Explain this selection” and get a plain language explanation of what the selected portion of the formula does.

The selection does not have to be precise either, as the Copilot knows when to include context surrounding the selection in order to provide an explanation. This is particularly useful for understanding long or complex formulas that benefit from a more granular explanation.

Animated Gif Image

Worldwide expansion

Copilot support in the formula bar now supports 18 languages. To find out if your language is supported, or to learn more, take a look at the product documentation.

Let us know

We hope you find these new features as exciting and useful as we do. We look forward to hearing your feedback and seeing the innovative ways you use them in your apps. Stay tuned for more updates and enhancements in Power Apps!

The post Creating and explaining formulas with Copilot now even easier appeared first on Microsoft Power Platform Blog.

]]>
Introducing Git Integration in Power Platform (preview) http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/introducing-git-integration-in-power-platform-preview/ Mon, 11 Nov 2024 16:00:00 +0000 Now in public preview, Git Integration provides a streamlined experience for developers and citizen developers to build solutions together using the same development processes and best practices. Fusion teams are more productive with familiar Git functionality available directly within their environment. This native integration provides faster setup and iterations, developer and feature isolation, change tracking

The post Introducing Git Integration in Power Platform (preview) appeared first on Microsoft Power Platform Blog.

]]>
Now in public preview, Git Integration provides a streamlined experience for developers and citizen developers to build solutions together using the same development processes and best practices. Fusion teams are more productive with familiar Git functionality available directly within their environment. This native integration provides faster setup and iterations, developer and feature isolation, change tracking and auditing, version control, rollback, and more.

Animated Gif Image

It just takes a few seconds to connect your Dataverse environment to Git. You can connect and use Git integration within Power Apps, Microsoft Copilot Studio, Power Automate, and Power Pages. You’ll also need access to an Azure DevOps Git repository.

Rollout is in-progress. Git integration is currently available in public geos outside the US. Your environment must be enabled for early access and accessed at https://make.preview.powerapps.com.

As the team develops, Dataverse tracks everyone’s changes. When ready, commit your changes to a branch in the connected Azure DevOps Git repository. A commit link is provided to view the changes within the repository and compare diffs. You’ll notice solutions and solution objects are now stored in human readable formats in the repo.

Professional developers can work in source control while others work in one or more environments. It’s easy to pull others’ changes into other development environments which are connected to the same source code location. This allows team members to build without others editing in their environment and share changes once they’re ready. Connect multiple development environments using the same repo, branch, and folder. Then, in each environment create or import an unmanaged solution with the same name and publisher.

When committing and pulling changes, conflicts may be detected – meaning someone else made conflicting changes to the same object. You’ll need to choose whether to keep the version that’s in your environment or bring the version from source control into your environment. You can also revert changes in the repository, then pull the prior version into your environment.

When the team is ready to deploy to test or production, you can use Pipelines in Power Platform for the release. Building and deploying using developer tools isn’t available yet for this new format.

We hope you enjoy the preview. There are many current limitations and you shouldn’t use this feature in environments or Git folders where you’re developing production solutions. Please leave your feedback below, in the community forums, on social media, or another outlet of choice. We look forward to hearing what you’d like to see prioritized next.

Learn more

Overview of Power Platform Git integration

Setup Git integration

The post Introducing Git Integration in Power Platform (preview) appeared first on Microsoft Power Platform Blog.

]]>
Microsoft named a Leader in 2024 Gartner® Magic Quadrant™ for Enterprise Low-Code Application Platforms    http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/microsoft-named-a-leader-in-2024-gartner-magic-quadrant-for-enterprise-low-code-application-platforms/ Wed, 23 Oct 2024 15:00:00 +0000 We are excited to share that Microsoft has been named a Leader in the 2024 Gartner® Magic Quadrant™ for Enterprise Low-Code Application Platforms for the fifth year in a row.

The post Microsoft named a Leader in 2024 Gartner® Magic Quadrant™ for Enterprise Low-Code Application Platforms    appeared first on Microsoft Power Platform Blog.

]]>
Graph depicting Microsoft as a leader amongst other companies reviewed by Gartner

Source: (Gartner, October 2024)1* 

We are excited to share that Microsoft has been named a Leader in the 2024 Gartner® Magic Quadrant™ for Enterprise Low-Code Application Platforms** for the sixth year in a row. This recognition, we feel, reflects the trust of millions of users who continue to build on Microsoft Power Platform—a comprehensive low-code solution that spans application development, process automation, external websites, and intelligent copilots.  

Gartner® Magic Quadrant™ for Enterprise Low-Code Application Platforms

Learn why Microsoft was named a Leader.

The success stories of our customers demonstrate the tangible impact of Microsoft Power Platform in real-world scenarios. A few examples include:

  • Pacific Gas & Electric, a US utility company that has built over 300 complex solutions delivering over $75 million in savings each year and are also adopting generative AI to further advance their service center chatbot, which alone saves $1.1 million each year in helpdesk support.
  • Zurich Insurance Group, a Swiss insurance company, is skillfully balancing the growth of low-code development with the strong governance required in the highly regulated financial services industry sector. 
  • Cineplex, one of Canada’s leading media and entertainment companies, has saved 30,000 hours (approximately 3.5 years) and over $1 million in the past two years by leveraging automation and copilots built on Microsoft Power Platform to improve overall customer service and reduce query handling time from 15 minutes to just 30 seconds.

These companies—and many more—are using Microsoft Power Platform to transform their operations by building solutions on a secure, scalable platform that effectively handles and streamlines AI integration, governance, security, and enterprise data connectivity, a platform that enables developers to build with natural language, visual interface, or code, and deploy powerful solutions to web, mobile, or Microsoft Teams with ease.

“[Microsoft] Power Platform enables us to carefully control the data that feeds our AI models and, through [Microsoft Azure] Active Directory and [Microsoft] Dataverse, also control who can access which data through those models”.

Thomas Bilbo, Principal, Product Owner, PG&E 

Let’s dive into the factors that we believe set our platform apart as a Leader. 

diagram of Power Platform tools

Microsoft Copilot in Power Platform is transforming how people use and create software, making Microsoft the low-code application platform (LCAP) of choice for customers who need to rapidly modernize their application estates for the age of AI. 

Makers can harness Copilot in Power Apps to turn natural language descriptions into functional solutions quickly. Copilot helps makers from the beginning, when they build a plan for their solution, and continues to assist with tasks like working with data models, adding new tables, creating relations between data, adding new screens and controls within the canvas experience, and crafting complex formulas in Microsoft Power Fx.  

“Building the prototype from scratch would have taken 6-8 hours. We were able to just describe in natural language and build in a few minutes.”

Ron Colvin​, Director of Innovation, CONA Services​ 

End-users benefit from out-of-the-box Microsoft Copilot capabilities when using apps built on Dataverse. And with Copilot streamlining actions such as drafting text inputs, filling forms, and filtering records, users are saving significant time on manual and repetitive tasks.  

To date, over 480,000 organizations have used AI-powered capabilities in Microsoft Power Platform. For instance, Nsure.com significantly improved efficiency and reduced costs by using generative AI to automate complex business processes, cutting manual processing time by 60% and associated costs by 50%.  

Confidently adopt at scale with enterprise-grade security and data governance  

Through Managed Environments, the suite of advanced governance capabilities that comes with Power Platform premium licenses, the platform provides a robust control framework for secure, scalable low-code adoption. Leading organizations like PG&E, Equinor, Shell, T-Mobile, Lumen Technologies, Zurich Insurance Group, and HSBC manage extensive developer networks and solutions globally with exceptional visibility and control.  

Since 2022, Deutsche Bahn (DB) Group has been using Managed Environments to drive innovation at scale across the world’s largest railway company. At Rabobank, more than 55% of their 40,000 employees use Microsoft Power Platform solutions. Similarly, Accenture has over 200,000 employees using applications built on Microsoft Power Apps every month. 

Each of our coworkers has a [Microsoft] Power Platform license to create, to solve problems for his or her team, or even for the whole company. It’s very easy to make your own app, and very fast.

Thomas Czierpke, Head of Adoption and Change Management, Microsoft 365, DB Group  

We continue to invest in Managed Environments as customers drive greater scale and sophistication on the platform. In the past year, we have introduced comprehensive application lifecycle management, including Git integration and source control, a proactive intelligent advisor for risk management, and advanced administration options. We’re equipping administrators and experienced developers with advanced tools, and our upcoming release plan will continue to add new functionality in application lifecycle management, enterprise-scale administration, licensing and capacity management, monitoring, security, and compliance. 

Start your low-code transformation now 

In the journey of digital and AI transformation, every maker and every developer plays a crucial role in driving innovation. It’s amazing to see 83,000 participants in our partner bootcamps and airlifts, with Microsoft Power Platform communities growing to 5.8 million monthly active users! It is all of you—our community—that make this journey so rewarding. 

We are grateful to all the organizations, customers, the community, and partners for this recognition—thank you for everything that you do! As a next step, dive into building with Power Apps Developer Plan. Learn more about our position as a Leader in the 2024 Gartner® Magic Quadrant™ for Enterprise Low-Code Application Platforms report. 


Sources

1. Gartner®, Magic Quadrant™ for Enterprise Low-Code Application Platforms, October 16, 2024, Oleksandr Matvitskyy,  Kimihiko Iijima, Mike West, Kyle Davis, Akash Jain, Paul Vincent

2. Microsoft Fiscal Year 2024 Third Quarter Earnings Conference Call 

*This graphic was published by Gartner, Inc. as part of a larger research document and should be evaluated in the context of the entire document. The Gartner document is available upon request from Magic Quadrant for Enterprise Low-Code Application Platforms. 

**Gartner is a registered trademark and service mark and Magic Quadrant is a registered trademark of Gartner, Inc. and/or its affiliates in the U.S. and internationally and are used herein with permission. All rights reserved. 

Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner’s research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose. 

The post Microsoft named a Leader in 2024 Gartner® Magic Quadrant™ for Enterprise Low-Code Application Platforms    appeared first on Microsoft Power Platform Blog.

]]>
What’s new in Power Apps: August 2024 Feature Update http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/whats-new-in-power-apps-august-2024-feature-update/ Tue, 03 Sep 2024 15:17:48 +0000 Welcome to the Power Apps monthly feature update! We will use this blog to share what's new in Power Apps. A summary of product, community, and learning updates from throughout the month so you can access it in one easy place. This month we're excited to share Copilot updates, GA of some key features for our makers and a huge set of Learning and Documentation updates.

The post What’s new in Power Apps: August 2024 Feature Update appeared first on Microsoft Power Platform Blog.

]]>

Summary: Welcome to the Power Apps monthly feature update! We will use this blog to share what’s new in Power Apps. A summary of product, community, and learning updates from throughout the month so you can access it in one easy place. This month we’re excited to share Copilot updates, GA of some key features for our makers and a huge set of Learning and Documentation updates.

Get started with the latest updates today!

Jump into Power Apps to try the latest updates, you can use an existing environment or get started for free using the Developer plan.

AI-powered Development

Introducing our first episode of Power Apps Pulse!

We’re delighted to share with you a new series highlighting incremental improvements each month aimed at making app building faster, easier, and more delightful for your app users. Check out these updates and get making with Power Apps Pulse!

Use Copilot to filter to quickly filter, sort, and search canvas app galleries with SharePoint lists

We are excited to announce that Power Apps application runtime users can now use Copilot to filter to quickly filter, sort, and search the items in canvas app galleries with SharePoint. Copilot to filter uses your natural language to generate a query to the database that scopes the current view of records in a gallery so you can quickly find the records you need. This feature is available only for Power Apps canvas web apps and only at runtime for all applications that have been republished after version 7.4 which is expected to be available starting on July 29. It will be fully rolled out to all regions several weeks later. This premium feature is on by default and authors may disable if required.

Unlocking Power Apps: Exploring New Copilot Features with April Dunnam | Copilot Learning Hub

Join us on Copilot Learning Hub as we dive into the latest Copilot capabilities within Microsoft Power Apps. In this episode, Dona welcomes April Dunnam, a Power Apps expert, to showcase the innovative features that are transforming how users interact with Power Apps. From a comprehensive walkthrough of the new capabilities to practical demos, this episode is packed with insights for both beginners and advanced users. Discover how to leverage Copilot in Power Apps to enhance your productivity and streamline your workflows. Don’t miss out on this informative session.

Call SQL Server procedures directly in Power Fx (GA)

We are excited to announce that calling SQL Server stored procedures in Power Fx is now generally available in all regions. You do not need to call a Power Automate Flow to use a stored procedure making development of Power Apps for SQL easier for authors and faster overall performance for both authors and end users. The ability to call stored procedures for the SQL connector directly is an extension to the existing tabular model and gives users access to tables, views, and stored procedures. This feature extends our ongoing support of SQL Server as a primary development target for Power Apps.

Enterprise-Grade Governance

General availability for delete app users and view platform app users

Admins can take advantage of a modern and accessible UI to manage application users. Admins can do this by using the Application users page in the environment settings in the Power Platform admin center. Application users can be added, updated (or refreshed), and deactivated. Now deactivated application users can be deleted. Admins can also view the list of platform application users with their respective security role assigned.

General Availability for Delete stub, unlicensed, and removed Microsoft Entra group users.

Previously, stub users, unlicensed, or removed Microsoft Entra group users couldn’t be deleted from a Dataverse environment. These types of users remained in a Dataverse environment with a disabled status and were unable to log into the environment. You can now delete these users with the disabled status in your environment to comply with privacy laws, regulatory requirements, and to free up storage space.

Learning and Documentation Updates

Training paths and Labs

Updated Training

Documentation Updates

Developer
System requirements, limits, and configuration values for Power Apps
Improve solution performance, stability and reliability
Define and query hierarchically related data
Work with formula columns
Low-code plug-ins Power Fx (preview)
Visualize hierarchical data with model-driven apps
Using Power Fx with commands
Dataverse long term data retention overview
FAQ for Copilot in model-driven apps
Add Copilot for app users in model-driven apps
Microsoft Dataverse documentation
Create and use dataflows in Power Apps
Import data from Excel and export data to CSV
Importing and exporting data from Dataverse
Sign in to Power Apps
What are model-driven apps in Power Apps?
Customize the command bar using command designer
What is Power Apps?
View table data in Power BI Desktop
List of controls available for model-driven apps
Create a solution
Embed a Power BI report in a model-driven app main form
Use the Power BI report control to add a report (preview)
Manage model-driven app settings in the app designer
Build your first model-driven app
How to run a model-driven app
What’s new in Power Apps?
Use environment variables for Azure Key Vault secrets
Add canvas apps and cloud flows to a solution by default (preview)
PDF viewer control (experimental) in Power Apps
Share a canvas app with guest users
Email address validation for email columns (preview)
Azure integration
Dataverse development tools
Debug JavaScript code for model-driven apps
Asynchronous service
Register a plug-in
Tutorial: Write and register a plug-in
Get started with virtual tables (entities)
Types of columns
Page results using FetchXml
Page results using QueryExpression
Choose finance and operations data in Azure Synapse Link for Dataverse
Client API execution context
Client API form context
Client API grid context
getContentWindow (Client API reference)
isLoaded (Client API reference)
Custom column analyzers for Dataverse Search
Write a listener application for an Azure solution
Form OnSave event (Client API reference) in model-driven apps
PostSave Event
Form OnSave event (Client API reference) in model-driven apps
getFetchXml (Client API reference)
fetch element
Restore deleted records with code (preview)
Admin
Manage Copilot (preview)
Power Platform managed identity overview (preview)Power Platform managed identity overview (preview)
Set up managed identity for Power Platform (preview)
ActivityPointerBase table
Create and manage masking rules (preview)
Set up the Business value toolkitSet up the Business value toolkit
Capture and communicate value with the Business value toolkit
Boost team efficiency and customer experience with Power Automate and Copilot Studio
What is Microsoft Power Platform SAP Supplier Self Service template
Install and set up the SAP Supplier Self Service template
Get started managing the SAP Supplier Self Service solution
SAP on Power Platform
Create a pipeline using a custom pipelines host
Create a personal pipeline using the platform host
Column-level security to control access
Important changes (deprecations) coming in Power Platform
PowerShell support for Power Apps and Power Automate
Dataverse capacity-based storage details
Legacy storage capacity
Dataverse capacity-based storage overview
Solution checker enforcement in Managed Environments
Manage application users in the Power Platform admin center
Delete stub users from an environment
Turn on copilots and generative AI features
Migrate bring-your-own-key (BYOK) environments to customer-managed key
Configure Dataverse search for your environment
Manage your customer-managed encryption key
Create or edit business units (preview)
Creator kit
Manage collaboration settings
Set up pipelines in Power Platform
What are the Awards and Recognition templates for Power Platform?
Use service admin roles to manage your tenant
Secure the default environment
End User
Optimize the offline profile
Mobile offline limitations for model-driven apps
Mobile offline limitations for canvas apps

The post What’s new in Power Apps: August 2024 Feature Update appeared first on Microsoft Power Platform Blog.

]]>