cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Excel database format switch

Hi,

 

I created a Leave Request app for my company with a PowerApps Canvas app. The database is an Excel file stored in OneDrive.

In my company, workers are allowed to take "hour-based" leaves, and every worker has its own number of hours allowed, which can include decimals (for instance, a worker can at most take 13,2 hours of leave).

 

Therefore, in my database, I have a column with decimal numbers stored in European format - where the decimal delimiter is a comma. I configured OneDrive, Excel, and PowerApps correctly to be able to support the comma decimal delimiter.

 

Today, after a few weeks of usage of the application in the company, I dived into the database and found out that the database is in a complete mess, as if it ignored the comma delimiter (for instance, instead of 13,2 hours, it shows 132 hours). I suspect this is because some workers in the company are not European and are using the app on a smartphone that is set up with a language whose decimal delimiter is not a comma.

 

Are you familiar with this issue? Is there something I can do to prevent this from happening?

Please note that the app only has to read data in that particular column. It writes in another column.

 

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,950)