Power Platform Community Forum Thread Details

Hi everyone,

I am working with SharePoint and Power Automate to track files created in a document library, and I am facing challenges specifically with OneNote notebooks.

**Based on testing, I found that the OneNote file is treated as a folder in SharePoint, and the sections and pages are treated as items.

Current Scenario

Using trigger: “When a file is created/modified (properties only)"
Logging entries in Excel for created items

Issues

Multiple files for OneNote
A single notebook creates:
- .one (sections)
- Open Notebook.onetoc2 (system file)
Duplicate entries
Same file gets logged multiple times due to sync/updates.
Notebook vs Section
I only want to track the notebook, not individual .one section files.
Rename not detected
Renaming a notebook (folder) does not trigger the flow.

Example

File Name: Open Notebook.onetoc2
Path:
Shared Documents/DocumentTest/Internal/Internal/Test/testone/Open Notebook.onetoc2
Actual File name: testone

Requirement

Track:
- Normal files (Excel, PPT, etc.)
- OneNote notebooks as a single entry
Ignore:
- .one files
- Duplicate/system events
Avoid duplicate logging
Detect rename if possible

Questions
- What is the best way to identify a OneNote notebook in SharePoint?
- Can Open Notebook.onetoc2 be used to represent the notebook reliably?
- How to avoid duplicate entries from OneNote sync?
- Is there a way to detect notebook (folder) rename in Power Automate

Thanks in Advance

Below is the Screenshot of the excel file

Categories:

Building flows

Power Automate Desktop

Hi @AB-16071545-0

Hi,

OneNote notebooks in SharePoint are actually folders containing .one section files and a special .onetoc2 file. This causes your flow to trigger multiple times and log duplicates.

Here’s what you can do:

Use the .onetoc2 file to identify the entire notebook.

In your Power Automate flow, only track:
- Normal files (Excel, PPT, etc.)
- The .onetoc2 files (which represent notebooks)

Ignore .one section files to avoid duplicates.

To prevent duplicate logs, check if the file entry already exists before adding a new one.

Detecting notebook (folder) renames is tricky because Power Automate doesn’t trigger on folder rename. You’d need a custom solution like periodic folder name checks or using SharePoint APIs.