I created an IT room/laptop trolley booking system with Antigravity AI (Free). Users auto-login using Active Directory, email support, SIMS timetable import, mass bookings, and logs.
I created a search page where staff get a direct link to Students OneDrives. Staff are the site collections admins for each Students OneDrives sites.
This is the script I use to add group to Students OneDrive sites
Connect-SPOService -url "https://*domain*-admin.sharepoint.com"$csv = Import-Csv -Path (Read-Host -Prompt "Enter Path to Text File")ForEach ( $line in $csv ){ Set-SPOUser -Site $line.OneDriveSite -LoginName "*accountID*" -IsSiteCollectionAdmin $true }
Create the flow under a service account then use that to send the email.
This is easily if others need access to the flow if you decide to leave the company.