Updating excel files within a document library

[JoshShutts]

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.

[v-yujincui-msft · Accepted solution]

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

[JoshShutts]

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

[v-yujincui-msft]

Hi @JoshShutts ,

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

[JoshShutts]

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!