I'm working on an app, that will read (only read) about 14 columns and 20+ rows from Excel file that, is laying on OneDrive and display it in more user friendly form. I managed to get it working, but only for me, now I want to share it across company.
I theory the file is shared via clickable link, and everyone has access to it, in practice - powerapps cannot access this file, and I suspect I would have to type person to share with Excel file. It's very inconvenient to do this one by one for more than 100 people.
As far as I know MS is working on sharepoint connector for PowerApps for more than 2 years, is there any information when will it be ready? It probably would solve my problem.
But for now, is there any chance to get it working from OneDrive, or do I have to create Flow from file on Sharepoint to PowerApps? I would like it to remain as Excel file, as it is connected via Flow to MS Forms, and would require a lot of changes in both app and Forms.
I would be very grateful for any ideas.
Hi @JachimRRX ,
Currently, if you want other users to access your shared app which use Excel table (hosted in your OneDrive) as data source, you also must share your Excel file to these end users.
Please check the following article for more details:
Currently, there is no convenient way to share Excel file to more than 100 people. In addition, the Excel file stored in SP Library could not be used as data source within an app currently, if you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:
As an alternative solution, you could consider fire a flow from an app, then within the flow, add a "List rows present in a table" action (Excel Online) to retrieve rows from the Excel file hosted in your SP Library, then return the retrieved result back to your app.
Please check the solution I mentioned within the following thread, then check if it could help in your scenario:
I tried solution from the thread you posted and I came across an issue.
I've created flow, created button to run ClearCollect to my collection called "ExcelTableRecords". When I click the button, the collection is created, but it's empty. I see a lot of rows (as if it knew, that excel has multiple rows), but no data is presented.
In flow I used your JSON script, just added columns (as I have more of them). Only thing, that comes to my mind is data type. In flow I have string for every column, but in excel, most of cells have general.
But running a Flow on the same datasource as the App causes an 'in use' error message when trying to save to Excel from PowerApps
(conflict when Flow and PowerApps both try to access the same datasource)
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.