Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Powerapp dropdown duplicating selection but not exactly

(0) ShareShare
ReportReport
Posted on by

basically my dropdown selections are supposed to look like this:

miguelrodrigue_0-1607008199930.png

and those show up fine but at the end of the list these also show up:

miguelrodrigue_1-1607008239619.png

it's very odd. those aren't in the dropdown list items on SharePoint, I've checked.

 

  • RandyHayes Profile Picture
    RandyHayes 76,287 on at
    Re: Powerapp dropdown duplicating selection but not exactly

    @Anonymous 

    So then you have the option to allow write in values on that column?

    I didn't re-read the post to thoroughly to recall every thing about the problem.   Just knew that I encountered it a while back. 

    In General, there are two things I always avoid in SharePoint - spaces and special characters.  I know that SharePoint now supports most all of that (didn't in the very beginning 20 years ago) but I don't think they ever resolved "everywhere" support for them in SharePoint - you would think 20 years would have been ample time to do so 😕 .

  • Re: Powerapp dropdown duplicating selection but not exactly

    thanks but that sucks guess I'll have to write a flow to update all the ampersand values.

  • Verified answer
    RandyHayes Profile Picture
    RandyHayes 76,287 on at
    Re: Powerapp dropdown duplicating selection but not exactly

    @Anonymous 

    Thank you...that jarred my memory and was able to find the post.

    Take a read through this post from (actually) a year and a half ago.  It even references back to an even earlier post where this was spotted.  They were supposed to have fixed it, but you might find some answers in that post.

  • Re: Powerapp dropdown duplicating selection but not exactly

    it's a dropdown field from sharepoint

    Choices([@'Main Form Information'].Region)
    

     

  • RandyHayes Profile Picture
    RandyHayes 76,287 on at
    Re: Powerapp dropdown duplicating selection but not exactly

    @Anonymous 

    This has been a long outstanding issue with columns that contain ampersands in them.  I have tried to look back in the posts (as I discovered and solved that problem about 2 years ago) but have not found it.

    There is no need for a collection for this and will not solve the problem.

     

    What type of column is the column that is displayed in your ComboBox?

  • notj Profile Picture
    notj 780 on at
    Re: Powerapp dropdown duplicating selection but not exactly

    Can you post the formula for the "Items" value of the drop down?

     

    My initial suggestion without any more info would be to bring those values into a collection using ClearCollect and then set the drop down item property to that collection.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard