New Power FX Dataverse Formula Columns

Matt showcases a new preview feature inside Dataverse tables. There is now a new datatype called Formula. This data type allows you to leverage the PowerFX language for populating the column. From simple math calculations to conditional logic.
In this demonstration, he will show how to do a simple math calculation and also set the Boolean value of a column using an If statement that references columns directly on the table. He later showcases how a PowerAutomate could use one of the formula columns to execute a flow.
👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Matt30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks.com/pricing/
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️CZcams: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]
#PragmaticWorks

[@Poryotis]

Thanks for the information on this. Tried to use Formulas and had to use the Text() function which turns out is useless converting decimal numbers so I had to revert back to Calculated columns 😕

[@munkybutler1]

Love it Matt, thanks. When will we be able to display the formula field as a currency?

[@videmkoo]

Nice video 🙂 Is is possible with these formulas to access values in related tables?

[@ENG.Kelvinffxgchfhg]

UNFORTUNATELY NO LOGARITHM AND EXPONENTIAL FUNCTIONS ARE SUPPORTED. IT SERVES NO PURPOSE