Sharepoint library as a datasource for Form, Gallery or Data Table

(0) Share

Report

Posted on by SearchingYT

107

Hi Power apps experts,

I have a huge sharepoint library with a lot of files.

From my power app, a user should be able open a specific file from the sharepoint library.
In detail, the power app should search for a folder in the sharepoint library and then display the files in that folder.
Then, the user should be able to click on the file and open/download it.

Normally I would do this using a form and attachment control.
But, I am not able to read sharepoint library into a form.

What is the best way to achieve this?

I am also open to convert the sharepoint library to sharepoint list, because list works better with power apps. But, I have no idea how to easily convert a library to a list.

Note: The power app should only be able to display and open files, not upload.

Any help would be much appreciated. Thanks!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SearchingYT

I'm fairly certain that you should be able to attach a SharePoint document library to an app.

If the issue is that it doesn't appear in the list when you try to add a data source, you can generally attach a SharePoint library by typing the name into the 'custom' textbox.

From a form that's linked to a SharePoint document library, you can add a button to download the file with the following formula:

Download(ThisItem.'Link to item')
SearchingYT 107 on at

Like
a
(0)

Report
Copy link

Link copied!

It does appear in the list, but it doesn't display anything.
I am using an editform, with:
datasource = SharepointDocumentLibrary
item = LookUp(SharepointDocumentLibrary,Name="XYZ")
It gives me error saying:
LookUp(SharepointDocumentLibrary,Name="XYZ") = Error. (Error when trying to retrieve data from the network) Data type = Error

I also tried displaying the whole documentLibrary using data table, but almost all the columns are empty..
I also tried a lookup function using a label to get a column value, it aslo give me the same error...

Do you know, how to fix this? 🙂
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @SearchingYT ,

I think this is a temporary problem.

This may be caused by network or your sharepoint connection.

Please try to delete your connection and create a new connection to test it again.

Best Regards,

Wearsky