cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

Connect with Sharepoint Excel

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?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

26 REPLIES 26
Highlighted
Community Support
Community Support

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

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted

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

Highlighted
Advocate I
Advocate I

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

Highlighted


@pgarmpro wrote:

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


And almost ANOTHER year.  WTF?

Highlighted

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

All with the Excel Online (Business) Connector.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!
Highlighted

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?

Highlighted

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

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!
Highlighted

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

 

Highlighted

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

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (16,308)