Newbie Dropdown list question

[Arankin1]

Hi.  I'm creating a powerapp with multiple datasources.  I'm trying to write a formula so that I can sort a drop-down box alphabetically and also remove duplicates.  I think I see how to do the more complicated sorting parts, but I'm having a hard time selecting the proper items.  When I use the properties pane to select the datasource and then value it seems to work just fine, but as soon as I try and use a formula I run into problems.

Here's what I have in my working box:

DropdownTechnician.items = Technicicans.Title

The box which doesn't work reads:

DrowdownJobName.items = 'Job & Task List From Dynamics (Test)'.'Job Name'

What am I doing wrong here?  Does "title" have a special meaning and it's only coincidence that it's the name of my column?  I tried using "'Job & Task List From Dynamics (Test)'.title" and that didn't work either.

Thanks for your help.

[eka24]

What is the name of your Datasource that you want to put on the dropdown?

Also show a screenshot of your formula on the dropdown. That would help

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[v-xida-msft · Accepted solution]

Hi @Arankin1 ,

Could you please share a bit more about the 'Job & Task List From Dynamics (Test)'? Is it your data source?

The 'Title' used in your first formula represents the Title column in your Technicicans SP List. If you want to display unique Title value within the DropdownTechnician box, please try the following workaround:

Set the Items property of the DropdownTechnician box to following:

Distinct(Technicicans, Title)

If the 'Job & Task List From Dynamics (Test)' represents your data source, please try the following formula:

Distinct('Job & Task List From Dynamics (Test)', 'Job Name')

and then make sure the Value property of the Dropdown box has been set to Result.

Please try the above solution, then check if the issue is solved.

Regards,

[Arankin1]

Thanks guys.  I think I was able to make this work through trial and error. 

[v-xida-msft]

Hi @Arankin1 ,

Have you solved your problem? Is the solution I provided above helpful for your scenario?

If you have solved your problem, or the solution I provided above is helpful for your scenario, please consider go ahead to click "Accept as Solution" to identify this thread has been solved.

Regards,