Answered

How to check if conference room is free/busy

(0) Share

Report

Posted on by Bambula

169

Hello, I am working on the Onboarding flow and need advice on checking if the conference is free. If the conference room is taken I would like to book another one but my flow takes the same room . Flow trigger is when the item in SharePoint is created . When the 1st day is the office I would like to check whether the conference is occupied and to book the next available conference room.

Please, can you give me some advice because I'm obviously doing something wrong?

Categories:

Building flows

I have the same question (0)

All responses (19)

Answers (1)

Sort by

Expiscornovus 33,871 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Bambula,

Are you currently using a Find meeting times action in your setup?

Within that action it is possible to use a room in a resource attendees field. The response of that action will tell you if the attendees are available for your meeting (start and end time need to be included). With a condition you can check what the outcome is of this action.

Below is an example.

Check if it has found any meeting suggestions at all.

length(outputs('Find_meeting_times_(V2)')?['body/meetingTimeSuggestions'])

is greater than 0

Check if the empty reason is empty

empty(outputs('Find_meeting_times_(V2)')?['body/emptySuggestionsReason'])

is equal to true

Check if the found slot is 100 confidence score. If it is for example 50 one of the attendees can't make it.

outputs('Find_meeting_times_(V2)')?['body/meetingTimeSuggestions'][0]['confidence']

is equal to 100

Was this reply helpful? Yes No
Bambula 169 on at

Like (0)

Report
Copy link

Link copied!

hi @Expiscornovus, I try to find a meeting but still create the meeting in only one room.

There's no way he can make me a meeting for the south even though the north is busy. It makes me 3 the same meetings still. This is part of the Onboarding app when in SharePoint list item is created.
After that when is AutoSchedule true I would like to check conference rooms and in the free room create a meeting.

Variable for conference rooms

Was this reply helpful? Yes No
Expiscornovus 33,871 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Bambula,

Apologies, the solution I suggested checks one conference room at the time for availability.

Let me have a look if I can change the configuration to facilitate checking two or more conference rooms.

Was this reply helpful? Yes No
Expiscornovus 33,871 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Bambula,

I would use a split on the Conference room variable with the ; character. Loop through the results of the split and check per room if it has a 100% confidence match. If so, book the meeting for that attendee and room mailbox.

Below is the adjusted approach.

I used this for the split

split(variables('RoomMailbox'), ';')

And I am using item to refer to each room within the loop.

item()

Was this reply helpful? Yes No
Bambula 169 on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus It's working for me thank you.

Now I have only one problem, events are created in all conference rooms.
I need to check the availability of Conference rooms and avoid conflicts. This I use if the new employee is first-day location office. If somebody has already been taken conference room two events are created in the same conference room.
These are events from my onboarding app.

Was this reply helpful? Yes No
Expiscornovus 33,871 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Bambula,

That is not what I expected from this setup 😅

When the first free meeting room (say Room A) is found the event will be booked for both the attendee and the room.

When it loops and tries to do the same for the next room (Room B) in the loop I would expect every option to come back with a confidence of 50 because the attendee is already booked for that same time in Room A.

The same rule applies for the resource attendee (room). If it is already booked it should come up at 50 or even lower.

Can you share your flow run history?

Was this reply helpful? Yes No
Bambula 169 on at

Like (0)

Report
Copy link

Link copied!

hi @Expiscornovus , here is my flow history
This is in a test environment when the flow will work I will migrate it to my onboarding flow.

Was this reply helpful? Yes No
Expiscornovus 33,871 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Bambula,

Apologies, I need to be a bit more specific. I was talking about the details of your flow run.

I am interested in the output of the Meeting time suggestions field of each item in your apply to each loop. Also see the animation below how you can find that.

Was this reply helpful? Yes No
Bambula 169 on at

Like (0)

Report
Copy link

Link copied!

hi , @Expiscornovus I'm sorry my bad.
here is run history
ty you for helping me .

Was this reply helpful? Yes No
Expiscornovus 33,871 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Bambula,

In this example it cannot create an event at all, because the organizer already is busy.

Btw, I did not notice before. But I see you have an create event (v4) 4 action in the If No section.

Can you please remove that action. That action is not needed. You only want to create an event if the "room is free" conditions are met (If Yes), correct?

Was this reply helpful? Yes No