Announcements
Hello. I am wondering if there is a way to update an excel file, that resides in a SharePoint document library, using a power app form? The company i work for does not yet allow to link Power Apps to a drive like One Drive so I wondering is this is an option. I would like to build a form that is connected to an excel file that I have in the library and I want the user to be able to work and update fields within that excel file. Thanks in advance.
Hi @JoshShutts ,
You could use Excel Online (Business) Connector to achieve this.
The Excel Online (Business) Connector allows users to work with Excel files in document libraries that are supported by Microsoft Graph (OneDrive for Business, SharePoint sites (preview), and Microsoft 365 Groups).
1. Here is my excel in SharePoint Document library.
2. Here is my App.
Here is a link for your reference.
https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-excel
Best Regards,
Charlie Choi
Hi Charlie. This definitely is taking me in the right direction it appears but I am receiving an error saying the table didn't load correctly and the service rate limit has been reached. Not sure if that's something on my end
Is the error still occurs?
It seems that a temporary problem.
Here is a link that for your reference:
http://powerappsguide.com/blog/post/excel-service-rate-limit
Best Regards,Charlie Choi
I actually figured out my problem. I was converting the whole excel sheet to a table instead of just the data. This worked perfect. Thanks Charlie!
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 505
WarrenBelz 502 Most Valuable Professional
Haque 324
