Date value changes when submitting form

[Anonymous]

Hi!

Does anyone know why a date value changes when submitting a form?

It doesn't always happen. I think it depends on the device being used.

One user made a transaction with 4/17/20, but when she went back to the transaction and submitted it using its cellphone, the date suddenly became 5/4/21.

Thanks!

[v-siky-msft]

Hi @Anonymous ,

Does this issue only happen on PowerApps Mobile?  

Please share more details about your app? How do you design your app? How do you submit the form? How do you define the Date field? What is the version of PowerApps mobile client? We need more information to reproduce your issue so that to provide further assistance.

If this issue only happens on the Mobile, I would suggest you check the Date and Time setting, and try to update the PowerApps client to the latest version.

If it still doesn't work, please post back more information and screenshots.

Sik

[SumanKoduri]

Check default value for that field

[Anonymous]

@v-siky-msft,

I think it has to do with the phone's date and time settings. I can't reproduce the error.

Anyway, I have another issue about time.

This is my first form. The data source is my head table.

After you submit the next form, this screen has a gallery (details of the header). The data source is another table linked to the head.

If you press Add Details, a form will appear with From Time (datetime), ToTime (datetime), Activity (string) fields. A user created a total of 5 entries in the details (from 8:15 AM to 6:15 PM, not shown in the screenshot)

After submitting the previous form, I have an HTML mail about the details of the transaction.

As you can see here in the email, it shows exactly the time input of the user.

But when the user went back to the app, all of his input suddenly had the wrong time.

Every entry has a +30 minutes.

I think this happened about twice or thrice already.

But in this transaction, the user used a computer, not a mobile phone.

Thank you very much!

[v-siky-msft]

Hi @Anonymous ,

Is there an error in the From Time/To Time field stored in the data source?

Please share the codes and screenshots about how do you input the time and how do you save these two fields into the data source?

If you only want to save time, not date, how about changing the field type to string? It may solve the problem of time difference, but the specific issue still needs to be determined by the code of your app's implementation.

Hope this helps.

Sik

[Anonymous]

@v-siky-msft,

Here's a screenshot of the details form.

It's the default controls for Date/Time values. I only removed the Date control.

I don't think there's an error in my FromTime and ToTime fields because the problem doesn't happen to everyone.

Here's how  I update those fields.

I'm afraid it's too late to change the data type to String because this app is already being used for about 3 weeks now.

Thank you!