'%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)
Can a SharePoint Lookup Display an Image from Another List?
Question details
The user wants to know if a SharePoint lookup column can natively return and display an image from another list, specifically for use in a Power Apps inventory application.
- Product
- SharePoint, Power Apps
- Device & OS
- not provided
- Scenario
- Building a Power Apps inventory application that relies on related data and images stored across multiple SharePoint lists.
- Observed behavior
- SharePoint lookup columns natively do not support retrieving or displaying image columns from another list as part of the lookup result.
Verify your SharePoint list permissions and ensure your Power Apps environment is properly connected to the respective SharePoint lists before building relational queries.
Build the Image Lookup Logic Directly in Power Apps
Since SharePoint lookup columns cannot natively return image columns, you can bypass this limitation by linking the lists and rendering the image directly inside Power Apps.
SharePoint restricts complex column types, including Image columns, from being selected as additional fields in a Lookup column. However, if you are building an application in Power Apps, you can use Power Fx functions to manually retrieve the related image from the secondary list.
Open your canvas app in Power Apps Studio and add both SharePoint lists (your primary list and the secondary list containing the images) as data sources.
Navigate to your gallery or form where the data is displayed, and insert an Image control from the 'Insert' menu.
Select the Image control and set its 'Image' property using the LookUp function to match the related records. For example, use a formula like: LookUp(SecondaryImageList, ID = ThisItem.LookupColumn.Id).ImageColumnName.
Boost Your App Documentation Workflow with WPS Office
While managing complex database relationships in SharePoint and Power Apps, you often need an efficient office suite to document app architecture, analyze exported list data, or prepare presentations. WPS Office is a lightweight, highly compatible, and free alternative to Microsoft Office that meets all your daily documentation needs.
- 1. Download the software: Visit the official WPS Office website to download the free installation package for your Windows, Mac, or Linux operating system.
- 2. Open exported SharePoint data: Launch WPS Spreadsheet to easily open and edit any CSV or XLSX files exported directly from your SharePoint lists.
- 3. Save in familiar formats: Save your documentation and spreadsheets in standard Microsoft formats (.docx, .xlsx) to ensure seamless sharing with your team.
Frequently Asked Questions
What column types are supported as additional fields in a SharePoint lookup?
SharePoint lookup columns typically support simpler data types like Single line of text, Number, Date and Time, and certain calculated columns. Complex types such as Multiple lines of text, Images, and other Lookup columns are not natively supported.
Can I use a hyperlink to an image instead of an Image column for a lookup?
Yes. If you store the image URL as a 'Single line of text' column in the source list, you can pull that URL via a lookup column. However, it will display as plain text or a clickable link rather than rendering the actual image natively in the standard SharePoint list view.
Where can I request new features or get help for Power Apps?
You can submit product ideas directly to Microsoft through the official Feedback Portal. For troubleshooting and building workarounds, the Microsoft Power Apps Community forum is the best place to ask for advice from experts.
