When connecting OneDrive-based integrations (such as Power BI or Excel Online) in Teamflect, you may notice that some Excel files appear in the file picker while others do not — even though the files exist in OneDrive and are accessible to you.
This article explains how file discovery works, the exact requirements for a file to appear, common reasons files may not be detected, and what you can do to troubleshoot the issue.
Important: File visibility in OneDrive does not always mean the file is discoverable by integrations.
How Teamflect Finds Excel Files in OneDrive
Teamflect relies on Microsoft’s official OneDrive / Microsoft Graph APIs to search and retrieve Excel files.
This means:
Teamflect can only display files that Microsoft returns through these APIs
If Microsoft does not surface a file via the API, Teamflect cannot detect or sync it
Teamflect cannot override or bypass Microsoft-side limitations
In short:
If Microsoft does not return the file, Teamflect cannot show it.
Requirements for an Excel File to Appear in Teamflect
For an Excel file to appear in Teamflect’s file selection screen, all of the following conditions must be met.
File location requirements
The file must be:
Stored in the user’s primary OneDrive
Accessible via onedrive.live.com
Not a shortcut, symbolic link, or local sync reference
The file must not be:
A local file synced from a device
A shortcut to another user’s OneDrive
Stored only in a Teams or SharePoint document library
Referenced via a local OneDrive sync path
Permission requirements
The user connecting the file must have:
Edit access to the file
Direct access (not inherited through unsupported sharing methods)
View-only access may prevent the file from appearing.
File type & format requirements
The file must:
Be a valid
.xlsxExcel fileOpen successfully in Excel Online
Not be corrupted or legacy-formatted
Organizational & policy considerations
Some files may be hidden due to:
Sensitivity labels
Retention policies
Conditional access rules
Organization-level OneDrive or Microsoft 365 restrictions
These policies are controlled by your Microsoft administrator.
Why Two Excel Files in the Same OneDrive Can Behave Differently
Two files in the same OneDrive can appear identical but behave differently when connecting integrations.
Common reasons include:
One file was copied or synced from a local device
One file was duplicated from another source
Differences in file metadata or version history
Ownership vs. shared access differences
Hidden Microsoft-side flags or restrictions
Even if both files are visible and openable in OneDrive, Microsoft may only expose one of them through its APIs.
Troubleshooting Checklist
Follow the steps below in order.
Step 1: Open the file directly in OneDrive
Go to onedrive.live.com
Open the file directly (not from a shortcut)
❌ If it does not open → This is a OneDrive issue
✅ If it opens → Continue
Step 2: Verify permissions
Confirm you have Edit access
Avoid view-only or indirect sharing
❌ If permissions are limited → Update access
✅ If permissions are correct → Continue
Step 3: Duplicate the file
Create a copy of the Excel file in the same OneDrive location
Try connecting the new copy in Teamflect
✅ If the new copy appears → The original file likely has metadata or sync issues
❌ If it still does not appear → Continue
Step 4: Re-upload the file
Download the file locally
Upload it again to OneDrive
Retry the integration
Step 5: Contact your Microsoft / OneDrive administrator
If the file still does not appear, the issue is likely related to:
Organization-level policies
OneDrive or Microsoft Graph limitations
Tenant-specific restrictions
Teamflect cannot modify or bypass these settings.
What Teamflect Can and Cannot Control
Teamflect can:
Retrieve files returned by Microsoft APIs
Sync supported files once detected
Help troubleshoot visible patterns
Teamflect cannot:
Force OneDrive to surface files that Microsoft does not return
Access files hidden by Microsoft policies
Override tenant-level OneDrive restrictions
When to Contact Teamflect Support
Contact [email protected] after completing the checklist above, and include:
Example files that appear vs. don’t appear
Confirmation of file location and permissions
Screenshots from OneDrive (not local sync folders)
This helps us identify patterns and rule out Microsoft-side limitations faster.