Dropdown List filtering data

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi!

I currently have a "search" option that I want to replace with a dropdown option.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous
Add Dropdown control on the screen
Change items Property to

'SPListName'.Title

Add this dropdown to search

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Gallery items Property will be (Search with Sort)
Updated to your Names (Watch for typo )

Note: This will be an issue for Large Dataset.

With( { sData: Sort( 'Equipment Maintenance Log', ID, Descending ) }, Sort( Search( sData, Dropdown5.Selected.Title, "Title" ), AnotherColumn, If( SortDescending1, Descending, Ascending ) ) )

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It didn't work when I tried. The problem that I mentioned is that my column that I'm wanting to search is called "operation" no title. However the option for operation is not in the selection.

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Filter Items for Date, Combobox, and Text Search

With( { sData: Filter( 'Equipment Manitenance Log', IsBlank(ComboBox1.SelectedItems.Value) || IsEmpty(ComboBox1.SelectedItems) || Operation.Value = ComboBox1.Selected.Value, IsBlank(DatePicker1.SelectedDate) || IsEmpty(DatePicker1.SelectedDate) || Date= DatePicker1.SelectedDate ) }, If( Not(IsBlank(TextInput2.Text)), Search( sData, TextInput2.Text, "Title" ), sData ) )

Was this reply helpful? Yes No