cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alexlrca
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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,732)