Adding choices to dropdown list from datasource

(0) Share

Report

Posted on by Isley

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:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

hpkeong 2,944 on at

Like (1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Isley 4 on at

Like (0)

Report
Copy link

Link copied!

Hi hpkeong,

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

Thanks for excellent explanation, really appreciate it!

With Kind regards,

Isley Frimpong

Was this reply helpful? Yes No
hpkeong 2,944 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Manu_Agni 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Riftsan 15 on at

Like (0)

Report
Copy link

Link copied!

Hello,

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

Thanks!

Was this reply helpful? Yes No