Drop down

(0) Share

Report

Posted on by tonyzhang0510

why are my dropdown options being duplicated?

Categories:

Building Power Apps

All responses (21)

Answers (2)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@tonyzhang0510

Doesn't look like there is anything duplicated in that list. However, I expect that you are refering to those with the & in them as duplicates...

What does your Items property formula for your list look like?
tonyzhang0510 65 on at

Like
a
(0)

Report
Copy link

Link copied!

Choices(Form.Company)
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@tonyzhang0510

I assume Form is the name of your list...what kind of column is Company and how is it defined?
tonyzhang0510 65 on at

Like
a
(0)

Report
Copy link

Link copied!

It is the name of my dropdown field.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@tonyzhang0510

This is in SharePoint as a Choice Column with just the first set of values (not the ones with the &)?

There is no problem with the formula or the concept. I thought perhaps the &'s would cause some issues, but I just tested and there is no problem here.

If you still have the issue - double check your Choices in the choice column in your list and make sure they are good. Then perhaps 1) refresh the datasource in PowerApps 2) delete the dropdown and then ctrl-z to undo 3) change the Items property to DropDownSample, then back to Choices(Form.Company)

See if any of the above helps.
tonyzhang0510 65 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried all the options, however, i had no luck in the end.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@tonyzhang0510

Well, I'm not sure at what step you have had an issue, so I'll provide you my steps.

In SharePoint - created a Choice column on a list. Added your first 6 choices as seen in picture.

In PowerApps - created a new App. Added a datasource to the SharePoint list.

- added a dropdown control to the app.

- set the Items property to Choices(mySource.Column) - same as your Choices(Form.Company).

- added a ComboBox with the same as the above.

Both worked fine.

I am using Chrome for the designer. Just thought I would mention that in case you are dealing with a browser issue possibly.
v-yuxima-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @tonyzhang0510

Could you please share more details of your datasource and the column type?

Best Regards.

Yumia
tonyzhang0510 65 on at

Like
a
(0)

Report
Copy link

Link copied!
Verified answer

tonyzhang0510 65 on at

Like
a
(1)

Report
Copy link

Link copied!

I just deleted the sharepoint column and created a new one, and the problem was fixed. Thanks again!