cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Excel workbook stored at OneDrive gets corrupted and number formatting changes

I have made a ticket system App in PowerApps, and have regulary problems with Excel database stored at OneDrive.

 

Issue 1.

Quite often the date format chages from date to XXXXXXXXXXXXX. Get an error message when trying to open the database in Powerapps telling that date format is wrong. When I open the Excel sheet, all data in the Date colomn has changed to X's. It is not possible to change the format back to Clock, and I need to revert back to previous version of the Excel database to solve this.

 

Issue 2

2-3 times a week all number formatting of the Excel columns changes to General, and PowerApps can't reed the information from the row. THen I have to open the Excel sheet and manually change the format back to Number. This happens for all rows in the sheets containing numbers, even if no data is written to this cell.

 

We experience quite unstability with using an excel as database for PowerApps. Is ther any known fix for these problems?

 

Kind regards
Ole Jacob Birkeland

3 REPLIES 3
Highlighted
Helper I
Helper I

Re: Excel workbook stored at OneDrive gets corrupted and number formatting changes

I'm having the same problem. Have you found a solution? @ojbirke 

Highlighted
New Member

Re: Excel workbook stored at OneDrive gets corrupted and number formatting changes

@Jgreen01  Unfortunately, this is still an issue. I have not got any solution to this, except to use another database as source. If you make the app with Sharpoint as database, this is not an issue.

Highlighted
Helper I
Helper I

Re: Excel workbook stored at OneDrive gets corrupted and number formatting changes

Thanks, I am looking into getting a Share Point list as my data base now.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (9,820)