I used the template "Leave Request" and customized it for our needs but the datasource is still the original excel file in my OneDrive and shared with the users. Our location is in French Canada.
I was almost ready for a GoLive with this App but during a stress test with multiple users testing it with multiple inputs, an issue occured at two different location :
- The first one is on the sheet "Leave" where the cells StartDate and EndDate that had the default format to Custom with a value like "2019-03-28 04:00:00" then the format has been changed to General with a value like "4.3536E+14". When i set the format back to what is was originally i got now "##############" or "434672083333333". I had to restore the file with previous version to get the right format with the right value.
- The second one is on the sheet "Holidays, where the column StartDate (renamed as OffDate) got its format changed from Date with the value "2019-04-19" to General with the value "43574". For this one if i set back the format to Date i got well the right value and no need to get a restore from a previous version.
The StartDate and EndDate from the Leave Value are data sent by PowerApps to the excel file regarding the user's input. So i could understand there is some criteria on the user side that could influent how the data is transfered even if for a same user the date transfered from his input were correct and then for X reason the data format is altered.
On the other side, the StartDate (renamed as Offdate) from the sheet Holiday are data that are only read by PowerApps and then there is no write normally so don't understand either why it is altered after.
