cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rdfrocha
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
v-xida-msft
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

Omardith20
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?

Staffan
Regular Visitor

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.

MaurikRM
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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (54,126)