I have two SharePoint lists Desks and Desk Reservations. I want to get the building name in column Building in Desks where the
ReservedDeskID from Desk Reservations equals
DeskID in Desks. I am using this formula:
LookUp(Desks, DeskID = ThisItem.ReservedDeskID,Building)
But I get an error "Expected Text Value" all the fields are single line of text except Building which is Choice in the SharePoint list with all choices being text.