How to access a excel table through SharePoint library

(0) Share

Report

Posted on by Sahara22

568

Hello,

looking on how to use the “lookup” function to grab info from a table1 from an excel sheet that’s stored in my SharePoint documents library.

right now it just says documents. The excel file I have in not in a folder.

I have : lookup (documents, then I’m stuck here )

thank you !

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Sahara22 ,

Unfortunately the Excel connector does not currently support reading files Tables in Excel files in a SharePoint Library - the Excel file needs to be stored and shared in OneDrive.

Please click Accept as solution 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 giving it Thumbs Up.

Visit my blog Practical Power Apps
Sahara22 568 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @WarrenBelz ,

thanks very much . I have a power app application that has over 400 people that use an excel sheet to get data from through the a power app and wanted a way to share this file publicly (company wise) so that i don’t have to give individual access to the excel file. Is there another way to do this ? I made a public SharePoint site and uploaded the file their but I guess that won’t work now . Thanks
WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Sahara22 ,

Make a folder in your OneDrive, put the file in there and share it with all company.

Please click Accept as solution 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 giving it Thumbs Up.

Visit my blog Practical Power Apps
Sahara22 568 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you.
Sahara22 568 on at

Like
a
(0)

Report
Copy link

Link copied!

Just wanted to add , the other issue is I had
someone delete the file , anyway to hide it from the one drive if I give access to all?
WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Sahara22 ,

A bit difficult, but you do not have to give them the URL (so they will not know how to find it).