web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Answered

Calculated fields vs business rules

(0) ShareShare
ReportReport
Posted on by 21

Hello,
I am fairly new but I have a quite ambitious project that I want to get done at my workplace...I am trying to understand when should I use a calculated field or a business rule and what advantages would bring if I do a certain task with the business rule.
In practice, I would like to input 2 parameters for different cases, cases 1, 2 and 3. Then I need the app to calculate a value for each parameter, evaluate which value is greater and then compare the greater value for all the cases and take the greatest value of all (worst case scenario). Then if the worst case scenario is greater than an input value, show a message.
I kind of did it through the calculated fields, but for each passage I have to create a new field. If I go through the business rule, will I have any advantage, like eliminate some intermediate field that I do not need to store? Also, when I created a business rule, I noticed you cannot multiply 2 fields and to another number, is it right? I think I can do as a succession of steps but it seems strange to me that in one step I cannot do field a*fieldb*2. Is this correct or am I missing something?
Thank you.

I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    on at
    Re: Calculated fields vs business rules

    Hi @mangiafrutta ,

     

    Could you please share more details about your scenario? Which kind of Power Apps app are you working on, canvas app or Model-driven app?

     

    If you are working on a canvas app, and you want to do some validations on values, as per your description you are right about that “in one step I cannot do field a*field b*2”, you will have to achieve this by two steps.

     

    So I’m afraid both the methods need to create a new field to store the calculated values of the parameters to quickly achieve that need, or you could completely using variables and formulas to do that in a complex way. Here is a Blog for you which is talking about which method you could choose in business rules, calculated fields and workflows:

    https://d365lifewithoutcode.com/2019/11/16/business-rules-calculated-fields-and-workflows-what-one-should-i-choose/

     

    As for the advantages of business rules, app makers could add business recommendations in business rules for providing some tips to app users, but it is only available in Model-driven app.

     

    Hope this helps.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

  • mangiafrutta Profile Picture
    21 on at
    Re: Calculated fields vs business rules

    Hello @v-jefferni 

    I am working on a canvas app. Thank you for sharing the blog, I found some useful information in there.

    My concern is more about how to improve my app performance in general, I would not like for it to take long time to load and change screens, as at the end I will have a good share of data. 

    For now I find it much easier to work with custom entities. 

     

    Cheers,

    Mangiafrutta

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 803 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 314 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 253 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics