Distinct Dropdown Results

(0) Share

Report

Posted on by Phineas

5,331 Moderator

I have Dropodown_1 (Job Type) and Dropdown_2 (Location).

Dropdown_1 has in its items - ["Drop","Install","Storm Work","Trip"]

 
A Location may appear multiple times in the data source (SP List).

I only want each Location to appear in Dropdown_2 once (Distinct).

How do I update the below formula so that the dropdown only shows

each Location once?

Dropdown_2 has in its items -
If(
   JPU_Job_Type_Dropdown.Selected.Value =  "Drop",
   Filter(colPendingDropData,colPending_Invoice_Type = "Drop",colPending_Location),
   JPU_Job_Type_Dropdown.Selected.Value =  "Install",
   Filter(colPendingInstallData,colPending_Invoice_Type = "Install",colPending_Location),
   
   JPU_Job_Type_Dropdown.Selected.Value =  "Storm Work",
   Filter(colPendingStormWorkData,colPending_Invoice_Type = "Storm Work",colPending_Location), 
   
   JPU_Job_Type_Dropdown.Selected.Value =  "Trip",
   Filter(colPendingTripProjectData,colPending_Invoice_Type = "Trip",colPending_Location))

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

I figured it out.

If(

JPU_Job_Type_Dropdown.Selected.Value = "Drop",

Sort(Distinct(Filter(colPendingDropData,colPending_Invoice_Type = "Drop"),colPending_Location),SortOrder.Ascending))

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,447 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
I would have thought it would it would be something like this
Sort( Distinct( Filter( colPendingDropData, colPending_Invoice_Type = JPU_Job_Type_Dropdown.Selected.Value ), colPending_Location ), Value )

Was this reply helpful? Yes No