Post

Stop attaching files to SharePoint list items: the case for document libraries

Diesen Beitrag auf Deutsch lesen

List attachments hide files in system folders, escape versioning, Purview retention and Copilot agents. Document libraries with a lookup column keep working files automatable, compliant and findable.

TL;DR

SharePoint list attachments live in hidden folders, inherit the item's permissions and are never versioned; a single attachment is capped at 250 MB. Power Automate needs two actions plus a loop, Graph only reports whether attachments exist, Purview retention policies skip list items, and Copilot agents cannot see attachments. Document libraries with a lookup column deliver versioning, metadata, retention and agent access.

Original by Ferdi Lethen-Oellers, on MVPTreff. Read the original

This is our own summary, not a republication or full translation.

Governance takeaway

  • Makers: Power Automate needs two actions and a loop to reach one attachment, and Graph cannot upload, list or download them. A document library with a lookup column hands your flow the file and its metadata directly.
  • Admins/CoE: Inventory lists with attachments using PnP PowerShell, which requires its own Entra app registration since September 2024. Decide per list whether it becomes a library or links to one, and disable attachments only after a tested migration.
  • Security/Compliance: Retention policies do not support list items, default sensitivity labels exist only per library, and attachments inherit the item's permissions with no per-file control. Files in libraries close these gaps.

Frequently asked questions

How do I get attachments from a SharePoint list item in Power Automate?

Fetch the attachment list, loop over each attachment and get its content in a separate action. A document library with a lookup column avoids the loop.

Can Copilot agents read SharePoint list attachments as a knowledge source?

No, Agent Builder support for SharePoint lists excludes attachments and lookup columns. Files in document libraries can be added as a knowledge source instead.

Does a Purview retention policy cover files attached to a SharePoint list item?

No, retention policies do not support list items. Only a retention label marking the entry as a record carries the attachment along.

Summary by KMUpower, licensed under CC BY 4.0 . Rights to the original article remain with its author.

Privacy Policy · Legal notice

Microsoft and the Power Platform product names (for example Power Apps, Power Automate, Copilot Studio) are trademarks of the Microsoft group of companies. This is an independent website. It is not operated, sponsored or endorsed by Microsoft.