List of all SharePoint active sites... in a list (modern)
How would I create a SharePoint list of active SharePoint sites? I know I can view my active sites in SharePoint Admin Centre, but I want our users to be able to browse through in a modern experience a filtered list of all our active projects. I know I could create a manual SharePoint list, but given we have hundreds of projects per year, I really need a list that automatically shows all active sites (we create all sites so they are accessible to all in the organisation). A SharePoint List would be a helpful way to present them as I can apply filters, add columns and set views so that the lists show only certain types of projects, but open to other ideas. Any suggestions?