need unique values on combo box

(0) Share

Report

Posted on by RV-13100656-0

onstart:ClearCollect(Colkey,ShowColumns(Filter(
'Global Measures',
'Objective Period' in ComboBoxp.SelectedItems),'Key Priority'));
combobox defaultselectedItems:ForAll(Colkey, itobj_KeyPriority)

combobox items:Filter(
'Key Priorities','Key Priorities (Views)'.'Active Key Priorities')

but am getting on combobox is A,A,A,A but i want A unique values in powerapps

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Farah-F 50 on at

Like
a
(2)

Report
Copy link

Link copied!
Try this in OnStart:

ClearCollect( ColKey, Distinct( Filter( 'Global Measures', 'Objective Period' in ComboBoxp.SelectedItems ), 'Key Priority' ) )

Then set DefaultSelectedItems to:
Filter( 'Key Priorities', Value in ColKey.Value )

and make sure your DefaultSelectedItems references Value instead of the old field name.

This will remove duplicates and show only unique values in the ComboBox.

If my reply helped you fix the issue, you can mark it as a Verified answer so the post is closed and easier for others to find.
And if it was just helpful in any way, feel free to give it a Like ♥.

Was this reply helpful? Yes No
Suggested answer

UshaJyothiKasibhotla 225 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @RV-13100656-0

As @Farah-F Said Use distinct Function to get the unique values in Combobox

For Single Select Combo box Use
SortByColumns(
Distinct(
Filter(
'Global Measures',
'Objective Period'.Value = ComboBoxp.Selected.Value
),
'Key Priority'
),
"Result"
)
For Multi select Combobox Use
With(
{
filteredData:
Filter(
'Global Measures',
'Objective Period'.Value in ComboBoxp.SelectedItems.Value
)
},
SortByColumns(
Distinct(filteredData, 'Key Priority'),
"Result"
)
)

Hope this Helps
Usha Jyothi.

Was this reply helpful? Yes No
MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@RV-13100656-0,

With(

    {

        _kp: Distinct(

                Filter(

                    'Global Measures',

                    'Objective Period' in ComboBoxp.SelectedItems

                ),

                'Key Priority'

            )

    },

    ClearCollect(

        Colkey,

        AddColumns(_kp, 'Key Priority', Value)

    )

)

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
RV-13100656-0 24 on at

Like
a
(0)

Report
Copy link

Link copied!

how can i hide unchecked values on combo box?

Was this reply helpful? Yes No