What is a one sentence summary of your feature request?
Allow the state-in-time SharePoint Online Site Collections External Sharing report to show expanded results instead of requiring drill down by click.
Please describe your idea in detail. What is your problem, why do you feel this idea is the best solution, etc.
We get the desired results when running this report, but each site collection (including OneDrive folders) are listed separately with a hyperlinked number. Once we click the number, we can see the files being shared and all of their details. In order for this report to be effective, I need to be able to export it as an Excel file or CSV that just lists each item being shared externally. Ideally, the report would include columns for site collection, item name or path, and who it was shared with.
How do you currently solve the challenges you have by not having this feature?
Run the existing report and click the numbers to view the information… over 2000 times…