Fix Power Automate Microsoft Forms Connection Requires User Login Error
Question details
The user is experiencing a connection failure when testing a Power Automate flow for Microsoft Forms, receiving a prompt that requires user login despite already being signed in.

- Product
- Power Automate
- Device & OS
- not provided
- Scenario
- Setting up or testing a Power Automate flow connection for Microsoft Forms and its associated Excel response file.
- Observed behavior
- The connection test fails and throws a "Required user login" error message, even though the user has a premium license and is actively signed in.
Ensure you have your Microsoft 365 account credentials ready and verify that your premium license is currently active before making changes to your connections.
Recreate the Microsoft Forms Connection
Deleting the existing cached connection and authenticating a new one clears hidden session glitches in Power Automate.
Power Automate connections occasionally store expired or corrupted authentication tokens. Removing the stale connection forces the system to generate a fresh, valid token for your Microsoft Forms trigger.
Open Power Automate, look at the left-hand navigation pane, expand the 'Data' menu, and click on 'Connections'.
Scroll through your list of connections to find the Microsoft Forms connection. Click the three dots (More commands) next to it and select 'Delete'.
Go back to the flow you were editing. When configuring the Microsoft Forms trigger, follow the on-screen prompt to sign in and establish a brand-new connection.

Clear Browser Cache and Start a New Session
If recreating the connection fails, stale browser cookies might be causing persistent authentication conflicts.
Manage Your Exported Form Data Offline with WPS Office
While cloud automation tools like Power Automate handle complex triggers, analyzing your exported Microsoft Forms data is often easier in a dedicated desktop application. WPS Office provides a lightweight, highly compatible spreadsheet tool to manage your Excel response files without the hassle of premium license login errors.
- 1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on your device.
- 2. Export Forms Data: In Microsoft Forms, navigate to the Responses tab and click 'Open in Excel' to download your raw data.
- 3. Analyze in WPS Spreadsheets: Right-click the downloaded .xlsx file, choose 'Open with WPS Office', and begin analyzing your responses instantly.

Frequently Asked Questions
Why does Power Automate ask me to log in when I am already signed in?
This happens due to expired authentication tokens or corrupted cached connections in your browser. The system fails to recognize your active session for that specific connector, requiring you to re-authenticate.
Do I need a premium license to connect Microsoft Forms to Power Automate?
Standard Microsoft Forms triggers generally do not require a premium license. However, if your flow also connects to premium database connectors or uses specific Excel Online (Business) features for the response file, a premium license is necessary.
Will deleting my Microsoft Forms connection break my existing flows?
Yes, any flow relying on the deleted connection will temporarily show an error. You must open those specific flows in edit mode and re-select your newly created connection to restore their functionality.




