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.
Hi @teaful :
I'm not sure if I understand what you mean correctly, please help me point it out if there is an error:
https://xxxx.sharepoint.com/sites/sitesname/libraryname/folder1/folder2/filename
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
@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)
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
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
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?
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?
User | Count |
---|---|
251 | |
102 | |
94 | |
48 | |
37 |