-
- Adding Fields
- Adding and Editing Linked List items using Inline, Dialog & Sintel Forms Embedded
- Linked Lists-How to add attachments
- Linked Libraries-Using a Document/Picture Library
- Sections - Tab order
- Using a Linked List
- Field and Section Validation
- Creating Calculated Fields & using formulas
- Default values & custom values
- Setting field properties within a Linked List
- About Layout
-
- Import a form template
- Configure Printing Options
- Lookup Columns: Retrieve additional columns from Lookup List
- Use Sintel Embedded Mode on a linked list
- Automatically add linked items or files
- Lookup Columns: Control the sort order
- Share a Form
- Configure a cascading drop-down
- Change the layout of Choice Fields
- Make Attachments Mandatory
- Set & clear field values using rules
- Create a custom form header
- Export a form template
- Transferring your license to another tenant
- Debugging your forms
-
- Workflow emails not being received by distribution lists or mail-enabled security groups
- Changing the Content Approval settings of a list can cause an issue with Sintel Forms
- Site naming and Sintel Forms
- Workflow emails not being received by SharePoint group members
- Ad blockers and Privacy Extensions
- "500 internal server error" on form opening
- Attachments option missing in Sintel Forms
- "401 Unauthorized" error during form data save
- Sintel Forms doesn't appear to be applied to a list
- Handling the list view threshold for the Workflow and Conversations features
- No actions appearing in the actions menu
- Enabling third-party cookies
- Sintel Forms Save Process
- The remote server returned an error: (401) Unauthorized when importing a form template
- Activating Sintel Forms on newly created tenants
Lookup Columns: Retrieve additional columns from Lookup List
Created On
Last Updated On
byPiotr Jasek
0 out Of 5 Stars
5 Stars | 0% | |
4 Stars | 0% | |
3 Stars | 0% | |
2 Stars | 0% | |
1 Stars | 0% |
You are here:
- Main
- How To Guides
- Lookup Columns: Retrieve additional columns from Lookup List
< All Topics
Sometimes you may want to pull in additional columns from a lookup list when you are creating the lookup column and this is pretty simple to do.
When you are creating the lookup column and attempt to pull in additional columns you will find that this out-of-the-box SharePoint features does not support all fields types. For example if you have columns in your lookup list whose column type is set to Hyperlink, Picture or Multiple lines of text, these will not appear as available columns. You can work around this problem by creating a Single line of text field in the Lookup list for each unsupported column you have and then enabling Sintel Forms on the Lookup list and using it to set the values of the Single Line of text fields to the values from those unsupported columns. It’s a bit of extra effort but it works!
Example
Let’s start by configuring SharePoint:
As you can see besides the Lookup column which retrieves its data from “Title”, we also select “ID”, “Number” and the “Letter” field. Now its time to add our fields into the layout.
Now that the fields are added lets see how it looks.
You can see from the animation above that in addition to the main Lookup field (“ListLookup”) the other additional fields are also retrieved from the Lookup list and are read-only on the form. If you change the selected value in the “ListLookup” column the related values will be retrieved from the Lookup list.
Was this article helpful?
0 out Of 5 Stars
5 Stars | 0% | |
4 Stars | 0% | |
3 Stars | 0% | |
2 Stars | 0% | |
1 Stars | 0% |
Table of Contents