cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

DropDown Issue show double itmes

hi Everyone

I have created a sharePoint list with a colum as choice

Employee - Choice - chice are:

John

Adam

Joe

Mike

 

when i create the powerapp the drop down shows the following

John

John

 

Adam

Adam

 

Joe

Joe

 

Mike

Mike

 

Can anyone help

thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: DropDown Issue show double itmes

Hi @tasefi ,

Can you share more formulas you used in Drop down? Did you check the following options of Choice column?

Annotation 2019-09-09 174847.png

The cause of double items maybe that your formula repeatedly submit choices accidentally.

Please refer to this thread to check if you meet the same problem. https://powerusers.microsoft.com/t5/General-Discussion/Drop-down/td-p/317272

You can use the following test to know if the issue is caused by the source of Choices.

Put a button on your screen and set the OnSelect property to the following:

ClearCollect(test, Choices(SPlist.Employee))

Then set the text property of the button to the following:

CountRows(test)

Alt-click the button, or run the app and click it.  To check if button text is 4 or 8.

 

Solution:

Use Distinct function to show unique value. Set following formula to items of Dropdown.

Distinct(Choices(test1.Staff),Value)

 

Best regards,

Sik

View solution in original post

2 REPLIES 2
Highlighted
Helper I
Helper I

Re: DropDown Issue show double itmes

@tasefi Can you bind your dropdown with other Column of the same SP list and check whether issue is replicating or not. Also you can try using Distinct function to show the unique result.

Highlighted
Community Support
Community Support

Re: DropDown Issue show double itmes

Hi @tasefi ,

Can you share more formulas you used in Drop down? Did you check the following options of Choice column?

Annotation 2019-09-09 174847.png

The cause of double items maybe that your formula repeatedly submit choices accidentally.

Please refer to this thread to check if you meet the same problem. https://powerusers.microsoft.com/t5/General-Discussion/Drop-down/td-p/317272

You can use the following test to know if the issue is caused by the source of Choices.

Put a button on your screen and set the OnSelect property to the following:

ClearCollect(test, Choices(SPlist.Employee))

Then set the text property of the button to the following:

CountRows(test)

Alt-click the button, or run the app and click it.  To check if button text is 4 or 8.

 

Solution:

Use Distinct function to show unique value. Set following formula to items of Dropdown.

Distinct(Choices(test1.Staff),Value)

 

Best regards,

Sik

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,763)