Announcements
I have a list in sharepoint with a dropdown field. I want it that when an item is created, it automaticly picks one of the dropdowns. It needs to be a unique one aswell. Is this possible?
Hello @reinaerd
On SharePointcolumn, you just set the Default value so it automatically sets it.
but then it pics that one, i need it to be unique
If you need it to be unique, then enable the Unique function, but that will defeat my initial suggestion.
If you want to do it in PowerApps, you can do like the item by selecting the First Available option as the default. Your logic would look like this
First(Filter(Choices([@'ListName'].ColName),!(Value in Distinct(ListName,ColName)))
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 316 Most Valuable Professional
11manish 242
Valantis 198
