Distinct Dropdown Results

(0) Share

Report

Posted on by Phineas

4,325

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:

Using Apps Using Formulas

All responses (2)

Answers (1)

Verified answer

WarrenBelz 143,487 on at

Like (0)

Report
Distinct Dropdown Results

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 )
Suggested answer

Phineas 4,325 on at

Like (0)

Report

Distinct Dropdown Results

I figured it out.

If(

JPU_Job_Type_Dropdown.Selected.Value = "Drop",

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