cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.

 

0 REPLIES 0

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (24,788)