0

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.

Improve this question
1
  • Where are you adding this formula? On label/input control inside Gallery control where the gallery items are pointing to "Desk Reservations" data source?
    – Ganesh Sanap - MVP
    Commented Jun 19, 2021 at 12:55

1 Answer 1

Reset to default
1

Try using this:

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

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.