Show only items without folders in a delegable way

(0) Share

Report

Posted on by johnjohnPter

1,811 Super User 2024 Season 1

I have a SharePoint custom list which has one folder and many items, then i am showing the items inside a gallery:-

SortByColumns(Filter(ClientForms,
 
 StartsWith('Client Full Name',TextInputCanvas1.Value)
 ||
 StartsWith('Email Address',TextInputCanvas1.Value)
 ||
 StartsWith('Contact Number',TextInputCanvas1.Value)),"Created",SortOrder.Descending)
 
 
but i will always get the folder as empty item inside the gallery, so how I can remove it in a delegable way?
Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 153,049 Most Valuable Professional on at

Like (0)

Report

@johnjohnPter,

Your posted picture is blank, so I cannot see the issue, however I believe you are referring to a SharePoint Library (not a List). Assuming that 'Client Full Name', 'Email Address' and 'Contact Number' are Single Line of Text fields, that filter should be Delegable if 'Client Forms' is the Library name. However it is not Delegable if 'Client Forms' is only a folder inside the Library as the FolderPath (of which it is part) is not Delegable.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
johnjohnPter 1,811 Super User 2024 Season 1 on at

Like (0)

Report

the 'Client Forms' is a custom list which contain folder.. so how i can exclude folders from the Filter formula i have@WarrenBelz

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,049 Most Valuable Professional on at

Like (0)

Report
@johnjohnPter,

If you are asking whether you can exclude folders from the records returned in a Delegable way, the answer is no as IsFolder (or !IsFolder) is not Delegable.

What you can do however, which is useful for other things is store the folder path, file name and in your case a item type in Text fields in the metadata - the Flow looks like this

and then you can filter using
SortByColumns( Filter( ClientForms, FolderOrFile = "File" && ( StartsWith( 'Client Full Name', TextInputCanvas1.Value ) || StartsWith( 'Email Address', TextInputCanvas1.Value ) || StartsWith( 'Contact Number', TextInputCanvas1.Value ) ) ), "Created", SortOrder.Descending )

You can then also filter with some Delegation on files or folder names.

It also should be easy enough to "back populate" with Edit in Grid View

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

1 people found this reply helpful.

Was this reply helpful? Yes No
WarrenBelz 153,049 Most Valuable Professional on at

Like (0)

Report

@johnjohnPter,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

1 people found this reply helpful.

Was this reply helpful? Yes No