Others

How to Design a Power Apps Attendance and Support Data Model

Maira Mehtab Sep 28, 2026 869 views

Question details

The user is looking to build a structured Power Apps solution for tracking contacts, session dates, group attendance, and support summaries across various services.

Product: Microsoft Power Apps
Device & OS: not provided
Scenario: Developing an application to manage and report on in-person and online service attendance and support interactions.
Observed behavior: Seeking a recommended relational database architecture and reporting approach suitable for an attendance tracking application.

Before you start

Before creating your tables, map out all the specific data fields you need to collect for your contacts and sessions to ensure your data model supports your final reporting goals.

Solution 1Recommended

Set Up a Relational Table Architecture

Create distinct, linked tables to efficiently manage contacts, sessions, and interactions in your application.

A proper relational data model prevents data duplication and makes reporting much easier. Using Microsoft Dataverse or a structured SharePoint setup, you can link records seamlessly.

Create a Contact Table

Set up a primary 'Contact' table to store user details, demographics, and unique identifiers for each participant.

Define Session Types

Create a 'Group or Session Type' table to categorize the different in-person and online services your organization offers.

Log Session Dates

Add a 'Session Date' table to record the specific date, time, and location of each group or service event.

Build an Interaction Table

Create an 'Attendance or Support Interaction' junction table that uses foreign keys (Lookups) to link the Contact ID with the Session Date ID.

Solution 2

Consult the Power Apps Community

Engage with Power Apps specialists to validate your specific relational data model and get technical support.

Free Microsoft Office alternative

Track Attendance Easily with WPS Spreadsheet

If building a custom Power Apps solution is too complex, you can easily track attendance, contacts, and support summaries using WPS Spreadsheet. It serves as a highly compatible, free Microsoft Office alternative that allows you to manage relational data via multiple sheets, pivot tables, and advanced formulas without writing any application code.

1. Download WPS Office: Visit the official WPS website to download and install the free, lightweight WPS Office suite.
2. Create an Attendance Tracker: Open WPS Spreadsheet and create separate sheets for Contacts, Sessions, and Attendance Logs.
3. Save in Excel Format: Save your workbook in .xlsx format to ensure full compatibility with Microsoft Office users.

Highly compatible with Microsoft Excel (.xlsx) formats for seamless data migration.Free and lightweight Office alternative without the complexity of app development.Built-in pivot tables and charts to instantly summarize attendance and support interactions.Familiar user interface makes it easy for any team member to input contact and session data.

microsoft office alternative - wps office

Frequently Asked Questions

How should I handle reporting for an attendance data model?

Reporting is best handled by integrating Power BI, which can directly connect to your tables, or by using native Power Apps galleries and charts to summarize records from your Attendance Interaction table.

Can I use SharePoint as a data source for this model?

Yes, you can use SharePoint lists for Contacts, Sessions, and Interactions. However, for complex relational data and large datasets, Microsoft Dataverse is generally recommended to avoid delegation issues.

How do I link one contact to multiple support sessions?

You need a many-to-many relationship. This is typically achieved by creating a junction table (e.g., 'Attendance Log') that contains lookup columns pointing to the Contact's ID and the specific Session's ID.

Where can I find templates for an attendance app?

Microsoft provides several sample apps and templates within the Power Apps creation studio. You can also find specialized templates shared by specialists in the Power Apps Community.

Office Quick Solutions