In this video, Matt Peterson, a trainer at Pragmatic Works, introduces a new preview feature in Dataverse that allows users to write Power Apps FX language directly inside columns within Dataverse tables. This new feature opens up exciting possibilities for users to leverage formulas within their data structure without needing to use the traditional calculated column window editor. Matt demonstrates how this feature works in a real-world scenario and how it integrates with Power Automate for efficient workflow automation.
The Power FX formula feature enables users to write formulas directly within Dataverse columns using Power Apps FX language. Instead of relying on separate editors to create calculated columns, users can now define formulas directly within their Dataverse columns. This feature is still in preview, but it shows great potential for simplifying data management and expanding the ways users can interact with their Dataverse tables.
Matt demonstrates the feature using a simple model-driven app that tracks project bids, contractor expenses, and any discrepancies between the bid amount and actual money spent. In this example, there are two columns created using the Power FX formula feature: “Money Spent Over/Under Bid” and “Overspend Alert.” These columns track the financial progress of a project and flag when the spending exceeds certain thresholds.
To create a formula column in Dataverse, users must select the “Formula” data type from the column’s data type dropdown. From there, they can write the formula directly in the editor, similar to how formulas are written in Power Apps. Matt demonstrates how to use simple mathematical operations as well as conditional logic, like if statements, to create dynamic calculations and alerts.
One of the main benefits of using formula columns in Dataverse is the integration with Power Automate. In Matt’s example, he sets up a Power Automate flow that sends an email when the “Overspend Alert” column turns from false to true. This allows for an automated workflow that notifies stakeholders when a project’s budget exceeds the set threshold, helping to manage costs efficiently.
The Power Automate flow is triggered by changes in the “Overspend Alert” column. When the value in this column is set to true, it initiates the email notification. This automated process eliminates the need for manually checking each project and streamlines the workflow for better project management.
Matt emphasizes that this new formula feature in Dataverse allows for greater flexibility and control when managing data. It eliminates the need for creating complex calculated columns through separate editors and allows users to easily implement conditional logic directly in the column definitions. With more functions being added to the feature in the future, this is a powerful tool for users who need to automate workflows and manage data efficiently.
The Power FX formula feature in Dataverse provides an intuitive way to integrate formulas directly into columns within your tables. By using Power Apps FX language, users can streamline their data management process and create complex calculations with ease. When combined with Power Automate, this feature offers a seamless way to trigger automated actions based on data changes. As the feature continues to evolve, it is expected to provide even more powerful functions, making it an essential tool for anyone working with Dataverse and Power Apps.
Matt concludes by encouraging viewers to experiment with the new feature and explore the many use cases it can support. He also reminds viewers that this feature is still in preview, and more updates will be rolled out soon.
Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Dataverse and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.