Share
ReportHello, I am a new Teams user and hope to collect students' data more efficiently. I can't figure out how to incorporate different apps to accomplish my goal, especially Power Automate's configurations seem difficult. I would really appreciate your help!
<My goal>: Centralization of data from course registration forms. I set up a separate team on Teams and distribute a course registration form in Excel format (Course_form.xlsx) to each student. Whenever a student submits (including re-submissions for corrections), the file's data should be aggregated into the database (Course_db.xlsx).
<Set up>:
- Microsoft's SharePoint and Power Automate are installed within Teams.
- The database file (Course_db.xlsx) is created directly under 'General' with the following fields: Row A for student's Teams ID, Row B for Course, and Row C indicating the necessity of credit earning (YES/NO).
- In the course registration form file (Course_form.xlsx), cells B15 to B26 contain the course names, while cells I15 to I26 indicate whether credits are required (YES/NO). For instance, in the file of a student who enrolls in only two courses, values will be filled in only at B15 and C15, I15, and I16.
- It appears that submitted files are organized into individual folders under 'Student Work > Submitted files', following SharePoint's specifications.
All responses (
Answers (
612
