'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix SharePoint Lookup Column Reverting to Single Selection
Question details
The user is experiencing an issue where a SharePoint lookup column configured for multiple selections behaves as a single-selection column.
- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Using a multi-select lookup column in SharePoint lists or forms, or attempting to pass its array of selected data to Power Automate.
- Observed behavior
- The lookup column unexpectedly reverts to single selection, disappears from forms entirely, or only passes the first selected value to Power Automate despite UI settings showing multiple selections are allowed.
Verify your SharePoint column settings to ensure the 'Allow multiple selections' checkbox is actually checked, and try toggling it off and on to force a metadata refresh before assuming it is a permanent backend error.
Contact Microsoft Support for Backend Investigation
Since this behavior typically indicates a temporary server-side glitch or database sync failure in Microsoft 365, opening a formal support ticket is the most effective resolution.
This specific issue is frequently caused by a backend synchronization failure where the SharePoint user interface settings do not accurately reflect or update the underlying database behavior.
Because this is a server-side bug rather than a user configuration error, it requires Microsoft engineers to investigate and refresh the tenant's backend.
Determine if your account has Microsoft 365 Administrator privileges for your organization's tenant.
If you are an administrator, log in to the Microsoft 365 admin center at admin.microsoft.com.
Navigate to the 'Support' section on the left sidebar and select 'Help & support' to open a new service request detailing the SharePoint lookup column issue.
If you are not an administrator, document the exact list and column names, then contact your IT department or designated Microsoft 365 admin and request they submit the support ticket.
Try WPS Office for Seamless Document Management
While waiting for Microsoft Support to resolve complex SharePoint backend issues, consider using WPS Office as a free, lightweight, and highly compatible alternative for your daily document creation, spreadsheet management, and presentation needs.
- 1. Download the installer: Visit the official WPS Office website and download the free installer for your operating system.
- 2. Install WPS Office: Run the setup file and follow the on-screen instructions to complete the lightweight installation.
- 3. Open your files: Launch WPS Office and instantly open your existing Microsoft Office files to continue working seamlessly.
Frequently Asked Questions
Why does my multi-select lookup column only send one value to Power Automate?
This can happen due to a backend synchronization glitch in SharePoint, or because the dynamic content in Power Automate is referencing the lookup column directly without an 'Apply to each' loop. If a loop is used but only one value appears, it is likely the server-side bug.
How do I correctly enable multiple selections on a SharePoint lookup column?
Navigate to your SharePoint list settings, click on the specific lookup column name, scroll down to the 'Additional column settings', and check the box for 'Allow multiple selections'. Click OK to apply the changes.
Can toggling the column settings fix this sync glitch?
Sometimes toggling the 'Allow multiple selections' off, saving the column, and then turning it back on can force a backend refresh. However, if the column still reverts or disappears from forms, a Microsoft support ticket is necessary.
