cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Data Model Driven PowerApps

In the data model driven PowerApps is there a way to call normal Microsoft functions in calculations? I am trying to make a column with a calculation that contains a square root and a squared value, and it won't let me call the sqrt function or ^2 for the value. Is this possible to do in the data model driven apps? It seems like a simple calculation, but it keeps coming up with errors and invalid characters in the calculation box. 

1 ACCEPTED SOLUTION

Accepted Solutions
dpoggemann
Super User
Super User

Hi @Anonymous,


There are a number of enhancements coming very soon around PowerFX and Model-Driven Apps.  The calculated field functions are supposed to increase 10x 😀

https://powerapps.microsoft.com/en-us/blog/power-fx-coming-to-model-driven-power-apps-dataverse-and-more/

This was supposed to be in preview in June but I have not seen it yet but should be soon.

 

Hope this helps.  Please accept if answers your question or Like if helps in any way.

 

Thanks,


Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

View solution in original post

2 REPLIES 2
dpoggemann
Super User
Super User

Hi @Anonymous,


There are a number of enhancements coming very soon around PowerFX and Model-Driven Apps.  The calculated field functions are supposed to increase 10x 😀

https://powerapps.microsoft.com/en-us/blog/power-fx-coming-to-model-driven-power-apps-dataverse-and-more/

This was supposed to be in preview in June but I have not seen it yet but should be soon.

 

Hope this helps.  Please accept if answers your question or Like if helps in any way.

 

Thanks,


Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
EricRegnier
Super User
Super User

Hi @Anonymous,

It is not yet possible, but as @dpoggemann mentions PowerFX is coming to model-driven apps so eventually it might be where you would be able to define calculated column with PowerFX. If you need that now, then there are 3 common ways to acheive this:

  1. Calculate in Power Automate. Trigger a flow when the field/column/value is updated or created.
  2. JavaScript on load of the form or when the value is updated: https://docs.microsoft.com/powerapps/developer/model-driven-apps/clientapi/reference/events/form-onload 
  3. Plugins: https://docs.microsoft.com/powerapps/developer/data-platform/plug-ins 

Hope this helps!

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (1,929)