cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Isley
Level: Powered On

Adding choices to dropdown list from datasource

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 !

 

1 ACCEPTED SOLUTION

Accepted Solutions
hpkeong
Level 10

Re: Adding choices to dropdown list from datasource

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.

hpkeong

View solution in original post

5 REPLIES 5
hpkeong
Level 10

Re: Adding choices to dropdown list from datasource

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.

hpkeong

View solution in original post

Isley
Level: Powered On

Re: Adding choices to dropdown list from datasource

Hi hpkeong,

 

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

 

Thanks for excellent explanation, really appreciate it!

 

With Kind regards,

 

Isley Frimpong

hpkeong
Level 10

Re: Adding choices to dropdown list from datasource

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.
hpkeong
Manu_Agni
Level: Power Up

Re: Adding choices to dropdown list from datasource

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
Level: Powered On

Re: Adding choices to dropdown list from datasource

Hello,

 

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

Thanks! 

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (4,668)