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.
@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 😕 .
thanks but that sucks guess I'll have to write a flow to update all the ampersand values.
@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.
it's a dropdown field from sharepoint
Choices([@'Main Form Information'].Region)
@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?
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.