I have an excel file which is shared to me by another user (owner) via One Drive. How can i use this excel file as my data source? I cannot see any files under "Shared with Me" section when i open one drive from Power Apps.
Currently, the Excel file needs to be in your OneDrive folders, not from a shared source.
You could copy the file to your OneDrive and then you would be able to use it.
I hope that helps you.
Hi @JV_DXB ,
Could you please share a bit more about your scenario?
Do you want to create a connection to the Excel file existed in the "Shred with me" in your OneDrive?
Currently, within PowerApps, we could only create a connection to Excel files stored in OneDrive Files folder (root folder) from an app. We could not create a connection to Excel files stored in the "Shred with me" from an app.
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 Copy the Excel file stored in your "Shred with me" to the Excel files folder in your OneDrive, and then you could create a connection to this copied Excel file in your OneDrive Excel files folder from an app.
At this point there is not a way to use a "Share with Me" file as a data source in your app. Some alternatives are:
1) Switch the role - Copy the file into your OneDrive and Share it with the person who has shared it with you. You would then have the master copy and they would user the file through *their* "Shared with Me".
2) Migrate your file to SharePoint and use that as a DataSource for your App and also as a DataSource for the Excel file. Depending on the nature of the Excel file and what you are using it for, this could get tricky. But, it also highlights a point that once you take an Excel file as a data source for your App, you should really leave it be and only access it with the App. General usage and modifications are not an issue, but if you are going to be accessing it to put in formulas or change the structure of the data, then this will cause issues with PowerApps. As a SharePoint data source, you eliminate this issue, but you also need to restructure your Excel file to "consume" the data from SharePoint - not difficult.
I hope this gives you a little more guidance and is helpful for you.
Check it out!
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
The largest Power BI, Power Platform, and Data conference in New Zealand