Filter only Folders with the Filter command

(0) Share

Report

Posted on by JoanRuiz

Greetings,

I have a PowerApps that filters the content of a SharePoint List using it's metadata.

Right now, all the files contained in the folders share the same metadata, which makes them show repeated on the serach.

Is there any way of filtering only Folders with the Filter command?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JoanRuiz ,

Do you mean you want to filter the sharepoint list Items inside the Folder?

You can try to filter by the Folder Path. Please see the example:

Hope this helps.

Sik

Was this reply helpful? Yes No
JoanRuiz 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sik, not exactly that, the Filter function is already filtering the content of a library, showing every file and folder on it. I would like the Filter function to delete all the files from the Search and only show the Folders, as the metadata from the files contained in the folder are the same, let me show you an example of how it works now:

I would like to add another "And" that makes it so the result only shows Folders

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JoanRuiz ,

Maybe you can try to filter the list by IsFolder column.

Filter('Share Point', IsFolder)

Then, the gallery only shows all folders.

Sik

Was this reply helpful? Yes No
JoanRuiz 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-siky-msft

Thanks for you help! I finally was able to use the IsFolder option (ÉsCarpeta, in my language) but I am having another issue, every single file in the library appears with IsFolder active, the ID44 has 4 different kind of files(Images, words, etc) but in the Apps, all of them show as Folders:

Is there any workaround for this issue?

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JoanRuiz ,

Could you please share more about your scenario? What is the Items property of Gallery?

I don't have such issue you mentioned, it works well in my test. please check the following screenshot, only folders show the IsFolder true.

Sik

Was this reply helpful? Yes No
JoanRuiz 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sik,

Here is the isFolder option field on my form:

And here in the filter you can see that all of the items are showing the EsCarpeta boolean as Yes, even tho the last one is a file:

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JoanRuiz ,

Yes, It seems to be bug with check box for IsFolder column in Data Table.

You can switch the Control Type to Text Column, then it can show the correct value in IsFolder column.

Hope this helps.

Sik

Was this reply helpful? Yes No
reibalboaOMG 9 on at

Like
a
(0)

Report
Copy link

Link copied!

hi all i have a problem, my data sources is files and folders, (Filter(Documents,'Folder path' = varFolderPath) ) so its folders and subfolders but at the same time i need a search bar from textbox, (Filter(Documents, StartsWith('File name with extension', searchbox.Text))) how can i combine the two filters in 1 combobox

Was this reply helpful? Yes No