cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BKGOUD
Helper III
Helper III

FindMeetingTimes issue

Hi All,

Is it possible to check the meeting room conflicts by using FindMeetingTimes connector in PowerApps. Can someone please let me know if anyone implement this requirement.

 

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

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

View solution in original post

3 REPLIES 3
v-bofeng-msft
Community Support
Community Support

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

Hi @v-bofeng-msft,

 

Thanks for helping me.

 

I want to create the recurring meeting but before creating the meeting I want to display the conflict dates for selected period. I have tried to get the conflict dates but FindMeetingTimes connector not returning busy rooms. But the same code returning free rooms. 

Can you please help me on this.

Hello, here is a question for you about this code, does it solve the problem with the FindMeetingTimes function that does not allow us to select any time slot out of an o'clock hour or a half hour? If so, where do I have to put this code?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,811)