OneDrive File Issues

How to Find OneDrive Folders with Missing or Incomplete Files

Khadija Khan Sep 30, 2026 869 views

Question details

The user needs a method to identify OneDrive folders that are missing files, mark incomplete folders without changing their modified dates, and detect incomplete data within PDF or Excel documents.

How to Find Missing or Incomplete Files in OneDrive Folders

Product: OneDrive
Device & OS: not provided
Scenario: Managing multiple collaborative OneDrive folders where ensuring all required files (such as PDFs and Excel sheets) are present and complete is necessary.
Observed behavior: OneDrive does not automatically highlight folders missing required files, nor does it natively validate the internal contents of PDFs and Excel files. Any manual changes to the folders currently update the modified dates.

Before you start

Before setting up automation, ensure you have access to Microsoft Power Automate through your work account and prepare a master checklist of the exact file names expected in your OneDrive folders.

Solution 1Recommended

Use Microsoft Power Automate to Detect Missing Files

Since OneDrive lacks a built-in feature to flag missing files, you can build a custom Power Automate workflow to compare existing files against a required checklist and send notifications.

Power Automate can run scheduled background checks on your OneDrive or SharePoint folders. This method allows you to generate reports or receive emails about missing files without ever modifying the folder contents, thereby preserving the original modified dates.

Access Power Automate

Create a Scheduled Flow

Click 'New flow' and select 'Scheduled cloud flow'. Set the frequency to run daily or weekly depending on your folder auditing needs.

List OneDrive Files

Add a new step and search for the 'List files in folder' action under the OneDrive for Business connector. Select the root folder you wish to monitor.

Compare Against Expected Files

Use a 'Filter array' or a 'Condition' block to compare the output of the retrieved files against an expected list of filenames (which you can store in an Excel table on OneDrive).

Configure Email Notifications

Add the 'Send an email (V2)' action. Configure it to send an alert to your email address listing any folders where the expected file count or specific file names are missing.

Use Microsoft Power Automate to Detect Missing Files

Community Support: Building array comparisons in Power Automate can be complex. It is highly recommended to consult the Microsoft Power Automate Community forums for specific formula structures.

Solution 2

Track Folder Completeness Using SharePoint Metadata

Since you have access to SharePoint workspaces, migrating your folders to a SharePoint Document Library allows you to use custom metadata to track completeness manually without changing the file's modified date.

Free Microsoft Office alternative

Review PDF and Excel Files Seamlessly with WPS Office

While OneDrive requires custom workflows to audit missing files, checking the internal contents of your PDF and Excel documents shouldn't be a hassle. WPS Office is a lightweight, fully-featured suite that allows you to efficiently open, validate, and edit Microsoft Office formats and PDFs on any device.

1. Install the Application: Download and install WPS Office for free from the official website.
2. Access Your OneDrive Files: Open WPS Office, click 'Open', and navigate to your local OneDrive sync folder to access your documents.
3. Review and Edit: Open multiple PDFs and Excel sheets in a single window using the tabbed interface to quickly cross-reference and verify complete information.

Fully compatible with Microsoft Excel (.xlsx) and PDF formats.Built-in PDF editor lets you quickly verify and fill in missing information.Lightweight application that runs smoothly, saving your device's resources.Free alternative to Microsoft 365 featuring a familiar, easy-to-navigate tabbed interface.

microsoft office alternative - wps office

Frequently Asked Questions

Can OneDrive automatically notify me if a required file is missing from a folder?

No, OneDrive does not have a native feature to automatically detect or alert you about missing files. You must rely on external automation tools like Microsoft Power Automate to create custom notification workflows.

How can I mark a OneDrive folder as incomplete without changing its modified date?

By default, changing the contents or properties of a folder in OneDrive updates its modified date. To avoid this, you can maintain a separate Excel tracker, or migrate the folders to SharePoint and use custom list metadata which can be managed separately from the file contents.

Is it possible to automatically detect missing information inside PDF or Excel files?

OneDrive and SharePoint cannot validate the internal completeness of a document. You would need to use data validation rules inside the Excel file itself, or utilize specialized data extraction scripts and third-party tools to parse and verify the contents of PDFs.

Document & File Issues