Hey guys, im trying to do a simple thing - I have a SP List in which the "Title" column have some duplicate values.
In my app, i would like to populate a combobox with all the UNIQUE "Title" values using the Distinct function, but when im doing it, im getting only blanks:
Any idea why and how can i fix this?
**BTW the "Title" column is text.
Thanks
Please post this as a new question. You'll get more responses and others will be able to find the answer more easily later.
Hi mate,
I currently the same problem as you faced back in 2021. I'm working in power apps for teams, trying to distinct value from a SP list, choice column, in a combobox
I have normaly 4 Distinct value comming from my choice column, but only the first one is populated
I also tried the formula of @Pstork1 , but still, only one value is populated
do you have any other advice ? thanks
@RWO - Adding the value field solved my issue with the blank results when using the Distinct Function. Thank you. Two days of banging my head against a wall until finding this!!!
I have changed text data type to combobox in form and tried above formulae for values from table1. Now, I am trying to submit these values to table2. when I changed the defaultselecteditems = parent.default. I am receiving below error. what items I have to change, If I want to save this data to table2
Krishna 09,
you should always use double quotes when dealing with text. Single quotes won't work.
It worked. I used single cots(''), it didn't work but when double cots (" ") It worked. what is the reason?
Hi, Krishna09
You should change your formula to the following: Sort(Distinct(test1,title & " " & 'Name'),Result)
This & " " & means a space between your title and Name. You can change it to "-" or any other symbol you wish
I used below formulae to a comb box, to get combination of two columns distinct values. below formulae worked.
Sort(Distinct(test1,title & 'Name'),Result)
But, I wanted it to be separated by'-' or any other character. because Tittle and Name values are shown without space between them. Someone please help me with this.
Nice Job Warren, every now and then I come across one of your anwers and they never fail me, thanks Sir.
Thanks for this advice! It fixed my problem
WarrenBelz
250
Most Valuable Professional
MS.Ragavendar
126
stampcoin
115