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.
