Unanswered

Sharepoint autoselect value from dropdown in list

(0) Share

Report

Posted on by reinaerd

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

cha_cha 4,932 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @reinaerd

On SharePointcolumn, you just set the Default value so it automatically sets it.

✔️
Just in case my response helped you solve your problem, please mark/accept this as a SOLUTION. This helps community members if they experience a similar issue in the future.

🔗
🕸bistek.space 🐦 @cha_bistek 📺 @BisTekSpace

Was this reply helpful? Yes No
reinaerd 3 on at

Like
a
(0)

Report
Copy link

Link copied!

but then it pics that one, i need it to be unique

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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)))

Was this reply helpful? Yes No