ShareMaster is shaped by your feedback. Tell us what to build next →
Features All features overview
Migration Tools Overview Structure and content OneDrive ↔ SharePoint Content only Structure only Move / Copy Upload from this computer Download to this computer Dropbox to SharePoint Resume and incremental runs
Microsoft Teams Overview Copy a team Move channels Merge teams Inactive teams Ownerless teams Guests and external access Export a team Search everyone's chats
Recycling Bin Overview Browse a site's recycle bin Empty recycle bins in bulk Restore and purge history Deleted teams
Archive Overview Configure the tenant On Demand Archive Restore Archived Files Archive Savings Report Blob Viewer
Optimise Storage Tools Overview Delete all items in a list Delete all files and folders in a library Remove empty folders Remove duplicate files Reduce image sizes Delete sites and subsites
SharePoint Tools Overview Tenant Explorer SharePoint Explorer Easy Settings Fix renamed groups List Explorer Search the Preservation Hold Library
Search & Indexing Overview Search query Item search properties Reindex Crawl log
Replace Overview Replace in SharePoint Replace in local files Find password-protected files Remove PDF passwords
Shared Links Overview Report shared links Report unique permissions Remove a person from sharing links Remove shared links Remove unique permissions
Version History Overview Version trimming Version trimming report Reset file version
Reports Overview Inventory report Folder inventory Site and subsite storage Storage growth Security matrix Teams permissions Pre-migration analysis Compare items Dropbox to Microsoft 365 compare Duplicate file report Empty folder report Image size report Recycle bin report Unused licences Copilot readiness Inactive sites, OneDrives and groups Orphaned users Site settings Audit activity Groups Checked-out files report Report history
Developer Tools Overview Query Builder PnPjs Console Property Bags SPFx Customizers Webhooks Customisation audit
Pricing Services Demos Blog Guides Use cases Compare Tools Alerts FAQ Contact
  1. Home
  2. Documentation
  3. Reports

Custom report builder Coming soon

Relate lists, pick fields, export

Coming soon. This tool is built and shows on its menu, but it does not open in a released build yet. This page describes it as it will ship.

For the report nobody built for you. Pick lists on a site, relate them to each other, choose the fields you want from each, filter, and export the joined result as a single Excel sheet. It is the answer to reporting across a list and its lookup lists without exporting three sheets and writing a VLOOKUP.

Reads only. Nothing in SharePoint is changed.

What does it tell you?

  • Anything you can express as lists plus relationships plus fields plus a filter.
  • Data from several related lists on one row, rather than one export per list.
  • The same question again next month, because the definition is saved and re-runnable.

How it runs

  1. Or describe it. On the Reports page, type the report you want under Describe the report and click Choose a site. Once the site is open, Build with AI picks the lists, joins, columns, filters and grouping from the lists' names and columns. Review it shows the whole report; Check each step walks you through every step. Change anything, then save and run it yourself.
  2. Sign in and pick the lists. Clicking the tile asks which account to use and how to connect, signs you in if you are not already, and drops you straight on the site list. No feature page asks you to connect a second time. Choose the lists you want to report across.
  3. Relate them. Lookup columns are detected and offered automatically. Where there is no lookup, you can relate two lists by hand.
  4. Choose fields and filters. Pick the columns you actually want, in the order you want them, and filter the rows down.
  5. Export, and save the definition. The workbook is the output. The definition goes to Saved reports so the next run is one click.

How does it work?

Running a report reads each list it uses in pages, which works past the 5,000 item threshold, and reads only the columns the report needs: the ones you show, the ones you filter on, and the ones the relationships join on. SharePoint cannot join lists itself, so everything after reading happens on this computer.

Lists are joined along your relationships, starting from the base list. A lookup column joins on the item it points to, and a relationship you set by hand joins on matching values, compared the same way on both sides. Each relationship either keeps base rows that have no match, leaving the other list's columns blank, or drops them. Rows are joined, filtered and grouped one at a time rather than all held at once, so a wide join does not exhaust memory. Filters combine with AND binding tighter than OR. Output stops at Excel's row limit, with a warning saying so.

If one list cannot be read completely, it is left out entirely, with a warning in the workbook and on the completion dialog, because partial rows joined and filtered would look plausible and be wrong. When no rows can be trusted, nothing is exported. The workbook goes into History before the save dialog appears, so cancelling the save does not lose the run.

What do you need?

  • Read access to the lists you report on.
  • Describe the report (optional): your own AI key in Settings → AI keys. It sends your words, the site's list names, kinds and item counts, the columns of the lists it asks about (names, types and choices), your saved reports' names and the report being built. Never items, people, or the site's or tenant's name or address. The AI never saves or runs the report: everything it builds is checked against the site's real columns first, and you save and run it.

What will it not do?

  • Not released yet. The tile shows a clock rather than a padlock, because this is us not being finished rather than a licence you could buy.
  • It reports across lists on a site. It is not a cross-tenant query tool.

See every feature