cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BrianJ
Level: Powered On

Duplicate items in dropdown

I have a dropdown pulling data from a sharepoint list that is duplicating 2 companys.  Screenshot attached.

FarmerScreen.png

The ones that are duplicating have more than 50 records to them.

 

Here is the code I am using for it.

Sort(Distinct(Inventory,Company),Result)

Can someone tell me what I am doing wrong?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Duplicate items in dropdown

Hi @BrianJ,

Try

Sort(Distinct(Inventory,Trim(Company)),Result)
5 REPLIES 5
Super User
Super User

Re: Duplicate items in dropdown

Hi @BrianJ,

Try

Sort(Distinct(Inventory,Trim(Company)),Result)
BrianJ
Level: Powered On

Re: Duplicate items in dropdown

Thank you!!!

Super User
Super User

Re: Duplicate items in dropdown

Hi @BrianJ,

Since my suggestion worked, you apparently had some spaces following the names.

cwebb365
Level 8

Re: Duplicate items in dropdown

Surely the spelling of Company is the issue 🙄
BrianJ
Level: Powered On

Re: Duplicate items in dropdown

lol I didn't even notice that!!! Thanks @cwebb365