cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tia
Resolver I
Resolver I

Office365outlook.findavailablemeetings sudden error

Hi All, 

 

I have had an app running successfully for months and suddenly today it has come up with an error stating. 

Tia_0-1665451173127.png

The Organizer has always been required as optional as I have a team of people booking meetings for other teams. Nothing in my coding has changed but this error has now put the ability to book at a stand still.

Concurrent(
ClearCollect(MeetingGroup1,AddColumns(Office365Outlook.FindMeetingTimesV2
({
MaxCandidates:20,
MinimumAttendeePercentage:1,
MeetingDuration:MeetingDurationSelection.SelectedText.Minutes,
Start:Text(DateAdd(DatePickerDesiredDate.SelectedDate,MeetingStartRange.SelectedText.Minutes,Minutes),UTC),
End:Text(DateAdd(DatePickerDesiredDate.SelectedDate,MeetingEndRange.SelectedText.Minutes,Minutes),UTC),
RequiredAttendees:Concat(PeopleGroup1,'Email'&";"), 
ActivityDomain: "Unrestricted", isOrganizerOptional: false})
.meetingTimeSuggestions,"StartTime",meetingTimeSlot.start.dateTime,"EndTime",meetingTimeSlot.end.dateTime)),

ClearCollect(MeetingGroup2,AddColumns(Office365Outlook.FindMeetingTimesV2
({MaxCandidates:20,
MinimumAttendeePercentage:1,
MeetingDuration:MeetingDurationSelection.SelectedText.Minutes,
Start:Text(DateAdd(DatePickerDesiredDate.SelectedDate,MeetingStartRange.SelectedText.Minutes,Minutes),UTC),
End:Text(DateAdd(DatePickerDesiredDate.SelectedDate,MeetingEndRange.SelectedText.Minutes,Minutes),UTC),
RequiredAttendees:Concat(PeopleGroup2,'BSL Email'&";"), 
ActivityDomain: "Unrestricted", IsOrganizerOptional: false})
.meetingTimeSuggestions,"StartTime",meetingTimeSlot.start.dateTime,"EndTime",meetingTimeSlot.end.dateTime)));

It appears to error out on the second clearcollect set of information from addcolumns but removing this section doesnt solve the issue as it is still unable to grab the employees availability. 

 

It now seems to grab only the top persons information and everyone else comes through as "unknown".. I'm at a loss as it was working perfectly yesterday.

Tia_1-1665451357584.png

If any one has any ideas I would really appreciate the insights. 

Thanks!

11 REPLIES 11

Try adding the code below to the OnVisible, then it's a case of using firsts to get to the nested tables, the gallery should have this as it's "Items": Filter(AvailableRooms2, IsBlank(First(MeetingTimeSuggestions).Confidence) = false)


This would give you the room name for example:
LookUp(AllRooms,Address = First(First(ThisItem.MeetingTimeSuggestions).AttendeeAvailability).Attendee.EmailAddress.Address, Name)

ONVISIBLE CODE:

Set(
CalendarFromSelectMeeting,
false
);
If(
DateTimeRoomChange,
Set(
AvailableRoomsCounter,
1
);
UpdateContext({ShowLoading: true});
Set(
RoomsLeft,
Blank()
);
Set(
DateTimeRoomChange,
false
);
If(
!NoRoomsList,
ClearCollect(
AllRooms,
Office365.GetRoomsInRoomList(RoomsListsGallery.Selected.Address).value
)
);
If(
CountRows(AllRooms) > 20,
Set(
AllRoomsConnector,
Concat(
FirstN(
AllRooms,
20
),
Address & ";"
)
),
Set(
AllRoomsConnector,
Concat(
AllRooms,
Address & ";"
)
)
);

Clear(AvailableRooms);
ForAll(AllRooms,
Collect(
AvailableRooms,
Office365.FindMeetingTimes(
{
RequiredAttendees: ThisRecord.Address,
IsOrganizerOptional: true,
Start: StartDateTimeUTC,
End: EndDateTimeUTC,
MeetingDuration: DateDiff(
StartDateTime,
EndDateTime,
Minutes
),
MinimumAttendeePercentage: "1",
ActivityDomain: "Unrestricted"
}
)));
UpdateContext({ShowLoading: false}));

ClearCollect(AvailableRooms2, Filter(AvailableRooms, IsBlank(ThisRecord.MeetingTimeSuggestions) = false));
ClearCollect(Locations,
AddColumns(
Office365.GetRooms().value,
"location",
If(
IsBlankOrError(Office365Users.UserProfile(Address)),
"test",
Office365Users.UserProfile(Address).OfficeLocation
)
))

/*
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
)
)
);
/*
If(
CountRows(Office365.GetRooms().value) > 0,
ClearCollect(
AvailableRoomEmailName,
AddColumns(
Office365.GetRooms().value,
"location",
If(
IsBlankOrError(Office365Users.UserProfile(Address)),
"test",
Office365Users.UserProfile(Address).OfficeLocation
)
)
)
);
UpdateContext({ShowLoading: false});
Set(
RoomsLeft,
CountRows(AllRooms) - 20 * AvailableRoomsCounter
)*/

Tia
Resolver I
Resolver I

The rollout fix has solved my issue!

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,031)