Power Platform Community Forum Thread Details

I created a simple powerapp with a dropdown and a gallery.

The dropdown is filled with some calendarnames and the gallery will display all events from the upcoming 2 days of the selected calendar.

The items property of the DropDown control contains the following formula:

Filter(Office365Outlook.CalendarGetTables().value; Or(IsMatch(DisplayName; "uitleen";MatchOptions.Contains); MatchOptions.Contains))

The items property of the Gallery control contains the following formula:

Office365Outlook.GetEventsCalendarViewV3(Dropdown1.Selected.Name;Today();DateAdd(Today();2; TimeUnit.Days);{'$top':10}).value

When the preferred language of Edge (or any other browser) is set to English everything works well and all events of the selected calendar will be displayed.

When the preferred language of Edge (or any other browser) is set to dutch or german (something other than english), the function GetEventsCalendarViewV3 will fail due to an invalid date value.

Office365Outlook.GetEventsCalendarViewV3 mislukt: { "status": 400, "message": "Invalid value '18-11-2024' for parameter 'Start Time'.\r\nclientRequestId: c5d98796-7e5c-4f15-886a-06462e02e321", "error": { "message": "Invalid value '18-11-2024' for parameter 'Start Time'." }, "source": "office365-we.azconn-we-003.p.azurewebsites.net" }

I already tried to force the format of Today() to en-Us format, but that doesn't solve the issue.
Our default system language of Windows is not english, so when the powerapp is installed or displayed in teams no events are displayed and we are getting the above error.

Anyone knows how to resolve this?

Categories:

Building Power Apps