SharePoint excel table

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All.

I'm running an app that validate using data in excel currently saved in my "personal" OneDrive.

I want to save the excel table in SharePoint instead if my OneDrive but PowerApps only lets me use SharePoint lists.

Is there any way to do this?

Many Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

As far as Iknow, You can only use the Excel Table in the Onedrive not the Excel in the sharepoint.
So I advice you save to the Personal onedrive instead of the Excel in the Sahrepoint
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Unfortunately, Power Apps can't patch/read the data from an excel stored in the SharePoint document library. So what we have OneDrive connection for all excel operations.

Please see the below 2 thread and confirmation from Microsoft team on this:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Connect-with-Sharepoint-Excel/td-p/25055
https://powerusers.microsoft.com/t5/Building-Power-Apps/Write-to-excel-stored-in-sharepoint/td-p/199613

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hiya, thank you for this information.

I did think as much, but wanted to check.

Is there anyway of adding an excel document to any program that can be shared between admins?

Thanks,

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

You can break the permissions on that document in the document library in SharePoint and add the requirement admins.

https://support.microsoft.com/en-us/office/customize-permissions-for-a-sharepoint-list-or-library-02d770f3-59eb-4910-a608-5f84cc297782?ui=en-us&rs=en-us&ad=us

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No