I have made a ticket system App in PowerApps, and have regulary problems with Excel database stored at OneDrive.
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.
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?
Ole Jacob Birkeland
@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.
Check out these cool Power Apps & vote on your favorite!
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021