Answered

Shared excel file in onedrive to be added into powerapps

Like (0) Share

Report

Posted on 19 Feb 2023 13:41:40 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:

General Questions

All responses (3)

Answers (1)

Verified answer

BCLS776 8,988 Super User 2025 Season 1 on 20 Feb 2023 at 04:52:12

Like (0)

Report

Re: Shared excel file in onedrive to be added into powerapps

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.
diss2 4 on 20 Feb 2023 at 04:12:08

Like (0)

Report

Re: Shared excel file in onedrive to be added into powerapps

Does it work for onedrive connector?
I have tried and the file is not seen.
please guide if there is a way.
BCLS776 8,988 Super User 2025 Season 1 on 19 Feb 2023 at 16:48:29

Like (1)

Report

Re: Shared excel file in onedrive to be added into powerapps

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