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 / Daily step counter app...
Power Apps
Answered

Daily step counter app structure advice

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi all,

 

Not a specific problem, just wondering if anyone had some ideas that could set me off in the right direction with an app I need to build.

 

Our workplace is running a challenge, where each of the 150 employees (divided into 8 teams) will log their daily steps into an app for two months.

 

I will be using SharePoint as the data source and my thinking was to have an item for each participant with columns for name, team number and a separate column for each day of the challenge, into which each day's step counts will be patched. I understand, though, that when doing a patch, column names can not be dynamic so I will need to have a separate textinput and formula for each day of the challenge...61 in total! 😮 

 

An I right in my thinking? Does anyone know of a smarter way of doing this?

 

Many thanks!

Joel

Categories:
  • Verified answer
    Joel CustomerEffective Profile Picture
    3,224 on at

    I would make this two lists

     

    List 1 Team that has the team information

    List 2 Team Steps: includes a lookup to team, the date, and step total.

     

    so when you patch the daily step totals, create a new record in list 2 for the team steps.

     

    you can the display this Ina gallery just like it was on one list

  • ajdhingr Profile Picture
    Microsoft Employee on at

    Yes, creating 2 list is a  good idea and you can create an APP directly from List 2 for users to input the data. 

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you @jlindstrom and @ajdhingr. Great idea and just what I needed. I've gone for a central list to hold the team and team member details and a list each for the 8 teams creating a new item per person per day for step counts.

  • robertcrichton Profile Picture
    4 on at

    Thanks @Anonymous 

     

    Can i reopen your query with a small sub question please as your question has sparked I think a solution to my similair quest.

     

    Setting the List option so the users couldnt see (or edit!) each others entries I get..and in the users Column view of the List rather than asking them to fill in their authenticated name I can just expose the Created by Column and ask the user to simply supply a "date" field and a "step count for that entry date" number field.  Then we can simply have a Site Admin with oversight of all entries from all users who will report back that everyone had fun! Not sure how to have a running (no pun) total of step count to make their job easier but will look at that later.

     

    My real query if i may - how do i deal with the idea of Team Names? I cant ask the user to enter that each time they enter their steps.

    My first clumsy thought was to have a Seperate List for each Team ? (with security on each List to allow only Team A members access to List A. Then I started to think wouldn't it be nice to report and show how well (or bad) Teams totals were compared to each others without someone bashing that out manually and having it on the landing page of the site. (yet still respecting privacy so User A would never know what User Bs count was but could see that Team B were miles in the lead over Team A (and again they would know fellow Team members names but not their stepcount).  I feel multiple lists for each Teams isnt the right approach and has overheads as the overseer would need to go off to 10 seperate lists to see how everyone was doing. I therefore ask from anyone with a better brain than mine help us design the "fun" site am meant to create for my organisation.  

     

    thanks!

  • robertcrichton Profile Picture
    4 on at

    @jlindstrom Ah hang on your idea of two lists with a lookup - yes - thats the Ticket. Penny just dropped as we say and I think other than pretty reporting the SP data structure now makes sense without the need for silly seperate lists afterall. 

    jlindstrom

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 220 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 189 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 139

Last 30 days Overall leaderboard