Connect to Sharepoint Excel

[Anonymous]

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!

[eka24]

You need to create a Table in Excel, then from the picture you showed, click on the onedrive. It will give you an opportunity to Select the Table you have already Created. This will create a connection in your powerapps for you to use as a datasource.

If the Onedrive you have shown is not what you are looking for, the click on new connection and follow the procedure i have stated above.

Follow this video from Brian:

https://youtu.be/zL1H-d2xx80?t=99    (First 5 minutes)

Also https://youtu.be/-Z_13J02RPU?t=178

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[WarrenBelz]

Hi @Anonymous ,

I can tell you this not possible - the only thing PowerApps will connect to in Excel is using a formatted table element when the file is stored in OneDrive.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Anonymous]

Hi @WarrenBelz ,

Thank you for the speedy reply.

I had actually saw previous post on this issue, but those post were dated a few years back.

Furthermore, I saw that Microsoft had pushed out a new connector, Excel Online (Business), - lets you work with Excel files in document libraries supported by Microsoft Graph (OneDrive for Business, SharePoint Sites, and Office 365 Groups).

(Extracted from the following website - https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/)

I saw this new connector and thought it would be possible to work with excel on sharepoint. So, could I just clairfy again the feasibility of connecting the sharepoint excel to power app or did I minsinterpret functionality of the above connector?

Once again thank you for your kind assistance. 

[WarrenBelz]

Thanks @Anonymous ,

I admit I have not seen this, although Premium connector licencing is not justifiable for our circumstances as we can do everything we need on O365 standard (so I was not looking).

I am wondering however of what advantage this would be over OneDrive storage as you would still have to format the area as a table and connect as a data source. You might also check about concurrent opening (other than by PowerApps users) as this is an issue with OneDrive.

[Anonymous]

 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!

[v-yutliu-msft]

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,

[PJR]

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 

[BostonSailor]

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.

[Maxim_EU]

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..