Others

How to Fix a Power Apps Connection That Remains Pending

Emma Brown Oct 1, 2026 869 views

Question details

The user needs to resolve an issue where a Microsoft Lists connection in Power Apps fails or remains in a pending state indefinitely.

Fix a Power Apps Connection That Remains Pending

Product: Power Apps and Microsoft Lists
Device & OS: not provided
Scenario: Connecting a Microsoft List containing various field types to Power Apps.
Observed behavior: The connection gets stuck in a pending state or fails entirely, often triggered by the presence of a Boolean (Yes/No) column in the connected list.

Before you start

Before making changes, verify that you have edit permissions for the affected Microsoft List and ensure you have saved a backup of your current Power Apps progress.

Solution 1Recommended

Change the Boolean Column to a Text Column

Modify the data type of the problematic Yes/No column in Microsoft Lists to resolve the pending connection issue in Power Apps.

In many cases, a pending connection between Power Apps and Microsoft Lists is caused by a Boolean (Yes/No) field failing to parse correctly during the data sync. Converting this column to a standard text field often restores the connection seamlessly.

Open Microsoft Lists

Navigate to the specific Microsoft List that is failing to connect within Power Apps.

Edit the column settings

Locate the Boolean (Yes/No) column, click on the column header, and select 'Column settings' followed by 'Edit'.

Change the data type

Change the column type from 'Yes/No' to 'Single line of text' and save the changes.

Refresh the connection

Return to Power Apps, remove the existing pending connection to the list, and add the connection again to apply the updated schema.

Change the Boolean Column to a Text Column

Connection Restored: Once the column type is updated, Power Apps should successfully connect to the list without hanging in a pending state.

Solution 2

Check Microsoft 365 Service Health

Verify if a broader Microsoft service outage is causing the connection to fail.

Solution 3

Open a Support Ticket in Power Platform

Contact Microsoft Support if the connection issue persists after troubleshooting.

Free Microsoft Office alternative

Need a Reliable and Free Office Suite?

While Power Apps is part of the broader Microsoft ecosystem, handling everyday documents shouldn't require complex troubleshooting. WPS Office is a lightweight, free alternative that offers comprehensive tools for word processing, spreadsheets, and presentations.

1. Download WPS Office: Visit the official WPS website and download the installation package for your operating system.
2. Install the software: Run the installer and follow the on-screen prompts to set up WPS Office on your device.
3. Start creating documents: Open WPS Office to seamlessly create, edit, and save documents in popular Microsoft formats.

Fully compatible with Microsoft Word, Excel, and PowerPoint file formats.Lightweight design ensures fast startup and smooth performance on any device.Completely free to use for daily office productivity tasks.Familiar user interface makes switching easy with zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why do Boolean fields cause pending connections in Power Apps?

Sometimes data schema mismatches or synchronization bugs occur between Microsoft Lists and Power Apps when handling specific data types like Yes/No (Boolean) fields. Converting them to standard text fields circumvents this parsing issue.

Will changing a Yes/No column to Text affect my existing data?

Changing the column type will convert your existing 'Yes' and 'No' values into standard text strings. While the data itself remains intact, you may need to update any Power Apps formulas that specifically rely on true/false logic for that column.

What should I do if changing the column type doesn't fix the connection?

If modifying the column type doesn't resolve the issue, the problem might be a temporary service outage. Ask your administrator to check the Microsoft 365 Service health dashboard or open a support ticket in the Power Platform admin center.

Office Quick Solutions