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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (30,183)