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.

  • Where are you adding this formula? On label/input control inside Gallery control where the gallery items are pointing to "Desk Reservations" data source? Jun 19, 2021 at 12:55

1 Answer 1


Try using this:

LookUp(Desks, DeskID = ThisItem.ReservedDeskID, Building.Value)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.