Check Room is Busy or Available

Like (0) Share

Report

Posted on 16 Dec 2019 14:08:48 by Fouad

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.

I have the same question (0)

All responses (9)

Answers (0)

WilAiAm 2 on 13 Jun 2024 at 07:03:35

Like (0)

Report

Re: Check Room is Busy or Available

Hi,
I am looking for a similar solution and i am interested in your solution.
grtz, William

Was this reply helpful? Yes No
Community Power Pla... on 29 Apr 2021 at 16:04:49

Like (0)

Report

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.

Was this reply helpful? Yes No
JimmyW 2,563 on 07 Jan 2021 at 14:10:01

Like (0)

Report

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

Was this reply helpful? Yes No
Sumaira 642 on 06 Jan 2021 at 03:14:54

Like (0)

Report

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

Was this reply helpful? Yes No
JimmyW 2,563 on 07 Oct 2020 at 12:48:33

Like (0)

Report

Re: Check Room is Busy or Available

Did you ever find a solution for this?

Was this reply helpful? Yes No
Fouad 59 on 18 Dec 2019 at 16:52:11

Like (0)

Report

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.

image1.PNG

image3.PNG

Was this reply helpful? Yes No
Fouad 59 on 18 Dec 2019 at 16:06:35

Like (0)

Report

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.

image3.PNG

image1.PNG

Was this reply helpful? Yes No
v-xida-msft on 17 Dec 2019 at 04:28:26

Like (0)

Report
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:

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:

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

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

Best regards,

Was this reply helpful? Yes No
Fouad 59 on 16 Dec 2019 at 17:00:31

Like (0)

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

Was this reply helpful? Yes No