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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Calculated fields vs b...
Power Apps
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
    Microsoft Employee on at

    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

    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 93 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
Valantis Profile Picture

Valantis 49

Last 30 days Overall leaderboard