Unanswered

CANVAS APP: Show document library contents (files) based on URL to that folder in SharePoint list

(0) Share

Report

Posted on by teaful

I have a gallery connected to a SharePoint list named Clients. Within this list, there is a column [Type: Hyperlink] with a link to the client's folder living at [Documents/General/Library-Clients/[client name here] ].

I cannot seem to figure out how - when a client is selected in the gallery - to have their files show up in a gallery/or... below their data detail. Can someone lead me in the right direction perhaps? Screenshot attached.

The folder link is in a column called 'Client Folder' in the screenshot.

Categories:

Building Power Apps

FilesForSelectedO...

I have the same question (0)

All responses (16)

Answers (0)

v-bofeng-msft on at

Like (0)

Report
Hi @teaful :

I'm not sure if I understand what you mean correctly, please help me point it out if there is an error:

There is a Hyperlink column named "Client Folder" in your SP list.

The value in The Hyperlink column is the value of "'Link to item'" of the file in Library.Some thing like:

https://xxxx.sharepoint.com/sites/sitesname/libraryname/folder1/folder2/filename

You want to get a preview of the file through the Hyperlink column and display it.

If so,You can find the specified file in the library through lookup, and then call its Thumbnail property to get the thumbnail of the file.I'v made a test for your reference:

1\My SP list

2\My Library-picc

3\Add a gallery and set it's items property to:

ListA

4\Add a image control into this gallery and set it's Image proeprty to:

LookUp(picc,Text(ThisItem.'Client Folder') in 'Link to item').Thumbnail.Medium

The Result:

Best Regards,

Bof

Was this reply helpful? Yes No
teaful 33 on at

Like (0)

Report

@v-bofeng-msft , The link is actually to a FOLDER rather than an individual file. In my PowerApp, I have the need to display the contents of a folder based on the client chosen in a gallery.

the attached pic highlights what needs to happen. when clicking on a client, their details come up. The field you see called "Client Folder in Document Library" should have it's contents displayed in the attachments section. (Attachments is only there as a placeholder for now)

showdocs.JPG.png

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Hi @teaful :

Do you mean "Client Folder" is a link to a folder?Something like:

https://XXXX.sharepoint.com/sites/SitesName/LibraryName/Folder1/Folder2

If so,please try this solution:

1\Add a gallery(Gallery4) and set it's items property to:

ListA

2\Add a gallery(Gallery3) and set it's Items property to

Filter(picc,Gallery4.Selected.'Client Folder' in '{Link}',!IsFolder)

3\Add an image control into Gallery3 and set it's image property to

ThisItem.Thumbnail.Large

Best Regards,

Bof

Was this reply helpful? Yes No
teaful 33 on at

Like (0)

Report

I'm getting an error unfortunately. I even tried creating a new 'client folder' column that was text only, but ended up getting the same error. (attached). Could it have anything to do with the fact that my folder is nested 3 deep within Documents?

error2.png

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @teaful :

The key is that the library is cited incorrectly. Because the name contains the special character "-", you can try to use ‘library-xxx’ to refer to this library.Something like:

Filter('Library-xxx',xxx in xxx)

Best Regards,

Bof

Was this reply helpful? Yes No
teaful 33 on at

Like (0)

Report

Thank you v-bofeng! I'm glad to learn about the dash in a file name and the need for quotes.

After adding the single quotes though, I received a different error saying that the item doesn't exist. Does this formula/process automatically search the "Documents" library that I have added as a connection, or do I need to put in the full path to the exact folder I need?

error2 (2).png

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @teaful :

Have you added this library as a data source?

Best Regards,

Bof

Was this reply helpful? Yes No
teaful 33 on at

Like (0)

Report

Yes, I've connected to the parent folder called "Documents". The folder 'Library-Clients' lives WITHIN "Documents". I can't seem to connect to anything but the parent folder. Should I be able to make a direct connection with Documents/General/Library-Clients?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @teaful :

Could you give me some screenshots?

Best Regards,

Bof

Was this reply helpful? Yes No
teaful 33 on at

Like (0)

Report

I have connected to "Documents", but in my filter I reference 'Library-Clients' which lives within Documents. I've screenshotted the path for you also.

pathDocumentLibra...

connector.JPG.png

gallerydatasource...

Was this reply helpful? Yes No