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
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

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 (9,249)