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 Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,228)