Filter a gallery for People column, 2 text columns, and a multi choice column

(0) Share

Report

Posted on by SinaM

Helly everyone,

I am working on a gallery that I want to have 4 methods of filtering.

First way is through typing the name of the person which is connected to my people column on SharePoint. Second way will be through a choice column filter based on the status of the file. Third and fourth methods will be through text columns (based on the file number and address)

My choice column is called Status and is connected to a combo box called "StatusBox"

My text column for file number is called Filenumber and is connected to a text input called "Fileno"

My text column for the address is called AddressCol and is connected to a text input called "Addfile" XXX

My people column is called Responsible and is connected to a text input called "Assignedto" XXX

So far I came up with the following which makes the filtering work only for file number column (text column) and status column (choice column). However, I am not sure how to include the other text and people column into this code.

Items:

Search(

Filter('Files List', IsBlank(StatusBox.SelectedItems) || IsEmpty(StatusBox.SelectedItems) || StatusBox.Selected.Value in Status.Value),

Fileno.Text,

"Filenumber"

)

Your help would be greatly appericiated

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report
Hi @SinaM ,

You could use the below pattern:

Filter( 'Files List', CountRows( StatusBox.SelectedItems ) = 0 || Status.Value = StatusBox.Selected.Value, IsBlank(Assignedto.Text) || StartsWith( Responsible.DisplayName, Assignedto.Text), IsBlank(Fileno.Text) || StartsWith( Filenumber, Fileno.Text ), IsBlank(Addfile.Text) || StartsWith( AddressCol, Addfile.Text ), )

Note if Filenumber number is ever changed to a Number data type rather than Text, change "Fileno.Text" to " Value(Fileno.Text) " (non-delegable).

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

SinaM 40 on at

Like (0)

Report
Thank you for your answer.
I had an incompatible error for the status combo box. However, I changed it to this and it worked:

Filter( 'Files List', CountRows( StatusBox.SelectedItems ) = 0 || StatusBox.Selected.Value in Status.Value, IsBlank(Assignedto.Text) || StartsWith( Responsible.DisplayName, Assignedto.Text), IsBlank(Fileno.Text) || StartsWith( Filenumber, Fileno.Text ), IsBlank(Addfile.Text) || StartsWith( AddressCol, Addfile.Text ), )

Was this reply helpful? Yes No