Hi CG-25062141-0,
Thanks for the detailed write-up - the fact that subfolders sometimes appear but root files don't, while everything is visible in OneDrive web, points to the file-picker behavior rather than your files actually being missing. Here's what I'd check and the most reliable way around it.
Use the path instead of the picker
The dynamic file-picker (the folder-browse UI) is convenient but can be inconsistent about what it enumerates. The robust pattern is to not depend on the picker at all:
- Switch the action to enter the path manually (most file actions let you toggle to type the path), or use a path-based action and supply the file's path/identifier directly.
- You can get the exact identifier/path first with "Get file metadata using path", then feed that into "Get file content".
Rule out a policy blocking enumeration
Microsoft documents that certain tenant policies can prevent the OneDrive for Business connector from accessing/enumerating content, including:
- "Prevent file download" (the connector relies on downloading file content, so this can block it),
- Conditional/unmanaged-device controls, and
- Network-location-based access controls.
If any of these are enabled, the connector may show partial results. Worth checking with your admin if the path-based approach still misbehaves.
Other quick checks
- Confirm the connection is authenticated to the same account/tenant where the files live (cross-tenant and multi-geo access aren't supported).
- Try a fresh connection reference rather than just refreshing the existing one.
One honest caveat
Microsoft Learn documents the OneDrive for Business connector's known limitations (file-size skips, Copy File timeouts, policy-based access blocks, cross-tenant/multi-geo restrictions), but it does not specifically document a "Get file picker hides root-level files" symptom. So the picker-vs-path guidance above is grounded in the connector's documented behavior and limitations, not in a single Learn page describing this exact issue - if the path-based approach doesn't resolve it, this may be worth raising with Microsoft support.
Reference
Found this helpful? Please mark ✅ "Does this answer your question?" so others searching for the same issue can find it quickly. A 👍 on "Was this reply helpful?" or a ♥ Like is also much appreciated!
Raghav Mishra - LinkedIn | PowerAI Labs
