'%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 Microsoft Lists Multi-Select Lookup Hyperlink Limitations
Question details
The user is looking for a way to assign individual hyperlinks to each selected value in a multi-select lookup column in Microsoft Lists.
- Product
- Microsoft Lists
- Device & OS
- not provided
- Scenario
- Viewing and interacting with records containing a multi-select lookup column in a list view.
- Observed behavior
- The lookup column displays multiple values in a single field, but only applies an active hyperlink to the first entry, with no native setting to add separate links or control comma spacing.
Verify your Microsoft 365 permissions to ensure you have the necessary rights to customize SharePoint lists or access Power Apps for creating custom forms.
Build a Custom Form Using Power Apps
Since Microsoft Lists does not natively support individual hyperlinks for multi-select lookup values, creating a custom Power Apps form is the most reliable workaround.
Power Apps allows you to override the default SharePoint or Microsoft Lists form behavior. By replacing the default data card with a customizable gallery, you can display each lookup item as an individual clickable link.
Open your Microsoft List, click on 'Integrate' in the top command bar, hover over 'Power Apps', and select 'Customize forms'.
In Power Apps Studio, locate the multi-select lookup field in your form. Unlock the data card from the properties pane.
Delete the default combo box inside the data card and insert a 'Blank vertical gallery'. Bind its 'Items' property to the multi-select lookup field's data source.
Add a Label or HTML text control inside the gallery to display the lookup values. Set the 'OnSelect' property to navigate to the specific URL of the referenced item.
Click 'File', select 'Save', and then choose 'Publish to SharePoint' so the custom form replaces the default list form.
Submit Feature Feedback to Microsoft
Because the multi-select link behavior was changed in a recent Microsoft update, submitting feedback can help prioritize a native fix.
Manage Data and Documents Seamlessly with WPS Office
While you troubleshoot advanced list limitations in Microsoft 365, consider WPS Office as a free, lightweight, and highly compatible alternative for handling your offline data, spreadsheets, and documentation. Enjoy a familiar interface that makes migration seamless without subscription fees.
Frequently Asked Questions
Why did my Microsoft Lists multi-select lookup stop showing separate links?
Microsoft recently updated the rendering behavior for lookup columns in modern list views. This update caused multi-select lookups to display as a single text string where only the first item acts as a clickable hyperlink, which is currently a known limitation.
Can I use JSON column formatting to fix the multi-select lookup links?
While JSON formatting is powerful for list customization, it currently struggles to iterate dynamically over multi-select lookup arrays to generate individual hyperlink tags for each item. Power Apps remains the recommended workaround for functional linking.
Is there a built-in way to add spaces after commas in lookup fields?
No, Microsoft Lists does not provide a native column setting to adjust the spacing after commas for multi-select lookup fields. You must use JSON view formatting or Power Apps to manipulate the visual display of the array elements.
