Key takeaways
- Choose the source mailbox or monitored folder and the destination library first; invoice review, posting and payment are separate business decisions.
- Obtain the actual contents of each required file and determine whether that attachment has already been stored successfully.
- A filename collision is different from a duplicate document: use a unique stored identifier and retain the original name as metadata.
- Reconcile all expected attachments with completed or deliberately open work, and actually open stored files.
01 / 12
What is the boundary of the workflow?
Mailbox and library. Choose the source mailbox or monitored folder and destination library first. The initial workflow should reliably store the required attachments and record their arrival. Invoice review, posting and payment are separate business decisions. This boundary makes technical acceptance manageable and prevents a successful upload from being mistaken for accounting approval.
Ownership of the mailbox. Establish whether the mailbox is personal or shared, who operates it and which file types are expected. A managed business inbox supports cover during absences. Its connection should not depend invisibly on an employee account that may later be removed.
Excluded cases. Describe excluded cases as well, such as personal correspondence, protected messages or archives that should not be opened automatically. These need visible tasks. Not processed automatically must not mean unnoticed.
02 / 12
How do you prepare SharePoint before building the flow?
Select or create the approved document library and check its access. Define useful metadata before the first file is written. Deep folder structures can obscure information; a few stable locations with explicit properties for arrival date, case identifier, provenance and status may be easier to maintain.
Microsoft documents file creation and updating file properties in the SharePoint connector. A library file and a list item are different objects, so choose the action that matches the intended destination. Microsoft SharePoint connector, checked on 26 September 2026.
A possible set of SharePoint properties for stored attachments looks like this:
| Information | Purpose | Example |
|---|---|---|
| Case identifier | Stable connection to intake | IN-2026-00418 |
| Original filename | Preserve provenance | invoice.pdf |
| Stored filename | Avoid name collisions | IN-2026-00418-01-invoice.pdf |
| Message reference | Locate the source email | Technical reference rather than subject alone |
| Intake status | Expose unfinished work | Stored; review open |
| Owner | Route the task | Accounting or clarification queue |
These are proposed fields, not prescribed SharePoint columns or a universal archive design. Adapt them to the existing information structure. Avoid unnecessary personal details in filenames visible to broad groups.
03 / 12
How is the Outlook-to-SharePoint flow built step by step?
The flow from Outlook to SharePoint runs in eight steps with explicit outcomes:
- Trigger intake: choose the appropriate Outlook trigger for the agreed mailbox and restrict the monitored scope.
- Record the case: preserve a stable message reference and a received state. Do not mark all storage complete yet.
- Identify attachments: iterate through available attachments and apply the agreed inclusion rules.
- Retrieve content: obtain the actual contents of each required file rather than passing metadata as file content.
- Check repeat processing: determine whether that attachment has already been stored successfully.
- Create the file: use the destination library, valid unique name and binary content.
- Add properties: connect the file, source, case and status.
- Confirm the outcome: save the SharePoint reference and reconcile all expected attachments with completed or deliberately open work.
Microsoft notes that including all attachment contents directly in an Outlook trigger can cause timing problems at high volume and describes separate retrieval using Get Attachment (V2). Office 365 Outlook connector. Follow the current guidance appropriate to your configuration and test expected peak intake.
This sequence is an implementation design, not a flow already executed in your tenant. Verify available actions, connection permissions and licensing before turning it into a fixed implementation estimate.
04 / 12
Which attachments belong in the workflow?
Why filename filters are weak. An email may contain signature logos, ordinary files and embedded items. Filtering only for “invoice” in the filename is weak: a genuine invoice can be called scan.pdf while a logo also appears as an attachment. Combine documented metadata with your permitted file types.
Attachment properties. Microsoft Graph represents attachments with properties such as type, name, size and inline status. Microsoft Graph attachment reference. If the standard connector does not support a required attachment type, establish a separately verified path. A simple loop should not be described as covering every special case.
No usable attachment. Handle messages without usable attachments explicitly. A supplier may send a download link instead. Record the case rather than automatically opening arbitrary links. Password-protected files also need an agreed manual route.
Extension is not enough. Do not rely on extension alone for acceptance. A file named PDF may be damaged or contain unexpected data. The storage process and subsequent review need to detect that the document cannot actually be opened.
05 / 12
How do filename collisions differ from duplicate documents?
Two suppliers can each send invoice.pdf. The name must not cause the first file to be overwritten or the second to be discarded. Use a unique stored identifier and retain the original name as metadata.
Conversely, the same attachment can arrive again or its trigger may execute repeatedly. Recognise a previously processed message-and-attachment combination. Detecting business duplicates across separate messages needs an additional check, such as a hash followed by business identifiers. That is different from avoiding filename collisions.
Identical filenames, repeated processing and business duplicates are three different problems:
| Situation | Response |
|---|---|
| Two suppliers each send invoice.pdf | Use a unique stored identifier and retain the original name as metadata; neither overwrite the first file nor discard the second |
| The same attachment arrives again or its trigger executes repeatedly | Recognise a previously processed message-and-attachment combination |
| Business duplicate across separate messages | Additional check, such as a hash followed by business identifiers |
Test concurrency. Two simultaneous runs must not both choose the same apparently available filename. The storage and status design needs to guarantee uniqueness or handle a collision explicitly. Adding an arbitrary delay does not prove the problem is solved.
Preserve the distinction in user-facing status. “Already stored from this message” is different from “possibly the same invoice received through another channel”. The latter may need accounting review even when the files differ.
06 / 12
Synthetic example with partial success
The message. An invented message contains an invoice, delivery note and signature logo. The design stores the first two and excludes the logo under an agreed rule. The invoice is saved successfully, but a connection failure interrupts the delivery-note upload.
Partial completion. The case remains partially complete. Its record contains the successful invoice reference and an open task for the delivery note. A retry handles only the missing attachment. It neither creates a second invoice nor treats the deliberately excluded logo as a failure.
After recovery. After recovery, the operator opens both files and checks their provenance. Counts reconcile: three attachments detected, two expected documents, two stored files and one deliberately excluded element. Only then does intake receive a complete storage status.
Why this case. This compact case is more informative than a demonstration using one email with one clean PDF. It tests status, retry and exclusion rules together. Repeating it should produce the same two stored documents and a traceable repeated event, not additional files.
Got a workflow like this?
Tell me about it. Honest take and a rough price, usually within a day.
07 / 12
How do you verify contents, metadata and access?
Open the files. Actually open stored files. A filename and green execution indicator do not prove the content transferred correctly. Check type, size, readability and all pages. During acceptance, compare original and stored bytes where no deliberate transformation occurs.
Test as the eventual user. Then test as the eventual user. Accounting must be able to open the document; an unauthorised role must not. A highly privileged technical account can hide incorrect library permissions during a demonstration.
Retention. Define which source is retained and how long its mailbox copy is needed. Automated storage does not by itself establish compliance with every recordkeeping requirement. The organisation must assess originals, changes, access and deletion across the process.
Metadata after renaming. Check that metadata remains connected after an employee renames or moves a file. If the workflow relies only on a path, ordinary library maintenance may break the source reference. Use the supported identifiers appropriate to the chosen implementation and verify this behaviour explicitly.
08 / 12
How are operation and completeness checks organised?
Reconciliation. A scheduled or volume-based reconciliation should compare incoming messages with stored and unresolved attachments. Failed runs need an owner and actionable reason. “Flow failed” without a message reference gives accounting little useful information.
Service errors versus business exceptions. Distinguish temporary service errors from business exceptions. A connection problem may be retried. An unsupported file or unknown destination needs a decision. Bound retries so the same unsuitable attachment is not processed indefinitely.
Responsibilities. Document who renews connections, approves changes and verifies recovery after an outage. Test new rules with sample messages first. Keep a description of the last approved configuration and a manual fallback.
Fallback. The fallback should include how manually stored files are recorded. Otherwise, the restarted automation may create another copy because it cannot see work completed during the outage. Recovery requires reconciling both automated and manual actions.
09 / 12
Test permission and ownership changes
Removed write permission. In the approved test environment, temporarily remove write permission from the destination library. Intake should remain identifiable without being marked stored. After restoring access, continue only the unresolved attachment. This proves that status follows the actual result rather than an attempted action.
Change of owner. Test changing the operational owner too. The replacement must see connection problems and open cases. Document administrative steps without placing credentials in general instructions. The former owner must not remain the only recipient of failure notifications.
Changed destination structure. Include a change to the destination structure. When a folder or library is renamed, the operator should understand which connection is affected and how to verify it again. Do not silently store files in an arbitrary alternative location when the intended destination fails. A file in an overly broad or incorrect location is not a successful fallback.
Why these cases. These cases test changes that occur in everyday operation even without a new AI model. That is exactly why they belong in the handover to operations and should be run again after relevant adjustments.
10 / 12
Which acceptance cases come before production?
For each of these acceptance cases, record expected files, destination, state and owner:
- one attachment
- multiple attachments
- identical filenames
- repeated submission
- inline image
- protected file
- missing permission
- large document
- interrupted upload
- an arrival immediately before maintenance, with recovery checked afterwards
Ask future operators to test as well as the flow's builder. They should be able to correct a failed case and explain which attachments are already stored safely.
Finally, test the operating handover. Another authorised person should locate the source, inspect the outcome and resume the incomplete work using the documentation. A process that only its creator can diagnose remains fragile.
The completed workflow provides a complete, findable intake with visible exceptions. Classification, extraction and approval can then build on it. Additional AI will be more useful once the underlying storage and event handling are dependable.
11 / 12
Take the worksheet
Worksheet
Download the editable CSV table
| Step | Rule | Exception |
|---|---|---|
| Read | Approved mailbox and folder | Report access failure |
| Select | Check attachment type and content | Exclude signature images |
| Route | Approved client mapping | Review unknown assignments |
| Store | Avoid silent overwrite | Record collision |
| Complete | Link destination ID to source | Reconcile uncertain upload |
Columns to fill in, in the file: Your value / observation, Owner, Next action.
Download the editable CSV table (CSV). Add your own values, owners and open actions. This worksheet contains no measured client results.
12 / 12
Related decisions
These guides and service pages cover the decisions next to saving Outlook attachments to SharePoint:
- AI document processing: capture, review and transfer
- Plan Outlook and Microsoft 365 workflows in n8n
- Move documents and metadata into SharePoint with n8n
- Sort an email inbox with AI and clear routing rules
- Classify documents without forcing unknown types
For a workflow review, start with the task, systems involved and typical exceptions. Discuss it with modernagents.



