basically my dropdown selections are supposed to look like this:
and those show up fine but at the end of the list these also show up:
it's very odd. those aren't in the dropdown list items on SharePoint, I've checked.
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.
@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?
it's a dropdown field from sharepoint
Choices([@'Main Form Information'].Region)
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.
thanks but that sucks guess I'll have to write a flow to update all the ampersand values.
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 😕 .
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 757 Most Valuable Professional
Michael E. Gernaey 322 Super User 2025 Season 2
MS.Ragavendar 209 Super User 2025 Season 2
