Check Room is Busy or Available

[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.

[Fouad]

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)

[v-xida-msft]

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,

[Fouad]

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.

[Fouad]

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.

[JimmyWork]

Did you ever find a solution for this?

[Sumaira]

@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 

[JimmyWork]

@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

[Anonymous]

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.

[WilAiAm]

Hi,

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

grtz, William