I have a calendar view as follow:-
and when the user select a date >> and click on add a new entry inside the calendar >> a popup will be shown, here is the formula inside the submit:-
Clear(CollSelectedDaysDetails);
Clear(NewWFHEntry);
ForAll(
collCheckedDays,
Collect(
CollSelectedDaysDetails,
{
SelectedDate: ThisRecord.Value,
SelectedStartTime: Text(
DateAdd(
DateValue(ThisRecord.Value),
If(
tgAllDayEvent_1.Value,
ddlHalfDayPart_1.Selected.StartMinutes,
ddlStartTimeBulk.Selected.Minutes
)
,
TimeUnit.Minutes
)
,
DateTimeFormat.UTC
),
SelectedEndTime: Text(
DateAdd(
DateValue(ThisRecord.Value),
If(
tgAllDayEvent_1.Value,
ddlHalfDayPart_1.Selected.EndMinutes,
ddlEndTimeBulk.Selected.Minutes
),
TimeUnit.Minutes
)
,
DateTimeFormat.UTC
)
}
)
);
ForAll(
CollSelectedDaysDetails,
Collect(NewWFHEntry,
Patch(
WorkFromHomeEntry,
Defaults(WorkFromHomeEntry),
{
StartTime: ThisRecord.SelectedStartTime,
EndTime: ThisRecord.SelectedEndTime,
Title:User().FullName,
WFHDate:DateValue(ThisRecord.SelectedDate),
Country: ddlCountryBulk.Selected.Result,
Department: ddlDepartmentBulk.Selected.Result,
Notes: txtNotesBulk.Text,
IsAllDayEvent:tgAllDayEvent_1.Value
}
);
);
Refresh(WorkFromHomeEntry);
Clear(collCheckedDays);
UpdateContext({varShowReservationPopUp: false});
but when using Edge, if for example i select the value 20 September 2023 then it will be saved inside the SharePoint list named WorkFromHomeEntry as 9 august 2024 ?? so what could be the reason ? while the date will be added correctly when using chrome..
Thanks
