Hi all,
Hope this will make sense!
I have a desk booking app that allows users to book a desk in one of our offices and once the desk has been booked for the date specified (chosen by a date picker control) it will create an entry in a SharePoint list, blocking out the desk for everyone else.
However, I'm running into an issue where a couple of users must have some funky region/date settings which means that their desk bookings do not appear to other users and vice versa.
For example, 99% of our staff will book a desk and it will appear in the SharePoint list correctly like the item marked in green. dd/MM/yyyy.
For a select few, it appears either like the orange highlighted item, or some other formatting that does not follow the dd/MM/yyyy format we need.
How can I within the app, format the Date Variable to use dd/MM/yyyy, here is the formula in use, you can see the BookingDate variable set at the bottom and used in the Title & BookingDateText below:
Set(
requesterClaim,
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & User().Email,
Department: "",
DisplayName: User().FullName,
Email: User().Email,
JobTitle: "",
Picture: ""
}
);
Patch(
DeskBookings,
Defaults(DeskBookings),
{
Title: DeskNumber & " " & User().FullName & " " & BookingDate,
'Booking Date': BookingDate,
Person: requesterClaim,
DeskText: DeskNumber,
BookDateText: BookingDate
}
);
Navigate(
ScreenBookingSuccess,
ScreenTransition.None,
{
BookingDate: BookingDate,
DeskNumber: DeskNumber
}
);
Set(
DeskNumber,
Blank()
);
Set (
BookingDate,
Blank()
);
Set (
varDialogVisible,
false
)
Any help is massively appreciated!
