cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Error reading Excel file from Powerapps

Hi guys,

 

Hope you can help with the following issue.

 

I have a PowerApps based on Excel Online file. Everything was going Ok but since a few days ago I'm getting this error when I open my app "not a legal oleaut date"

 

Any idea about this? I'm sure that everything on date fields on the excel are actually date and I tried to reload the file to OneDrive and then refreshing the PowerApps Connection but nothing

 
 

 

Powerapp error.jpg

1 REPLY 1
Highlighted
Power Participant
Power Participant

Re: Error reading Excel file from Powerapps

@CP0822 

 

Try:

 

  1. Clear Cookies and Cache, and retry
  2. Remove and re-add the data source from PowerApps, then retry #1, then retry it.
    1. Also, after doing this, try clicking the refresh icon a few times in PowerApps Maker as well.
  3. Remove the Excel Online connection, and then if needed recreate the Connection by removing the connection under make.powerapps.com -> Data -> Connections -> Find Excel Online Connection -> Use Ellipses ->  Remove Excel Online Connection., then retry #2, then retry #1, then retry it.

 

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (11,354)