Answered

Shared excel file in onedrive to be added into powerapps

(0) Share

Report

Posted on by diss2

I have a n excel sheet which was shared to me from another account in onedrive. So this excel sheet is accessible to me inside onedrive/shared section. I want to add this as a data source inside powerapps.

when i tried connecting using onedrive buissness connector, the shared files are not seen to be added, only those which are created from my account are seen.

What to do so that i can add the excel file which shared to me(I have edit access for this file as well, it's opening without any issue from inside of onedrive).

Thanks in advance for the help

Categories:

Building Power Apps

I have the same question (2)

All responses (5)

Answers (1)

BCLS776 8,994 Moderator on at

Like (1)

Report

Unfortunately, the Excel connector does not work with shared files at this time - the file itself needs to be in OneDrive folder you can directly access. The reason for this is likely because sharing links can expire or be password protected and the connector does not support that.

Hope that helps,

Bryan

Was this reply helpful? Yes No
diss2 4 on at

Like (0)

Report

Does it work for onedrive connector?
I have tried and the file is not seen.
please guide if there is a way.

Was this reply helpful? Yes No
Verified answer

BCLS776 8,994 Moderator on at

Like (0)

Report

No, as I pointed out earlier, the file must be present in the OneDrive account's folder and not merely shared with the account owner.

Was this reply helpful? Yes No
FlyitComPl 43 on at

Like (0)

Report

but is the Excel Online (Business) connector a working solution for the problem with OneDrive for business connector? @WarrenBelz ?

JB

Was this reply helpful? Yes No
Suggested answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi @FlyitComPl,

Microsoft recently changed the connectivity capability in OneDrive of an element called cross drive functionality (see #12 of this article). Essentially it means that only the owner of the OneDrive can utilise an Excel file stored there as a datasource for Power Apps. You need to move the Excel file to a SharePoint Library and share the Library (not just the file) with the relevant users.

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No