Showing results for 
Search instead for 
Did you mean: 
Super User
Super User

Best place to perform calculations

Good morning,

Quick question here?

Where is the best place to perform calculations?

I mean, I am building an APP and I need to decide :

1. In my Share Point have  some Calculated columns of what I need and then in PowerApps have some labels that show the value.

2. In my Powerapps have the labels with the calculations and the Pacth those values back to my SPL.


For you as a developer witch option is better?


Thanks in advance for any response

Super User
Super User

I prefer to calculate them in PowerApps and PATCH back to SharePoint.  Calculated columns are stored as TEXT values (which is absurd IMHO).  Therefore, you cannot perform numeric calculations without using the VALUE function which breaks delegation rules 😞


Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Solution Specialist
Solution Specialist



To me it really depends on the type of calculations. 


I actually prefer SharePoint for many reasons but for example if you are calculating strings to access API and JASON data it can reduce the traffic and in some cases cost to have SharePoint calculate once. Also in many cases it helps give a better audit trail also, and finally PowerApps runs on local systems that we do not have control of processing power or hardware and is in some cases better to reduce the local processing.


If you want feel free to contact me directly, We can do a teams meeting and get better information to help you.




Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.


New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (1,750)