Error 500 on Office365.FindMeetingTimes

[Anonymous]

So, I'm using a costumized version of the Book a Room template, and everything is OK for my users.
Today I was making some adjustments, and I can't get available rooms anymore.

Thinking it could be an error raised by my modifications, I started with the clean template, and the error remains:

Anywhere has any ideia where I should start looking?

I'm guessing it's something on the date format, probably, but when I look at variables I see nothing different from the live version (that I have restored).

[v-xida-msft]

Hi @Anonymous ,

Based on the error message that you mentioned, it seems to tell that there is something issue with the Office365.FindMeetingTimes() function in your app.

I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:

Please check if the Office 365 Outlook connection you created within your app is valid. Please consider take a try to remove the Office 365 Outlook connection from your app, then re-add a new connection to your Office 365 Outlook with a proper Office 365 account (work or school account, rather than your personal account), try your app again, check if the issue is solved.

If the issue still exists, please consider take a try to re-custom a new app based on the Book a Room template app, check if the issue still exists.

Best regards,

[Anonymous · Accepted solution]

It seems it was some kind of temporary issue, as the day after everything worked with no changes. 
Thank you for replying @v-xida-msft 

[Omardith20]

Hello,

I am currently experiencing this kind of issue. I did not edit or modify anything on my app until when I tried to test it  and then it gave me the same error for FindMeetingTimes.

Thank you

[Omardith20]

"body": {

"error": {

"code": 500,

"source": "msmanaged-na.azure-apim.net",

"clientRequestId": "2b5a7be9-3d52-4fe1-ba39-090a81fdc0e1",

"message": "BadGateway",

"innerError": {

"error": {

"code": "ErrorInternalServerError",

"message": "An internal server error occurred. The operation failed."

}

}

}

}

}

[Anonymous]

Hello. From my original experience with this error, and some after, it seems that it is something on Microsoft side.

Maybe reach out to your available support options, or wait, as it probably will be solved soon.

[Omardith20]

Thank you very much @Anonymous  for your reply. Do you have an idea how long it will take before the Microsoft resolve the issue?

[Staffan]

Today I also got the 500 Bad Gateway exception: 

I found that the book a room powerapps template still  uses a deprecated call to Office365.FindMeetingTimes:

You can change this into Office365.FindMeetingTimesV2 but be sure to adjust more in the app (see the Bold parts in code below) because the casing of the response is different:

ClearCollect(AvailableRooms, Office365.FindMeetingTimesV2({RequiredAttendees: AllRoomsConnector, IsOrganizerOptional: true,
Start: StartDateTimeUTC, End: EndDateTimeUTC,MeetingDuration: DateDiff(StartDateTime, EndDateTime, Minutes),
MinimumAttendeePercentage: "1", ActivityDomain: "Unrestricted"}));

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));

[Omardith20]

Hello Staffan,

Yes, I just realized it when i search again for the powerapps documentation and saw that the FindMeetingTime is already deprecated 

I changed it to V2 and now my apps is working again.

Thank you.

[MaurikRM]

I don't have the Office365.FindMeetingTimesV2, I only see the Office365Outlook.FindMeetingTimesV2. Using this action breaks the following code:

ClearCollect(AvailableRoomsSorted, SortByColumns(First(AvailableRooms).meetingTimeSuggestions, "confidence", Descending));

ClearCollect(AvailableRoomsConcat, Concat(Filter(First(AvailableRoomsSorted).attendeeAvailability, availability = "free"),
attendee.emailAddress.address, ","));