Unanswered

Using Power Automate to extract data from a Team's Gradebook for 14 different sections of a course

(0) Share

Report

Posted on by JohnDickinson

As a Power Automate newbie I am not sure if the the correct forum so my apologies.

I am a teacher managing 14 different sections of an online course (each in their own MS Teams Class Site) and I regularly need to export and process the Gradebooks. Ideally I would like to do this into a single excel file, table or something like that for further processing but I would be happy simply to auto export 14 different csv files as I can do manually.

1) Unfortunately I cannot find any place or way in Teams or the accompanying Sharepoint to access the Gradebook using Flow. Nor can I find a way to access the assignments which makes me feel like I am missing a data source somewhere?

2) Is it possible to capture grading completion events as an alternative way to update a master table?

Regards,

John

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (0)

Sort by

manuelstgomes 6,643 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JohnDickinson

It's perfectly possible to copy the CSV files from a location into another.

Try the following:

Trigger when a new file is created or updated in a folder

Get the file's contents.

Copy to the destination.

Can you please check if and let me know if you have any questions?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No
JohnDickinson 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the overview (I am sure I will find this useful elsewhere).

Unfortunately I forgot that not everyone has had to use MS Teams Class. The Gradebook appears at the top of the Teams general channel as a tab or app or something. Only when we open the "app" can we see the grades and tell MS Teams to export to CSV. So far I haven't been able to find a Sharepoint resource or connector linking to it.

Was this reply helpful? Yes No