Unanswered

app is showing error

(0) Share

Report

Posted on by yougan

262

After brining excel file one drive business to PowerApps, I don’t see data as expected instead giving below error. Please help where it went wrong, PFA. Thank u.

Categories:

Building Power Apps

Capture.PNG

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 153,007 Most Valuable Professional on at

Like (0)

Report

Hi @yougan ,

Someone has the Excel file opened - it must be closed (only opened by Power Apps) to access the data.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
yougan 262 on at

Like (0)

Report

Hi Warren Belz,

Thank you for the prompt response. It worked.

One question: I noticed when I do changes in the PowerApp it is reflecting in the excel from one drive as it is associated with it, but if i change data/update in excel from one drive it is not reflecting in the Power app, why?
in case if it needs to be reflected in app what we need to do?

Was this reply helpful? Yes No
WarrenBelz 153,007 Most Valuable Professional on at

Like (1)

Report

Hi @yougan ,

If you use Excel as a data source (which is not the best solution if you have SharePoint available), then it really only should be used from Power Apps. This is particularly relevant if you are adding new records.

If you have SharePoint available, you can update in either and the changes are instantly reflected in the other.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No