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
2. It led me to this page and I tried adding a new connection, but the excel online option wasn't present.
I'm not sure on how to move on from here.
Any assistance would be appreciated!
@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.
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?
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).
"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.
If you have SharePoint, make a List for the data and it will work so much better than an Excel Table.
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..
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.
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
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,
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!
WarrenBelz
146,776
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,093
Most Valuable Professional