Can Power Automate be helpful with building time tables for sites, classes, teachers and groups? I expect gathering data from spreadsheets and merging into one document that has sorted all the data.
Yes
Can you give an idea of the type of data?
Like, are you thinking "generate a list of all the classes in August", something like that?
I answer questions on the forum for 2-3 hours every Thursday!
Hi, I was hoping I can enter the data of all classes for a site and then have another spreadsheet merge appropriately with teachers preferences, availability and units.
For example - Frankston, units CHCDIV003, CHCLEG003, CHCCOM003 and so on and then the other table has
Teacher - Jan who prefers Frankston and units CHCLEG003 & CHCDIV003, Pete who also wants Frankston but unit CHCCOM003
So literally entering all date for timetabling and then having them merge, rather than pay $10,000 for a program that does this.
Any help will be greatly appreciated.
Thanks
Bec