Answered

how to see Sharepoint subfolders files in the gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Everyone

I have a sharepoint link with me which contains sharepoint folder
eg:
folder a,
folder b,
folder c,

and within these folders I have some Word file and PPT
folder a, -> a.ppt
folder b, ->b.ppt
folder c, ->c.ppt

Now in Canvas app I have took a gallery and connected to the Sharepoint link
I am able to see all the folders and files in the gallery.
I have also added a icon
icon-> On Select ->If(ThisItem.IsFolder,Set(VariablePath,ThisItem.'Full Path'&"/"),Launch(ThisItem.'Link to item',Blank(),LaunchTarget.New))

I want to show all the files(a.ppt,b.ppt,c.ppt) and not the folders in the gallery

It will be really helpfull if some can help me out.

Thanks in advance

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

v-chengfen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,
Here is a test for your reference:
Here is folder

Write this code in the OnStart property of the App:
Set(varFolderPathCurrent, "excel/")

Write this code in the items property of the Gallery1:
SortByColumns(Filter(excel,'Folder path'=varFolderPathCurrent),"{IsFolder}",Descending,"{Name}",Ascending)

3.Restart App

4.Add a Icon ,
Write this code in the OnSelect property of the icon:
If(

    // checks whether the gallery item is a folder or file

ThisItem.IsFolder,

    // get the current location for the selected folder

Set(varFolderPathCurrent,ThisItem.'Full Path'&"/"),

    // open the file a new browser tab

Launch(ThisItem.'Link to item',Blank(),LaunchTarget.New))

Write this code in the Icon property of the icon:
If(ThisItem.IsFolder, Icon.Folder, Icon.DocumentWithContent)

Write this code in the text property of the Label:
ThisItem.'File name with extension'

Here is result

Here is a link for your reference:
Power Apps Navigating Folders & Subfolders In A SharePoint Document Library (matthewdevaney.com)

Best Regards
Cheng Feng
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-chengfen-msft
Thank you so much for your reply
My problem is solved