Content Should Appear Only Once in Dropdown

[Anonymous]

I'm using the following in the Items of a Dropdown.

SortByColumns(ApparatusDtlCollection.Park,"Title",Ascending)

This return All 'Title' in order. Some Title appear multiple times. 

How can the formula be edited to return the 'Title' only once.

Regardless of the number of times a Title may appears on the list

it should only show once in the Dropdown. There is currently no

associated 'Depends On' dropdown created.

[FoDelement]

Hello!

You are looking for the Distinct function.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-distinct

[PBIUWO · Accepted solution]

Sort(Distinct(ApparatusDtlCollection.Park,"Title"),Ascending) 

Assuming ApparatusDtlCollection.Park is the table now. 

[Anonymous]

Winner-Winner, Chicken Dinner!

Thanks!