Error reading Excel file from Powerapps

(1) Share

Report

Posted on by CP0822

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

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@CP0822

Try:

Clear Cookies and Cache, and retry
Remove and re-add the data source from PowerApps, then retry #1, then retry it.
Also, after doing this, try clicking the refresh icon a few times in PowerApps Maker as well.
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.

Was this reply helpful? Yes No
vsolfjeld 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Im struggeling with the same issue. Did anyone have a fix on this?
It works fine when I use it, but when a manager or someone else in my organization use it, i get a OleAut Error message.

Best regards,
Vetle

Was this reply helpful? Yes No
CP0822 66 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

This was an old issue, my recommendation is not to use Excel files with PowerApps.

It runs better with Sharepoint lists.

Was this reply helpful? Yes No