Hi, hope you are doing well.
You can do this, just keep the design simple. Power Apps handles the UI/game, SharePoint stores the metrics.
Basic approach
1. SharePoint list (for tracking)
Create a list with columns like:
- User (Person)
- PlayCount (Number)
- TotalScore (Number)
- LastPlayed (DateTime)
2. Build the game in Power Apps
- Canvas app
- Keep logic simple (timer, buttons, score variable, etc.)
- Use variables like:
3. Track “game played”
On game start or end:
Patch(
YourList,
LookUp(YourList, User.Email = User().Email),
{
PlayCount: Coalesce(PlayCount, 0) + 1,
LastPlayed: Now()
}
)
If user doesn’t exist yet, wrap with If(IsBlank(...), Patch(...Defaults...), Patch(...))
4. Track score
When game ends:
Patch(
YourList,
LookUp(YourList, User.Email = User().Email),
{
TotalScore: Coalesce(TotalScore, 0) + varScore
}
)
Optional improvements
- Store each session separately (another list: GameSessions)
- Add leaderboard (sort by TotalScore)
- Use a timer control for game mechanics
- Add badges/levels if you want to gamify further
Set(varScore, 0)
If you need more help, feel free to DM me and I can help you map this out properly.
If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.
