Setting Up Forumla Columns in Dataverse

Kylie Kiser June 20, 2024 Video

In this video, UG Expert Kylie Kiser demonstrates how to set up Formula columns in Dataverse, which has replaced Calculated columns.

This episode is sponsored by Community Summit North America, the largest independent gathering of the Microsoft Business Applications ecosystem, taking place Oct. 13-17, 2024, in San Antonio, Texas. Register today to connect with thousands of users across the Microsoft business applications ecosystem at the for user, by user event.

Key Takeaways

  • Formula columns: Formula columns in Dynamics 365 CE/CRM are the new Calculated Columns. These can be used in other model-driven or Canvas apps built on Dataverse. While Formula columns are currently in preview, they’re expected to be ready for production soon. The new Formula columns can perform more complex operations using Power Fx and offer enhanced capabilities compared to the older calculated columns.
  • Adding a Formula column: You can create a new column directly from the Tables area in Dynamics, although it’s recommended to do this within a solution for proper prefixing. Kylie demonstrates how to add a Formula column.
  • Types of formula columns: Creating formula columns is straightforward. She highlights that there are various formula types available for use. After saving the formula column, the data type is not immediately visible, but it will be indicated post-save. Kylie also notes that formula columns update when the values within the formula change.
  • Copilot’s assistance: Microsoft Copilot can assist in building Formula columns, which can simplify the process and assist with creation. Kylie emphasizes the trial and error involved in learning to use the new formula columns and the different formulas available. She also mentions a feature in preview that suggests formulas and helps build them with AI through Copilot.
  • Formula columns in action: Lastly, Kylie gives a demonstration of formula fields in action, defines the importance of correct formula setup to ensure proper functionality, and encourages users to experiment with these new features.
For more “for user, by user” Power Platform innovation, education, and training content, join us at Community Summit North America 2024!
Categories: How To, Power Platform UG, User Group Communities
Tags: ,

Report

Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!