creating a teacher timetable

[Mo_Islam]

Hi,

Has anyone created an app for teachers timetables or anything similar?

I want to make an app for my teachers where our admins can add classes and assign them to teachers, and each teacher can then see their timetable, how many hours they are working and how many free time they have left.

Any ideas or guidance is much appreciated.

Thank you,

Mo

[v-bofeng-msft]

Hi @Mo_Islam :

Because I am not sure what your specific needs are, so I made a simple demo, which has the following functions:

• According to the current login user desplay course schedule
• Calculate accumulated class time
• Allow administrators to log in to the management screen to add records

I'v made a test for your reference:

1\Create a list in SharePoint

teacherstimetable

Title	Single line of text
Teacher	Single line of text
StartTime	Date and Time
Endtime	Date and Time
course	Single line of text

2\Create a canvas app which has two screens(Screen1/Screen2)

At Screen1

1\Add a label

Text:

"Hi   " & User().FullName

2\Add a data table

Items:

Filter(teacherstimetable,User().FullName = Teacher)/*Filter records based on current user*/

3\Add a label 

Text:

Sum(
    ForAll(
        Filter(
            teacherstimetable,
            User().FullName = Teacher
        ),
        DateDiff(
            StartTime,
            Endtime,
            Minutes
        ) / 60
    ),
    Value
) /*Calculate the time of class*/

4\Add a button

OnSelect:

If(
    User().FullName = "XXXXX",/*Determine if the current user is an administrator, if it is then navigate to Screen2*/
    Navigate(Screen2)
) 

At Screen2:

5\Add a from(Form1):

 DefaultMode:

FormMode.New

DataSource:

teacherstimetable

6\Add a button:

OnSelect:

SubmitForm(Form1);NewForm(Form1)

Best Regards,

Bof

[Mo_Islam]

Thank you so much @v-bofeng-msft . This is a nice app which I will definitely implement.

I was wondering if there was a way to make timetables visual as per attached automatically from the solution you have shown.

[v-bofeng-msft]

Hi @Mo_Islam :

I am afraid there is currently no control that can support a visual timetable similar to the screenshot you provided.

In addition,you can add an idea in below forum if you need this feature:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Best Regards,

Bof