Skip to main content

Notifications

Community site session details

Community site session details

Session Id : tq8yMMlc2a2P19K88J1qqj
Power Apps - Building Power Apps
Unanswered

How do i access an Excel file on Sharepoint to use in Power Apps?

Like (0) ShareShare
ReportReport
Posted on 17 Nov 2020 16:11:12 by

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)?

  • timl Profile Picture
    34,955 Super User 2025 Season 1 on 17 Nov 2020 at 17:14:28
    Re: How do i access an Excel file on Sharepoint to use in Power Apps?

    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.

    https://powerusers.microsoft.com/t5/Building-Power-Apps/Excel-Online-business-Connector-how-to-use-in-PowerApps/td-p/265741

     

     

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.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,700 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,015 Most Valuable Professional

Leaderboard
Loading started