Hi there,
I have a gallery which is pulling data from an Excel Sheet called Table13. That Excel Sheet has columns such as "Room", "Projector 1", "Television", "Speakers". Then each row (room) has bits of information regarding the equipment, either saying Working, Broken, etc.
I have set a variable of the room in my PowerApp using a button which does the following (roomList is a dropdown list that fetches the rooms):
Set(selectedRoom, roomList.Selected.Room)
My gallery then says:
LookUp(Table13, Room = selectedRoom)
and when I click on LookUp in the code editor, it displays the following:
However, I can't seem to write ThisItem.Name or ThisItem.Value in my gallery to display this information, it only lets me write things like ThisItem.'AXIS' or ThisItem.'AV Speed Dial', to which it will return the Value "N/A" or "Working", etc. It also only returns one record. Many thanks in advance.