Share
Report
42I want to include a value from a 2nd sharepoint list that is related to a list being displayed in a vertical gallery.
Initial List: TicketList
2nd List: Notes
The Notes list includes a reference to the first list. That reference column is named TicketID, which has the value from the TicketList.ID. There is a one-to-many relationship between the TicketList item (1) and the Notes items (many).
The TicketList includes the following columns which are included in the Gallery: ID, Customer, Title, and others...
The Notes list includes the following columns which are pertinent to what I'd like to do:
TicketID (related to the unique TicketList Item, this is a Numeric column type))
Note (text field icontaining the note message, multiple line text column )
Created (Date/time the note was created, Date and Time column)
CreatedBy (The person who entered the note, Person or group column)
I'd like to include the last (most recent) Note associated with a Ticket (not every Ticket has notes, if that's pertinent to a solution).
I haven't gotten far enough to even display all notes, let alone the last one. I've created a text field in the Gallery and have tried the following code:
Text=Lookup(Notes,TicketID=ThisItem.ID),Note (I get the error "This formula uses scope, which is not presently available for evaluation").
In addition to the Note itself, I'd like to display who created it and when it was created.
Any assistance is appreciated.
Categories:
I have the same question (0)
All responses (
Answers (
