Hi All,
I have had an app running successfully for months and suddenly today it has come up with an error stating.
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.
If any one has any ideas I would really appreciate the insights.
Thanks!
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
)*/
The rollout fix has solved my issue!
User | Count |
---|---|
257 | |
108 | |
93 | |
57 | |
40 |