attendance app

[Chriskarth]

i am planning to create a powerapps to track attendance. i created a canvas app from Excel that is on onedirve. the requirement here is every day the admin or the SPOC will see who has attended and add his attendance.. ( not usres are not given the option to mark the attendace.) the challenge i face is in Excell i have columns with the date and not sure how to add the attendance in those colmuns again the dates

[Drrickryp]

@Chriskarth 

• You are describing a one to many relationship between people and dates. Ideally you should have  two tables and include the ID of the attendee as a column in the attendance table. See https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Principles-and-PowerApps-... for how to do this.