Answered

DropDowns in PowerApps

(0) Share

Report

Posted on by kat7777777

112

Hi, I have built an action tracker in PowerApps. The backend is a SP list. I have a gallery which filters all of the "in progress" or "not started" actions. I also have a "Category" column with three different categories choose from. I have created a drop down which allows the user to select from one of the three categories. This is the code from my dropdown:

Sort(
Distinct(
[@'101 HR Action Tracker'],
CategoryDuplicate
),
Value,
SortOrder.Ascending
)

The drop down itself is working. The issue I am having is getting the gallery to respond to the drop down selection that is made. This is the code I currently have in place :

Filter([@'101 HR Action Tracker'],Progress.Value="Not Started"||Progress.Value="In Progress") , Or(IsBlank(Dropdown1.Selected),
CategoryDuplicate = Dropdown1.Selected.Value))

Please let me know your thoughts on what I should change. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Sundeep_Malik 6,499 on at

Like (1)

Report
Copy link

Link copied!

Hey @kat7777777

You can modify your Gallery items property expression to something similar like below:

Filter(
[@'101 HR Action Tracker'],
(Progress.Value = "Not Started" || Progress.Value = "In Progress") && (IsBlank(Dropdown1.Selected) || CategoryDuplicate = Dropdown1.Selected.Value)
)

I hope this helps 🙂

Was this reply helpful? Yes No
MarkRahn 1,351 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @kat7777777 ,
For your Galley, you could try this for your Items property:

If( IsBlank(Dropdown1.Selected.Value), Filter( [@'101 HR Action Tracker'], (Progress.Value = "In Progress" || Progress.Value="Not Started") ), Filter( [@'101 HR Action Tracker'], (Progress.Value = "Not Started" || Progress.Value = "In Progress") && CategoryDuplicate.Value = Dropdown1.Selected.Value ) )

When nothing is selected for Dropdown1, the IF THEN would use the first Filter.

I also used a technique from @mdevaney to add a blank value using the following for the Items property of the dropdown:

Ungroup( Table( {myMenuOptions: Table({Value: Blank()})}, {myMenuOptions: Choices([@'101 HR Action Tracker'].CategoryDuplicate)} ), "myMenuOptions" )

I set it to pull the choices from the Site Column definition instead of from the Distinct values in the column from the list data.

See this link for a reference:
https://www.matthewdevaney.com/how-to-add-a-blank-value-to-a-dropdown-list-in-power-apps/

-Mark
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
kat7777777 112 on at

Like (1)

Report
Copy link

Link copied!

Thank you!!!

Was this reply helpful? Yes No