Connect with Sharepoint Excel

[SanchezCSG]

Hi guys!

Im running an app that insert rows in excel in my "personal" OneDrive.

I want to insert rows in a excel in SharePoint but PowerApps only let me sincronize Sharepoint lists. There is any way to do this?

[v-micsh-msft · Accepted solution]

Hi @SanchezCSG,

Currently not, but this should be available soon.

Working with files from SharePoint library (SharePoint folders) under PowerApps is not available by now, and there is an idea submitted on this:

Sharepoint Folder as datasource

Status changed to Planned, which means this would be added in the near future.

in addition, currently for Excel related Action under Microsoft Flow, SharePoint connection is not supported, so using Microsoft Flow to insert Excel rows within PowerApps is also not available.

Regards

[pgarmpro]

A year passed, and still no-go...

[andrewbrick]

It is ludicrous that Microsoft is pushing this product when it doesn't have such basic functionality as this.

[bliden]

---

@pgarmpro wrote:

A year passed, and still no-go...

---

And almost ANOTHER year.  WTF?

[RandyHayes]

This is available today.  You can do this with PowerApps and a Flow (or just a Flow).

All with the Excel Online (Business) Connector.

[AndrzejSU]

Hi, I was looking for opening an Excel file with properly defined table as data source (some "dictonary" list) located on Sharepoint. I have a problem with definition of the file location - I cannot do this (!). The data source ExcelOnline(Business) appears on the connection list but when I am trying to use on the form it does not  allow to defne file location.

Which is the problem - do I have a problem with security/license or it is a problem of the connector itself?

[RandyHayes]

@AndrzejSU 

You are trying to use the Excel Online (Business) Connector as a data source.  I don't believe this is what you want.

If you want to use Excel as a data source, the first thing is that you need your Excel in your OneDrive.  Then you can add the datasource by adding a OneDrive for Business connection.  It will then let you choose the file you want as a datasource.

Hope that helps some.

[AndrzejSU]

@RandyHayes 

Excel file on OneDrive has a problem with access rights. Even file located in OneDrive shared to another users need to be given access manualy. In addition if it is located in my drive and I would change its location it would require changes in application (the file location is not a parameter). I was hoping I can read some information from this file located in SP folder for use in my App and the same time make it possible for couple of people to edit records in the table from time to time. This would allow to show some info for users on personalized way.
If it is not correct the question what is ExcelOnline for?

[RandyHayes]

@AndrzejSU 

Yes, these are some of the current limitations with the Excel connector.  As far as I am aware from it, you need to have the Excel file on your OneDrive and share it manually.  The connector does not allow for pointing to another source/location.

The workaround to it may be to take it from another way...consider using SharePoint as your DataSource.  Then, if you still need Excel as a viewing/reporting experience, connect your Excel to the SharePoint list as a data source as well.  Then your Excel will have data from SharePoint and your PowerApp will have data from SharePoint as well.  And now, you can manage access much better - plus you get all the version control and record by record sharing of SharePoint.  There are other limitations with Excel as a datasource and opening and using the file while PowerApps is trying to do the same.

Just a thought to consider...hope it helps spark some thought.