File Renamer Microsoft Flow

First you will need to export an *.XLSX sheet from SEQTA containing the students data

1. In SEQTA click the Pastoral Care Workspace>Reporting
2. From the list of reports Search for "File Renamer"
3. For the first option ensure to select the current timetable period
4. For the second option select the classes you would like to use to rename the file.
5. Click Apply
6. Click Export and select XLSX

Secondly you will need to edit the above excel sheet so the data is displayed in a table

1. Open the excel sheet
2. Ensure the top left cell is select (A1)
3. Select all the data by holding "Ctrl" + "A"
4. Convert the selected data into a table by holding "Ctrl" + "T"
5. Accept the defaults ensuring the tick box "My table has headers" is ticked
6. Save

Finally we can now run the *.XLSX sheet through the "File Rename Flow" along with the file we need to rename

1. Navigate to the flow https://australia.flow.microsoft.com/manage/environments/Default-df95c1c2-d34a-416b-ad2f-2a156d35cd7b/flows/shared/a9ac8154-a4de-4db9-87b9-c98044dc4d43/details
2. At the top click run and an options pane will slide in from the right
3. In the first box locate *.XLSX file with the student names
4. In the second box locate the file you want to rename.
5. Run flow
6. You will receive an email once the flow has completed, this can take around 5 minutes depending on how many students are in the list.
7. Once you receive the email you should be able to find the files in your Onedrive>File Renamer.