Create new drop down filter using a data field that is an existing drop down

(0) Share

Report

Posted on by apirez

Hello,

Looking on tips on how to create a new drop down using a field thats an existing drop down. Id like to then use this as a filter. It seems in my field list, all the drop downs in my SP List are missing from the options. Any help would be appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @apirez ,

Lets say that you want to filter your gallery/datatable based on a column called "Milestone status". Insert a combo box control and in the items property would look something like this :-
Distinct(Regional.'Milestone Status','Milestone Status')
Here regional is the name of the SharePoint list

now in the gallery's/datatable's items property put the following code:
Filter( Regional, (Len(TabViewMilestoneStatus.Selected.Result.Value) = 0 || 'Milestone Status'.Value in TabViewMilestoneStatus.Selected.Result.Value) )
Here "TabViewMilestoneStatus" is the name of the combobox.

Hopefully this helps 🙂

Was this reply helpful? Yes No