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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Build a Call Centre St...
Power Apps
Unanswered

Build a Call Centre Stats Counter for multiple team members to each day

(0) ShareShare
ReportReport
Posted on by MattyT8 11

Hi community,

 

I am looking to build a stats counter for a team in a call centre similar to below:

 

MattyT8_0-1677450959690.png

 

Key elements are already built in the counter and conditions set on the fields, the email part I can build to draw from the data, BUT there are a couple of codes I am needing to try to find.

 

1. Something to keep daily figures set as they are entered per user. This would mean multiple users can use the same form, and even if the page refreshes during the day their personal figures would remain. 

2. Then reset all the figures at midnight so the next day is a fresh start for all.

 

At the moment on refresh all the figures reset to zero. And I am not sure how to make it keep the current users entries on refresh.

 

If anyone can point me in the right direction that would be great.

 

Categories:
Building Power Apps
I have the same question (0)
  • Anonymous_Hippo Profile Picture
    Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

    Hello @MattyT8 ,

     

    There are many ways to attack this problem, but this is the solution that comes to mind. I am assuming that you are using a sharePoint list as a database

    1. First create Powerapps controls and the sharePoint list based on your requirement

    2. Add a save button in powerapps and configure the rule so as 

    • Creates new record
      • Only if no news records for the current user exists in the SP list for the current day. Compare created by and Created columns in SP
    • Updates existing Record
      • Only if a record for the current day already exists

    3. To display the stats counter you may use either a gallery or a form and basically filter it to the current user and the current day

     

    Cheers !

     

    Happy building

  • MattyT8 Profile Picture
    MattyT8 11 on at

    Thanks for this, what you describe is exactly what I am trying to do. I just don't know the coding for it. I have built the SP list to record the entries already.

     

    How can I code: new form for new day based on user and date, OR edit form if entry already exists for current user and current day. Then if the page closes or refreshes then they can retrieve the form to continue editing.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 356 Most Valuable Professional

#2
11manish Profile Picture

11manish 225 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 211

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans