Announcements
Hello!
I have been having an issue where I connect my excel from OneDrive for Business to PowerApps. It works wonderfully until I edit the data in the excel in the OneDrive. The data connect is lost and I got to reconnect it and it says the data cannot be found. Currently, I'm building a new app each time, I would love to hear if there is a way to fix it.
Thanks!
@Lukescotr
If someone is editing excel file it get's locked.
I would susggest you use SharePoint list instead of excel file.
You can make Automated flow that sync your excel file with SharePoint list.
This way you won't have issues you have now.
@eisuan thanks for your reply! I have been using OneDrive for Business over SharePoint because I am able to keep to the file more confidential. My issue is that with SharePoint people can find the file that's been shared with them. With the excel on OneDrive, even though I share it with them, I can turn the data white and protect the sheet.
The only issue still is that when I edit the data and then try and refresh or reconnect the data to the PowerApp it does not connect, and I have to create a new app.
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.
11manish 536
WarrenBelz 426 Most Valuable Professional
Haque 305
