cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Error 500 on Office365.FindMeetingTimes

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:

bookcleantemplate.png



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

1 ACCEPTED SOLUTION

Accepted Solutions

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 

View solution in original post

9 REPLIES 9
Community Support
Community Support

Hi @rdfrocha ,

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:3.JPG

 

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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 

View solution in original post

Frequent Visitor

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

"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."
}
}
}
}
}

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.

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

New Member

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

 

 

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.

New Member

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

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (8,499)