Unanswered

Check Room is Busy or Available

(0) Share

Report

Posted on 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.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Fouad 59 on at

Like (0)

Report
Copy link

Link copied!
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
v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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 at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Fouad 59 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report
Copy link

Link copied!

Did you ever find a solution for this?

Was this reply helpful? Yes No
Sumaira 642 on at

Like (0)

Report
Copy link

Link copied!

@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 at

Like (0)

Report
Copy link

Link copied!

@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
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
WilAiAm 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No