Answered

Color an icon in red if the desktop is already reserved

(0) Share

Report

Posted on by Hii_iii

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:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Hii_iii 691 on at

Like (0)

Report

.

Was this reply helpful? Yes No
Akser 1,546 Moderator on at

Like (0)

Report

If(IsBlank(LookUp(Reservation, Date = The date that was selected by the user in 1st screen, Numbero_Bureau = The room number)), Blue, Red)

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

Thanks ! What property am I writing this in?

Was this reply helpful? Yes No
Akser 1,546 Moderator on at

Like (0)

Report

The circle's color property I assume?

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

Property "Fill" ? @Akser

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

.

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

I have this error : @Akser

Was this reply helpful? Yes No
Akser 1,546 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Akser 1,546 Moderator on at

Like (1)

Report
Try this:

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

Was this reply helpful? Yes No