web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Color an icon in red i...
Power Apps
Answered

Color an icon in red if the desktop is already reserved

(0) ShareShare
ReportReport
Posted on by 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 :

s44_0-1662471338731.png

 

 

Screen 2 :

s44_1-1662471374615.png

 

 

SharePoint List :

s44_3-1662471706279.png

 

"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:
I have the same question (0)
  • Hii_iii Profile Picture
    691 on at

    .

  • Akser Profile Picture
    1,546 Moderator on at

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

  • Hii_iii Profile Picture
    691 on at

    Thanks ! What property am I writing this in?

  • Akser Profile Picture
    1,546 Moderator on at

    The circle's color property I assume?

  • Hii_iii Profile Picture
    691 on at

    Property "Fill" ? @Akser 

  • Hii_iii Profile Picture
    691 on at

    .

  • Hii_iii Profile Picture
    691 on at

    I have this error : @Akser 

    s44_0-1662475743668.png

     

  • Akser Profile Picture
    1,546 Moderator on at

    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

  • Hii_iii Profile Picture
    691 on at

    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 

    s44_0-1662476724704.png

     

    s44_1-1662476838736.png

     

     

  • Verified answer
    Akser Profile Picture
    1,546 Moderator on at

    Try this: 

     

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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 337 Most Valuable Professional

#2
11manish Profile Picture

11manish 173

#3
Valantis Profile Picture

Valantis 86

Last 30 days Overall leaderboard