Fix 'Microsoft Account Doesn't Exist' Error in Power Automate OneDrive Sync
Question details
The user encounters an error stating the Microsoft account doesn't exist when trying to connect Power Automate to sync files between OneDrive for Business and an FTP server.
- Product
- Power Automate, OneDrive for Business
- Device & OS
- not provided
- Scenario
- Setting up a flow in Power Automate to export an Excel CSV file to OneDrive for Business and synchronize it with an FTP server.
- Observed behavior
- The FTP-to-OneDrive connection works, but Power Automate fails to connect to a valid Microsoft account, displaying the error message 'That Microsoft account doesn't exist'.
Ensure you have the correct login credentials for your work or school Microsoft account, and verify that your FTP server details are accurate and accessible.
Use Power Automate Desktop App with a Work or School Account
Switching from the web version to the Power Automate desktop application bypasses certain account limitations and resolves the connection error.
This error often occurs due to account limitations within the web setup of Power Automate, especially when there is confusion between personal accounts and organizational accounts. OneDrive for Business strictly requires a work or school account. Using the desktop application provides a more robust environment for configuring these specific synchronization flows.
Download and install the Power Automate desktop application from the official Microsoft website.
Launch the desktop application and sign in using your designated work or school Microsoft account rather than a personal account.
Click on 'New flow' and configure the steps to save your Excel CSV file directly to your local OneDrive for Business sync folder.
Add an FTP action within your desktop flow to upload the saved CSV file from the OneDrive folder to your specified FTP server.
Edit Excel CSV Files Seamlessly with WPS Office
While resolving your Power Automate synchronization issues, you can rely on WPS Office to manage and edit your CSV and Excel files. WPS Office provides a lightweight, free, and highly compatible alternative to Microsoft Office, ensuring your data is always accessible and easy to handle.
- 1. Download and Install: Visit the official WPS Office website to download and install the free software on your device.
- 2. Open your CSV files: Launch WPS Spreadsheets and open the CSV files you intend to sync via FTP to edit or verify their contents.
- 3. Save and Sync: Save your modifications locally or directly to your synced OneDrive for Business folder for Power Automate to process.
Frequently Asked Questions
Why does Power Automate say my Microsoft account doesn't exist?
This error typically occurs if you attempt to log into a business-tier service (like OneDrive for Business) using a personal Microsoft account, or if there is a cached credential conflict in your web browser. Ensuring you use a work or school account usually resolves this.
What is the difference between the OneDrive and OneDrive for Business connectors?
The standard OneDrive connector is designed for personal Microsoft accounts, whereas the OneDrive for Business connector requires organizational (work or school) accounts linked to SharePoint infrastructure.
Can I sync FTP files to OneDrive without using Power Automate?
Yes. You can use alternative third-party integration platforms, or manually transfer files by connecting to the FTP server via an FTP client (like FileZilla) and downloading the files directly into your local OneDrive sync folder.
