Multiple inconsistences with Date and Time as well Value

(0) Share

Report

Posted on by LeoGS

115

Hello community,

I am facing some inconsistencies for the way Date & Time and Values are displayed across different platforms.

I attached a picture showing what I mean.

In the Web-Editor, I see the "score" of my App being displayed as I want: no decimal cases after a comma and a % symbol. When I run the app in my Android, in a Apple device or in the Windows Version of PowerApp, I see what you see in the screen left: a round-up 38% is shown as "37500 %" for example.

Furthermore I also see a lot of inconsistency with Date & Time formats (see the red arrows). There you see three different formats for the time (one made with the web-editor, one with the Windows App and one with my Android device). My bet here is that the date and time are following the system format and being passed as a String, not a Date and Time value.

How can I fix it? Thanks a lot for the help!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Was this issue fixed? I seem to be having the same issue where mobile phones are submitting different static dates to SharePoint while web App is submitting the correct date.

Was this reply helpful? Yes No
LeoGS 115 on at

Like (0)

Report
Copy link

Link copied!

Yes, totally!
The biggest problem on my approach was using MS Excel as database / data source. I learnt this can be the worst idea ever. Excel had a lot of trouble to understand what is what (boolean, date time, text, number). I changed everything to MS Sharepoint a while ago I never had a problem concerning it again, every value is saved in a "universal way" when the user saves the app, and the app will load this value and automatic "translate" into the user's interface (for example, 17/06/2022 will be displayed 06/17/2022 if EN-EN is the language, 17.06.2022 if DE-DE and 17/06/2022 if PT-BR).

Anyway, thanks!
If you could help me further with another topic, I would really appreciate!
https://powerusers.microsoft.com/t5/Building-Power-Apps/Compressing-images-added-via-quot-AddMediaButton-quot-to/m-p/1626297#M415239

Was this reply helpful? Yes No
LeoGS 115 on at

Like (0)

Report
Copy link

Link copied!

Now I see you are facing similar problem.
Can you share your code please?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This is the date being submitted from mobile devices, while the WebApp submits the current and correct date. So I am assuming the issue is isolated and not from the code end.

Was this reply helpful? Yes No