Answered

Color an icon in red if the desktop is already reserved

(0) Share

Report

Posted on by s44

691

Hello, I am creating a Flex Office application to allow users to book offices. When the user chooses a date on the first screen, he can then click on a desk on the second screen to reserve it.
Once done, the SharePoint list will populate with each user's reservations.

Screen 1 :

Screen 2 :

SharePoint List :

"Name" column: Type People Picker (Indicates the name of the person who booked the room)
"Date" column: Type Date (Indicates the date of the reservation, chosen on the calendar screen on power apps)
"Number_Office" column: Number type (Indicates the office number reserved by the user)

What I would like to do :

I would like that if, for example, office number 1 is already reserved by someone, then the blue dot corresponding to office number 1 on screen 2 is red. But I don't know how to do that. Could you help me please? Thanks in advance ! 😄

Categories:

Using Apps Using Formulas

All responses (12)

Answers (1)

s44 691 on at

Like (0)

Report

Re: Color an icon in red if the desktop is already reserved

It's work thank you !!
cwebb365 3,294 Most Valuable Professional on at

Like (0)

Report

Re: Color an icon in red if the desktop is already reserved

Use IsEmpty() instead of IsBlank().
Verified answer

Akser 1,546 Super User 2025 Season 1 on at

Like (1)

Report
Re: Color an icon in red if the desktop is already reserved

Try this:

If(IsBlank(LookUp(Reservation, Date = Calendar_1.StartDate && Numbero_Bureau = 2)), Blue, Red)
s44 691 on at

Like (0)

Report

Re: Color an icon in red if the desktop is already reserved

Thanks ! However, there is a problem. Here, the dot corresponding to office number 2 is red while in my SharePoint list there is no reservation of this office to date. @Akser
Akser 1,546 Super User 2025 Season 1 on at

Like (0)

Report

Re: Color an icon in red if the desktop is already reserved

The date is supposed to be the selected date from the calendar on your Screen1. I'm assuming you know how to find out which date was selected?

Calendar_1.StartDate
s44 691 on at

Like (0)

Report

Re: Color an icon in red if the desktop is already reserved

I have this error : @Akser
s44 691 on at

Like (0)

Report

Re: Color an icon in red if the desktop is already reserved

.
s44 691 on at

Like (0)

Report

Re: Color an icon in red if the desktop is already reserved

Property "Fill" ? @Akser
Akser 1,546 Super User 2025 Season 1 on at

Like (0)

Report

Re: Color an icon in red if the desktop is already reserved

The circle's color property I assume?
s44 691 on at

Like (0)

Report

Re: Color an icon in red if the desktop is already reserved

Thanks ! What property am I writing this in?