Announcements
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.
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.
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?
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 101 Most Valuable Professional
Haque 81
VASANTH KUMAR BALMADI 70
