cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
teaful
Helper I
Helper I

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

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.

 

16 REPLIES 16
teaful
Helper I
Helper I

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.

v-bofeng-msft
Community Support
Community Support

Hi @teaful :

The code should be :

Filter(Documents,xxx in xxx)

The point is that the connection is connect to the library 'Documents' instead of the folder 'library-xxx'.

Best Reagrds,

Bof

teaful
Helper I
Helper I

OK, but since it's not working, I'm not sure where to go from here.

v-bofeng-msft
Community Support
Community Support

Hi @teaful :

Could you show me your formula?

Besides, it would be better if you can give me some screenshots.

Best Regards,

Bof

teaful
Helper I
Helper I

Here you go.

Hi @teaful :

'Library-Clients' is wrong,'Documents' is right.

1.JPG

Please use 

Fiter(Documents,XXX)

instead of 

Filter('Library-Clients',XXX)

Best Regards,

Bof

 

teaful
Helper I
Helper I

I had tried it both ways - to no avail. Here is a screenshot with the formula calling Documents. Also I have attached a screenshot of the highlighted fake person's folder to show you that there is indeed documents in her folder.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,035)