Unanswered

Filter Gallery with Input Box, Drop down User Drop Down Box

(0) Share

Report

Posted on by Amenne

I would like to have help on the "Items" filter in the left Gallery. The filter should allow the user to enter a combination of any of the filter boxes on the right to filter the gallery.
BatchID_Input= Text Search Box
Requestor_Box= Distinct('dataSource','Created By'.DisplayName) (Grabs the Sharepoint List distinct entries from the default "created By")
Disposition_Box=

The drop down boxes are working and doing the distinct properly. Now I need the "Items" syntax to use these filter boxes to filter the gallery. The user/people Name is the part I am struggling with most.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

If(IsBlank(Requestor_Box.Selected.Value) && IsBlank(Disposition_Box.Selected.Value) && IsBlank(BatchID_Input.Text),
DataSource,

If(!IsBlank(Requestor_Box.Selected.Value) && IsBlank(Disposition_Box.Selected.Value) && IsBlank(BatchID_Input.Text),

Filter(DataSource, Requestor = Requestor_Box.Selected.Value),

If(!IsBlank(Requestor_Box.Selected.Value) && !IsBlank(Disposition_Box.Selected.Value) && IsBlank(BatchID_Input.Text),
Filter(DataSource, Requestor = Requestor_Box.Selected.Value), Disposition = Disposition_Box.Selected.Value),

If(!IsBlank(Requestor_Box.Selected.Value) && !IsBlank(Disposition_Box.Selected.Value) && !IsBlank(BatchID_Input.Text);
Filter(DataSource, Requestor = Requestor_Box.Selected.Value), Disposition = Disposition_Box.Selected.Value, StartsWith(ID, BatchID_Input.Text)),

If(IsBlank(Requestor_Box.Selected.Value) && !IsBlank(Disposition_Box.Selected.Value) && IsBlank(BatchID_Input.Text);
Filter(DataSource, Disposition = Disposition_Box.Selected.Value),

If(IsBlank(Requestor_Box.Selected.Value) && !IsBlank(Disposition_Box.Selected.Value) && !IsBlank(BatchID_Input.Text);
Filter(DataSource, Disposition = Disposition_Box.Selected.Value, StartsWith(ID, BatchID_Input.Text)),

If(!IsBlank(Requestor_Box.Selected.Value) && IsBlank(Disposition_Box.Selected.Value) && !IsBlank(BatchID_Input.Text);
Filter(DataSource, Requestor = Requestor_Box.Selected.Value, StartsWith(ID, BatchID_Input.Text)),

Filter(DataSource, StartsWith(ID, BatchID_Input.Text)),
)
)
)
)
)
)
)

Just check the names and the language (if it has every "," and so on)

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
Amenne 3 on at

Like
a
(0)

Report
Copy link

Link copied!

Nogueira1306 I am still getting Errors. I cleaned up my naming convention. Here is the proper screenshot.
When I do the input box for the user DropDownBox i get an underlined error.
The Proper Datasource name is: 'MT Print / Bank File Transfer - Payment Services'
Here is the screenshot of the Gallery data points:
Thank you for all of your help!!!

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

If(IsBlank(Requestor_Box.Selected.Value) && IsBlank(Disposition_Box.Selected.Value) && IsBlank(BatchID_Input.Text),
DataSource,

If(!IsBlank(Requestor_Box.Selected.Value) && IsBlank(Disposition_Box.Selected.Value) && IsBlank(BatchID_Input.Text),

Filter(DataSource, 'Created By'.DisplayName= Requestor_Box.Selected.Value),

If(!IsBlank(Requestor_Box.Selected.Value) && !IsBlank(Disposition_Box.Selected.Value) && IsBlank(BatchID_Input.Text),
Filter(DataSource, 'Created By'.DisplayName= Requestor_Box.Selected.Value), Processed= Disposition_Box.Selected.Value),

If(!IsBlank(Requestor_Box.Selected.Value) && !IsBlank(Disposition_Box.Selected.Value) && !IsBlank(BatchID_Input.Text);
Filter(DataSource, 'Created By'.DisplayName= Requestor_Box.Selected.Value), Processed= Disposition_Box.Selected.Value, StartsWith(Title, BatchID_Input.Text)),

If(IsBlank(Requestor_Box.Selected.Value) && !IsBlank(Disposition_Box.Selected.Value) && IsBlank(BatchID_Input.Text);
Filter(DataSource, Processed= Disposition_Box.Selected.Value),

If(IsBlank(Requestor_Box.Selected.Value) && !IsBlank(Disposition_Box.Selected.Value) && !IsBlank(BatchID_Input.Text);
Filter(DataSource, Processed= Disposition_Box.Selected.Value, StartsWith(Title, BatchID_Input.Text)),

If(!IsBlank(Requestor_Box.Selected.Value) && IsBlank(Disposition_Box.Selected.Value) && !IsBlank(BatchID_Input.Text);
Filter(DataSource, 'Created By'.DisplayName= Requestor_Box.Selected.Value, StartsWith(Title,BatchID_Input.Text)),

Filter(DataSource, StartsWith(Title, BatchID_Input.Text)),
)
)
)
)
)
)
)

PLEASE check the anmes. Chaneg the Datasouce name, field names, etc. YOU have to check that.

Was this reply helpful? Yes No