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

Error when saving with Excel on OneDrive as data source.

I have a very simply app which has an Excel file as data source. There are five fields on the app (one date and four text fields). I built the app using the online wizard, which linked to a simple table in a spreadsheet on OneDrive as data source.

 

The app works okay for a while, and I can add/edit new records using either the online app, the app in Teams or on a mobile.

 

However, after a few uses the following error starts appearing:

Error in implicit conversion. Cannot convert null object (I have attached an image of this error).

This error prevents the adding of new records, or the amending of existing ones. Even if I open an existing record and click save, I get the error - with no change to the underlying data.

 

None of the fields contains null values. The spreadsheet appears fine. It is not locked. All the fields are populated in the spreadsheet for existing records. I can view all records on the app. I therefore cannot understand the reference to null.

 

shentz_0-1594320774039.png

I have not been able to find a single reference to this specific error online and I was hoping this forum would be a good starting point for anyone with ideas about how to fix it.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

So the error is failed to read. Is more than one person using the app, or is the excel file open somewhere? If you added the app in teams it is likely open by more than one person. If it is, the app will fail with that kind of error because the excel file is locked. Excel based apps can only be used by one person at a time. Go to another data source like sharepoint if you need more than a single user. I’ve even locked an excep

based app by myself by having the app open in two places at the same time

View solution in original post

2 REPLIES 2
Super User
Super User

So the error is failed to read. Is more than one person using the app, or is the excel file open somewhere? If you added the app in teams it is likely open by more than one person. If it is, the app will fail with that kind of error because the excel file is locked. Excel based apps can only be used by one person at a time. Go to another data source like sharepoint if you need more than a single user. I’ve even locked an excep

based app by myself by having the app open in two places at the same time

View solution in original post

Thank you for your reply. There is just one user using the spreadsheet and it is not open elsewhere. I will migrate over to SharePoint, though, as per your suggestion because it offers a much more robust way of providing a data source. And it will allow for multiple user access if and when required in the future.

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

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

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (16,743)