You’re offline. This is a read only version of the page.
Power Apps can pull information directly from an Excel file that's saved in OneDrive, however i cannot find a way to do the same for an Excel file saved on Sharepoint. The only option a Sharepoint connection gives me is a list, however i don't believe using an app to update a list will in turn update the fields on the Excel file as far as i'm aware.
The Excel file i need to update using the Power App is saved on the company's Sharepoint, so all can access, so the use of a personal OneDrive is out of the question in this instance.
Is there a way to do this without using OneDrive or Lists(or can lists actually operate in the way i want)?
Hi @Anonymous
Unfortunately, there is no way to directly access Excel files that are saved in SharePoint.
The closest workaround is to use the Excel Online Business connector.
https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/
The caveat to this is that this connector isn't directly supported by Power Apps. Therefore, you will need to write Flows in Power Automate to carry out data access, and to call those close from Power Apps.
Share
Report
All responses (
Answers (
37,210
