Hi @BKGOUD :
Yes. Use this formula to get all available rooms within a specified time. You only need to check whether the specified Room is in the collection named AvailableRoomEmailName.
ClearCollect(
AllRooms,
Office365Outlook.GetRooms().value
);
Set(
AllRoomsConnector,
Concat(
AllRooms,
Address & ";"
)
);
ClearCollect(
AvailableRooms,
Office365Outlook.FindMeetingTimes(
{
RequiredAttendees: AllRoomsConnector,
Start: DateTimeValue("2020-11-25T09:00:00"), /*Assume that the start time of the meeting is 2020-11-25T 09:00:00*/
End: DateTimeValue("2020-11-25T12:00:00") /*Assume that the end time of the meeting is 2020-11-25T 12:00:00*/
}
)
);
ClearCollect(
AvailableRoomsSorted,
SortByColumns(
First(AvailableRooms).MeetingTimeSuggestions,
"Confidence",
Descending
)
);
ClearCollect(
AvailableRoomsConcat,
Concat(
Filter(
First(AvailableRoomsSorted).AttendeeAvailability,
Availability = "Free"
),
Attendee.EmailAddress.Address,
","
)
);
ClearCollect(
AvailableRoomEmails,
Split(
First(AvailableRoomsConcat).Value,
","
)
);
ClearCollect(
AvailableRoomEmailName,
AddColumns(
RenameColumns(
AvailableRoomEmails,
"Result",
"Email"
),
"Name",
LookUp(
AllRooms,
Email = Address
).Name
)
);
Best Regards,
Bof
