Thank you for posting your question in the Microsoft Q&A forum.
Also, thanks for your detailed explanation and for sharing the steps you've taken so far. We truly appreciate the time and effort you've invested in exploring both Power Automate and PowerShell-based approaches.
After reviewing your scenario, we regret to inform you that the behavior you're encountering is by design. Microsoft does not currently support application-level access to users’ OneDrive for Business content without explicit user consent. This restriction applies even to administrators and is enforced to protect user privacy and data integrity.
We understand how limiting this can be, especially when trying to implement organization-wide automation. Unfortunately, we have not identified any supported workarounds that would allow silent or unattended deletion of these files across all users’ OneDrive directories. Many users have expressed similar concerns on our Ideas · Community and we encourage you to share your experience there as well. Your feedback is incredibly valuable and helps guide future improvements to our products and services.
We sincerely apologize that we are unable to offer a solution or workaround at this time. Please know that your concerns have been heard, and we will continue to advocate for improvements in this area.
Thank you for your understanding and continued support.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.