Button conditionally Mapped to SP Record

[RhysJWA]

Hi All,

Hoping someone can help me out. I am trying to create a clickable floorplan for desk booking using buttons over the top of desks in a floorplan. The idea would be to disable the button if the Date/time was already booked and the colour would signify if the desk was laptop ready or had a workstation at it. All of this is populated in a SP List of desks and a second list deals with the bookings. 

I know it should be easy but I am struggling to get the formulas for the Button to look at a single record in the SP list for the conditions, every post I think is close involves a gallery and the floorplans are dynamic and not always linear. Can anyone help?

[StalinPonnusamy]

Hi @RhysJWA

Set the Icon Color property to

If(ThisItem.IsSelected,RGBA(255,25,50,1),
With({_item:SPList},
If(!IsBlank(LookUp(_item,Office.Id=ThisItem.ID&&Employee.Email=UserInfo.Email)),
RGBA(80,0,80,1),
IsBlank(LookUp(_item,Office.Id=ThisItem.ID)),
RGBA(0,128,0,1),
RGBA(255,0,0,1))))

Office - Lookup to Another SP List where Desk information present

Employee - Person Record type

I know many videos available for floor/desk booking. Here is the video I worked for one of the customers. It has a few color coding for Selected, Available, Not Available, and Current User.

Thanks,
Stalin - Learn To Illuminate