app to calculate score

Like (0) Share

Report

Posted on 5 Mar 2025 11:39:50 by RC-05031125-0

Dear,

I don't know if I'm asking this question in the correct forum, but please forward it if not.

I don't have much experience with creating power apps myself. That's why I want to first present my case to see if this is possible, and if so, whether it is feasible for a layman like myself.

Case:
My driver has to keep track of how much of a certain type of waste he receives during his working day.
A separate score is used for these types of waste.
For example, type A is 1 point, type B is 2 points.
He may not go higher than approximately 7 points.
So if he threatens to reach the limit, he must stop.
After his working day, he must be able to send the completed form to the office.
If he is checked that same day, he should also be able to show the overview.

The points in the example are presented in a simplistic way; the actual calculations are of course less obvious.

Is this feasible to make an App for, or is this better done via another tool, I would like to hear your opinions.

Thanks in advance for your spontaneous reactions.

All responses (2)

Answers (1)

RC-05031125-0 4 on 05 Mar 2025 at 16:50:13

Like (1)

Report

app to calculate score

Hi Michael,

wow, this is a lot of info at once.

I will have to delve into it first.

But it is certainly a good basis to start with.

Many Thanks
Verified answer

Michael E. Gernaey 41,498 Super User 2025 Season 1 on 05 Mar 2025 at 16:12:35

Like (1)

Report

app to calculate score

Hi,

It would be simple to build an App against a SharePoint List for this yes. A few thoughts on it

1. You need to create a List in SharePoint (or Dataverse if you want to pay for premium but I don't recommend it atm).

This list will have all the Points lined out.

Example

SharePoint List Example

Column (Name) Column (Point Value)

Big Tree 1

Dead Leaves 2

And so on. This is simply used to give us the ability in real time to track points against a specific category

2. Now lets create another SharePoint list. It will be our Daily Tracker.

Column (Collection Date) Column (Truck Operator This would be Person Type Data Column) Column (Daily Points)

This would be Todays Date When the trucker signs in it knows to make it them Total Points for today that changes over time

3. On more List to track the individual items collection

Column (Category) Requested Quantity Quantity Picked Up (Truck Operator person)

The type of item how many of a Category was asked to pick up How many did you actually take again who logged in

This would allow you to also keep track if a customer had more to pick up, maybe the next day. So many things you could do.

Think of List 1 and List 2 like a shopping list. You have each item listed on your receipt, but you need to know in advance and at the end who much the total would be. So, List 1 is a rollup of all the daily collected stuff so far in real-time, and List 2 are the individual items.

4. Now in the App

The person would sign in (by opening the app)

--The app would allow them to Select a Category of the item type, as well as set the quantity, in case they are getting more than 1 "size" of this type

--The app should allow them to add more than one Category type at a time in case they are at a place that lets them pick up more than 1 type at a time

--The app will calculate what the total points would be, IF they actually collected the estimated pick up. So they would know if they were going to go over, either to stop altogether, or tell the customer, hey sorry I can only grab X today

-- Once they accepted that they could take it all, they would load it and then in the app, save it so that it goes in the back end. Which would auto update the total items for the day as well as the total points already collected, which they would always see.

There is so much more that can be done, but this is just a high level suggestion and again, I could add so many bells and whistles..

Cheers,

-Michael

Community site session details

app to calculate score

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Warren Belz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

app to calculate score

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Warren Belz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Leaderboard

Featured topics

Product updates