web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Adding choices to drop...
Power Apps
Answered

Adding choices to dropdown list from datasource

(0) ShareShare
ReportReport
Posted on by 4

Hi All.

 

 

I am still a noob in Powerapps. Short question how do you add choices to the dropdown list from a datasource ?

powerapps

Powerapps2

I cant even add my own values in the dropdown list, I tried the standard ["red","blue","green"]  in the item property but no go ! 

 

 

Thanks in regards !

 

Categories:
I have the same question (0)
  • Verified answer
    hpkeong Profile Picture
    2,944 on at

    Hi @Isley

     

    I am sure you had clicked on Advanced to Unlock.

    So, to create a Dropdown list, always use

    - Distinct(DataSource, FieldTitle)

    - Distinct(DS, Regelsoort)

     

    Note: It is NOT really clear and explained in the Syntax, but it is clearly explained in the Example.

     

    You will see Two (2) RED ! showing error. No worry.

    Click on each of them, replace the existing DataCardValue with Dropdown ONLY (for .X and .Y..this is for error comments box)

    and Update = with Dropdown.Selected.Value

     

    Syntax

    Distinct( Table, Formula )

    • Table - Required. Table to evaluate across.
    • Formula - Required. Formula to evaluate for each record.

    Example

    If you had an Employees table that contained a Department column, this function would list each unique department name in that column, no matter how many times each name appeared in that column:

    Distinct(Employees, Department)

     

    Hope this helps.

  • Isley Profile Picture
    4 on at

    Hi hpkeong,

     

    Sorry for the late reply, but it workss !!!

     

    Thanks for excellent explanation, really appreciate it!

     

    With Kind regards,

     

    Isley Frimpong

  • hpkeong Profile Picture
    2,944 on at
    Hi

    Welcome.
    Just sharing - you may change to the input to any means after unlocking and the methods are the same.

    In case of regretting of doing so, you can't undo but just delete the data are, and add add again and it will be locked mode.

    So, no worry at all.

    Have a nice day and wish you good luck on this last day of Chinese New Year.
  • Manu_Agni Profile Picture
    2 on at

    Thanks HPkeong,    It worked.

     

      My 1 cent - If you are changing the name of Dropdown(say DD_Department) then instead of 

    Update = with Dropdown.Selected.Value, it will be

    Update = with DD_Separtment.Selected.Value

  • Riftsan Profile Picture
    15 on at

    Hello,

     

    How would you deal with the update on multiple selections? It seems it only takes the last choice selected. 

    Thanks! 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard