Contents
The Status filed is a choice – dropdown in the SharePoint list. With the Creator field being as such, I would of thought the lookup for that field would be something like this now: ThisItem.Status.Selected.Value, but that was not the solution. Am I close, or barely touching the surface? 08-09-2017 05:52 AM
SharePoint provides two types of lookup fields: Lookup: links to another list: for example an Orders list may have a lookup field that links to customers in a Customer list; Choice: clicking or tapping the field displays a small menu of items that you choose from.
How to fetch the lookup field values from a list?
Any help is appreciated, thanks. you can use this code to fetch the lookup field values from a list items. Thanks for contributing an answer to SharePoint Stack Exchange! Please be sure to answer the question. Provide details and share your research! But avoid … Asking for help, clarification, or responding to other answers.
How do you create a list in SharePoint?
Choice fields are used for very short lists, but instead of actually creating a separate list, you include the list values in a small menu, which appears when you click or tap on the Choice field, and you select one of the values.
There are no lookup fields in the dropdown menus. You must manually enter the Text property of the Label controls 08-08-2017 05:54 AM 08-09-2017 04:36 AM Would you please share more information about the field type for the Status and the creator in SharePoint list?
Select + (insert) from the left pane. Select Drop down. Update the Items property with the following formula: Replace Vehicle registration with the name of your SharePoint list and Vehicle type with the name of the lookup column in the list.
How to set default value in SharePoint table lookup?
Setting the Default value for a LookUp column can be accomplished like this. { Id: 1, Value: LookUp(Expenses, Id=1, Status) } Do not make a lookup to a choices column. Change status to a text column instead. Choices columns just make things complicated here.