Power Pizza: Sums and Calculations

We are in the middle of a Power Pizza Blog Series! I am walking through lessons learned while building a Power App to track your Pizza Crawls. This will allow your friends to submit their locations, enter ratings and view the winner. Finally, a scientific solution for finding the best pizza!

Pizza Crawl Fourth Stop
The Fourth stop on the crawl was 2Amys in Washington, DC

There were two different calculations I wanted to do in the app. I wanted to sum up the total score on a rating based on the different categories. Then I wanted to take all of the scores from the rating and total these at a location level. This would allow us to see the places that rated highest by one person and by the group.

At first, I wanted to do all of this in Power Automate with a Flow. I am very familiar with classic workflows so I am trying to force myself to learn Power Automate. This is a slow process. After struggling for a bit, I realized that I should be using all the tools available to me not just forcing myself into Power Automate for the sake of it.

Calculated Field

For the individual ratings, I decided to use a Calculated Field. This can sum all of the other fields on the record as soon as they are populated. So I could display this data back to the pizza lover right away.

Sum Score Calculated Field
Using a Calculated Field to add our scores together and set the Sum Score

Action in Power Automate

I was still struggling with the best way to sum at the location level then Aiden Kaskela started talking about actions. He did not realize that he had found the solution to my problems.

Actions are super cool because they follow a similar setup to the classic workflows that we know and love but you can call them from Power Automate. This allowed me to create a simple Action that just increments the Location record based on the rating entered. Then I added this into a Flow that is triggered by that Rating being created.

Action to Update Location Rating
Simple Action to update Location Score
Action Process Details
Process details for increment the Location scores within the Action
Action called through Flow
Calling the Action from Flow

I still have a long way to go to learn Power Automate but I am glad to have a connection back to some things I know. Let’s keep learning tomorrow.

One thought on “Power Pizza: Sums and Calculations

Leave a Reply