cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RhysJWA
Frequent Visitor

Button conditionally Mapped to SP Record

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?

1 REPLY 1
StalinPonnusamy
Super User
Super User

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))))

 

StalinPonnusamy_0-1639542728120.png

 

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

 

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (5,731)