Skip to main content

Notifications

Community site session details

Community site session details

Session Id : GRMdVWmiAePvhu9yzxPqY3
Power Apps - Building Power Apps
Unanswered

Connect to Sharepoint Excel

Like (1) ShareShare
ReportReport
Posted on 25 Mar 2020 06:51:31 by

Hi all,

 

I'm relatively new to power app. 

 

I understand that Excel Online (Business) is a relatively new connector that allows linking of data to excel on sharepoint. 

 

I was tasked with creating a userform interphase that would allow the data keyed in the powerapp to be trasnferred over to the excel linked in sharepoint. However, I'm facing difficulties in linking the excel  file to powerapp. I had done the following steps.

 

1. I had clicked on the excel online icon

image.png

 2. It led me to this page and I tried adding a new connection, but the excel online option wasn't present.

image.png

 

I'm not sure on how to move on from here.

 

Any assistance would be appreciated!

Categories:
  • BostonSailor Profile Picture
    150 on 20 Jun 2023 at 00:21:00
    Re: Connect to Sharepoint Excel

    @ninjaryder1st  Excel files in a SharePoint site can absolutely be accessed by PowerApps. I do it all the time for in-house apps used by hundreds of people every day. The "Excel Online (Business)" is the connector I use.  Most of my PowerApps tables are SharePoint lists, as these have better performance and tend to work better when there are lots of different users doing updates. Most of my Excel files are effectively read-only, but they do work for updates as well. One thing I did find is that when I started this, the Excel files were hosted on our very-old corporate SharePoint site, which we have not upgraded in a while. Accessing Excel files on this site did not work. But we also have many departmental and "Teams" SharePoint sites, and Excel files stored there work just fine. 

     

    tl;dr PowerApps can access Excel files stored on SharePoint libraries using the Excel Online (Business) connector.

  • ninjaryder1st Profile Picture
    232 on 19 Jun 2023 at 23:39:55
    Re: Connect to Sharepoint Excel

    Thank you for your response.   Is this to say that an Excel document (with table format) is stored in a Sharepoint Site (Or Teams site as sharepoint site in background) cannot be connected to PowerApps for a data source?   We'd literally have to move the document from Teams/Sharepoint storage (in cloud) to our own OneDrive for Business account (also in cloud)?   Why did Msft not make this available direclty from Shared Teams/SP sites?

  • WarrenBelz Profile Picture
    146,776 Most Valuable Professional on 25 Nov 2022 at 19:42:14
    Re: Connect to Sharepoint Excel

    @Maxim_EU ,

    This is an old thread and Excel has gained some capability since then, but as a Database, Excel is a good Spreadsheet. When you are dealing with Power Apps, the more robust the database (which Power Apps uses for data storage, but does all the calculations and queries itself), the better, particularly when it comes to Delegation capability, record numbers and dates (I am not sure on your comment on date/time as that is another issue with Excel). The only "function" of Excel used by Power Apps is a named Table range with the columns as fields and the rows as records with a very limited field format.

    If you want to pay for the Premium connectors for Dataverse or Azure SQL, then you will have an even better system, but with the "no extra cost" (I won't call it free)  capabilities of O365, SharePoint is a far better and capable "backend" than Excel and my advice from experience is to not even consider unless you have no other choice (SharePoint Lists not available to you).

  • Maxim_EU Profile Picture
    8 on 25 Nov 2022 at 11:43:12
    Re: Connect to Sharepoint Excel

    "so much better than an Excel Table" Uhm, does is now? I'm unsure of what your statement means..

    So far I'm getting very annoyed.., now I'm stuck with the date and time format, I would like to see the following format JJMMDD HH:MM.., no joy. Way to complex apparently..   I imagine this is not what you meant.
    No problem with a different date and time format in Excel!

    Not to start about a consistent 24 hour format..

    I do appreciate your quick reply, thank you!

     

    On a more serious note:

    I'm researching how my clients can continue to work as the have always done in Excel or an alternatives without too much limitations. I keep getting stuck, my simplest ideas are way too much.

    .. and I'm never ever going to tell a client what you just mentioned to me 😉
    They hire me to work with what they created.
    It seems that I need to start focusing on an automated conversion of some sorts, to a dumbed down the data sheet. I do not think I'm going to do that. 

  • WarrenBelz Profile Picture
    146,776 Most Valuable Professional on 25 Nov 2022 at 11:04:12
    Re: Connect to Sharepoint Excel

    @Maxim_EU .

    If you have SharePoint, make a List for the data and it will work so much better than an Excel Table.

  • Maxim_EU Profile Picture
    8 on 25 Nov 2022 at 10:25:08
    Re: Connect to Sharepoint Excel

    I'm facing similar hurdles. I love the idea of what I thought PowerApps could be but I got stranded on weird limitations as the one mentioned here.
    I wish to create a custom form for an Excel file in a SharePoint..

  • BostonSailor Profile Picture
    150 on 12 Aug 2020 at 20:24:05
    Re: Connect to Sharepoint Excel

    I have successfully accessed data in an Excel file on a SharePoint server from PowerApps.  But it's "read only".  There's a connector called "Import From Excel" that creates a read only table in PowerApps from a designated table in Excel. If you're only viewing but not updating, perhaps this will meet your needs.

     

    BostonSailor_0-1597263826681.png

     

  • PJR Profile Picture
    8 on 16 Jul 2020 at 07:36:09
    Re: Connect to Sharepoint Excel

    It is quite strange it won't work like that. My first action in PowerApps immediately comes to a halt by this 😞 

    The thing is my Excel is on SharePoint (Teams) as it should be with other files on that site, so copying it to OneDrive is no solution...

     

    Very annoying it won't work... and disappointing...

     

    John 

  • v-yutliu-msft Profile Picture
    on 25 Mar 2020 at 09:13:52
    Re: Connect to Sharepoint Excel

    Hi @Anonymous ,

    Do you want to connect with excel file?

    I'm afraid it's not supported to connect with excel file in sharepoint.

    For now, you could only get the metadata of the file in sharepoint.

    For example: the file's link, the file's name.

    But file's content is not included.

     

    If you choose "Excel online", you could only connect with excel in one drive currently.

    Then you could get excel content of this file.

    Also, you could consider choose "imported from excel". You could also connect with excel content in this situation.

    But please notice that:
    you will get a static table by choosing this. (Could only view data, can not write data)

     

    To sum up:
    1)use sharepoint connector, can not get excel content

    2)use excel online, could only get excel content in one drive, please upload your excel to one drive

    3)"imported from excel", could get static excel content.

     

     

    Best regards,

  • Community Power Platform Member Profile Picture
    on 25 Mar 2020 at 08:50:08
    Re: Connect to Sharepoint Excel

     Hi @WarrenBelz,

     

    I understand your concerns and views. The Excel Online (Business) is relatively new connector, I think it was just rolled out in the begining of the year and to be frank, there aren't alot of guides to refer to.

     

    To give you a better insight on why I'm trying to use this connector is because I'm currently interning at a company which has purchased premium access to the microsoft programs. They have been storing years of datas in excel located in sharepoint and they hope to integrate the power app system into this excel. Furthermore, the excel acts as a tracking list for them to refer from time to time.

     

    Hence, my need to use this connector in Sharepoint rather than One drive. Furthermore, the company has been only using sharepoint sites instead of One drive.

     

    I'll try looking into other programs to use and make suggestions to my supervisors. However, I will still try to look into using this particular connector.

     

    Thanks!

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!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,776 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,093 Most Valuable Professional

Leaderboard