Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Check Room is Busy or Available

(0) ShareShare
ReportReport
Posted on by 59

Dear Community,

 

I'm trying to create a app that shows a red or green bullet if a room in our organization is either available or busy. All our calendar rooms are open to see if there are scheduled events. I am sure that I need to add the Office 365 Outlook connector to make this happen. However I don't know what command I need to use to make this happen.

 

Help would be appreciated.

 

  • WilAiAm Profile Picture
    WilAiAm 2 on at
    Re: Check Room is Busy or Available

    Hi,

    I am looking for a similar solution and i am interested in your solution.

    grtz, William

  • Re: Check Room is Busy or Available

    Hi, I was looking same solution. Did you find the solution for this? If Yes, please share some details. It will help us a lot.

    Thank you in advance.

  • JimmyW Profile Picture
    JimmyW 2,563 on at
    Re: Check Room is Busy or Available

    @Sumaira I did modify the Room Booking app, using a Timer to check if the room was available or not each 30min and set a refresh button they can run if needed to refresh faster, never used it but it worked fine for showing available rooms

  • Sumaira Profile Picture
    Sumaira 642 on at
    Re: Check Room is Busy or Available

    @Fouad @JimmyWork @v-xida-msft If you have any solution for this please do share 

    I'm looking for similar functionality

    Thanks @Fouad @JimmyWork @v-xida-msft 

  • JimmyW Profile Picture
    JimmyW 2,563 on at
    Re: Check Room is Busy or Available

    Did you ever find a solution for this?

  • Fouad Profile Picture
    Fouad 59 on at
    Re: Check Room is Busy or Available

    I want a Live list of the availability of our room calendars not our personal Outlook calendars. So I can split them up in Available or Busy and then I would be able to make a Green or Red circle out of that code.

     

    I have in the attachments a few pictures for a better view. Help to the right direction would be appreciated.

  • Fouad Profile Picture
    Fouad 59 on at
    Re: Check Room is Busy or Available

    Actually that was a good advice. Book a Room has a feature that shows the availability of a room during the day. I've done a little experiment and tried to get the same thing working. Thing is I want the circle red if the room is busy or green if the room is available.

    I have to ability to get all the room emailadresses viewed...

     

    Thing now is I need to see if the room has scheduled events and if they're scheduled then the circle should be red.. if not available.

     

    Would love to see some more help to the right direction here. Something in the direction of getting data from SharePoint if possible.

  • v-xida-msft Profile Picture
    v-xida-msft on at
    Re: Check Room is Busy or Available

    Hi @Fouad ,

    Could you please share a bit more about your scenario?

    Do you want to list available Calendar Rooms of your Outlook in your PowerApps app?

     

    If you want to list available Calendar Rooms of your Outlook in your PowerApps app, I think the Office365Outlook.GetRoomsV2() function could achieve your needs.

    I have made a test on my side, please consider take a try with the following workaround:

    2.JPG

    Add a Dropdown control in your app, set the Items property to following:

    Office365Outlook.GetRoomsV2().value

    set the Value property to name.

     

    In addition, I think the "Book A Room" or "Book a Room (new)" template app in PowerApps could help in your scenario:

    3.JPG

    Within the OnVisible property of the RoomSelectScreen, you will find the formula to look up for available rooms in your Outlook:

    4.JPG

     

    Please consider take a try with above template app, then check if it could help in your scenario.

     

    Best regards,

  • Fouad Profile Picture
    Fouad 59 on at
    Re: Check Room is Busy or Available

    I can't seem to find a command that shows a specific room mail adress, I can only view my calendar by

     

     

     

    Office365Outlook.CalendarGetTables().value

     

     

    Things I've tried

     

    • Skype for Business connector - Limited amount of commands (still in preview)
    • Tried adding the room address to my standard calendar (but it doesn't show in PowerApp)

     

    image2.PNG

     

    image1.PNG

     

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard