Power Platform Community Forum Thread Details

Hi,
I'm currently facing a confusing problem with my canvas app.

The following code is responsible to fetch available rooms for urgent meetings so you can book them.

Screenshot 2023-03-30 122400.png

As you can see the code accepts the highlighted date syntax.

Once I execute this It performs the operation perfectly and fetches the right data:

Screenshot 2023-03-30 122503.png

However, these are obviously static inputs with the data type of string.

So naturally I would like the input to be dynamic.

The user does not have to input a date nor time since he's in a rush.

I would like to fetch rooms available starting from the moment he clicks on "meet now" button until the next 60 or 120 minutes.

So, I used the following:

Screenshot 2023-03-30 123034.png

See the red line, the exact acceptable format with the exact data type so naturally this should also fetch Data.

But nope I get this instead:

Screenshot 2023-03-30 123217.png

Empty gallery with no errors whatsoever.
Would appreciate some help.

Categories:

Building Power Apps

Set(
 StartDateTimeUTC,
 Text(Now(),DateTimeFormat.UTC)
);
Set(
 EndDateTimeUTC,
 Text(DateAdd(Now(),2,TimeUnit.Hours),DateTimeFormat.UTC)
);
ClearCollect(
 AvailableRooms,
 Office365Outlook.FindMeetingTimes(
 {
 RequiredAttendees: Concat(
 Office365Outlook.GetRoomsInRoomList(SelectedLocation).value,
 Address & ";"
 ),
 IsOrganizerOptional: true,
 Start: StartDateTimeUTC,
 End: EndDateTimeUTC,
 MeetingDuration: DateDiff(
 StartDateTimeUTC,
 EndDateTimeUTC,
 TimeUnit.Minutes
 ),
 MinimumAttendeePercentage: "1",
 ActivityDomain: "Unrestricted"
 }
 )
);
ClearCollect(
 AvailableRoomsFree,
 Concat(
 Filter(
 First(First(AvailableRooms).MeetingTimeSuggestions).AttendeeAvailability,
 Availability = "Free"
 ),
 Attendee.EmailAddress.Address,
 ","
 )
);
ClearCollect(
 AvailableRoomEmailName,
 AddColumns(
 RenameColumns(
 ForAll(
 Split(
 First(AvailableRoomsFree).Value,
 ","
 ),
 {Result: ThisRecord.Value}
 ),
 "Result",
 "Email"
 ),
 "Name",
 LookUp(
 Office365Outlook.GetRoomsInRoomList(SelectedLocation).value,
 Email = Address
 ).Name
 )
); Navigate(testpage)
;Navigate(AvailableRoomsPage,ScreenTransition.UnCover)

This is what the code looks like if anyone wondering.
Selected location is a dynamic email address with data type string.