cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

creating a teacher timetable

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

3 REPLIES 3
Community Support
Community Support

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

TitleSingle line of text
TeacherSingle line of text
StartTimeDate and Time
EndtimeDate and Time
courseSingle line of text

3.JPG

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)
) 

 

 

1.JPG

At Screen2:

5\Add a from(Form1):

 DefaultMode:

 

FormMode.New

 

DataSource:

 

teacherstimetable

 

6\Add a button:

OnSelect:

 

SubmitForm(Form1);NewForm(Form1)

 

2.JPG

Best Regards,

Bof

 

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.

 

Mo_Islam_0-1592822211125.png

 

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

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (63,472)