Power Platform Community Forum Thread Details

Hi Everyone,

I'm trying to make the Save Button in the Adjust Date Screen filter conference rooms to show only the ones that begin with TSI. I put the same code on the Book without a Meeting button on the LandingScreen. It works there but not on the Save Button. Here's what I have for the Save Button (I also want it to filter out one named TSI Conference Rooms once it filters to just ones that start with TSI)

ClearCollect(AvailableRooms, Office365.FindMeetingTimes({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));

UpdateContext({ShowLoading: false});

Set(RoomsLeft, CountRows(AllRooms) - 20 * AvailableRoomsCounter)

);

ClearCollect(AvailableRoomEmails, Split(First(AvailableRoomsConcat).Value, ","));

ClearCollect(

AvailableRoomEmailName,

Filter( AllRooms, StartsWith(Name, "TSI") );

);

Navigate(RoomSelectScreen, Cover)

Categories:

Building Power Apps

Hi @BenjaminMartin1 ,

Please try below codes:

ClearCollect(AvailableRooms, Office365.FindMeetingTimes({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, Filter(AddColumns(RenameColumns(AvailableRoomEmails, "Result", "Email"), "Name",
 LookUp(AllRooms, Email = Address).Name),StartsWith(Name, "TSI"));
 UpdateContext({ShowLoading: false});
 Set(RoomsLeft, CountRows(AllRooms) - 20 * AvailableRoomsCounter) 
);
 Navigate(RoomSelectScreen, Cover)

If you would like to filter rooms' names that contain TSI, use ["TSI" in Name] as the criteria instead of using [StartsWith(Name, "TSI")] within the collection "AvailableRoomEmailName" creation.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.