Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create dropdown menu fed from Common Data Model entity column


Use CDM to store large lists to be used as a dropdown field in a Power App based on a SharePoint (cloud) list. 


SharePoint list has columns Surname, Name, and Department. I want "Department" values to be entered via a dropdown menu. That dropdown menu would be populated by a CDM entity called Departments.




We currently use SharePoint lists and workflows together. Large look-up lists are VERY slow on PowerApps. We also use site columns which aren't even supported in Power Apps altogether. 

Can it be done? 


Advocate I
Advocate I

I also need this answered for a client. I would have thought you could, but maybe the binding doesn't allow. Awaiting help on this.

Resolver II
Resolver II

I have this same situation.  I am trying to use the values in a SharePoint List to populate a column in a CDM entity and would like to be able to use any of the following columns from my SharePoint List (dd_Name, dd_Display_Name, dd_Description).


Any instructions or documentation that would allow this to happen???

Community Champion
Community Champion

Hi @Anonymous


Dropdown can always be generated using:

Distinct(SPLTable, FieldTItle)

In this case

Distinct(SPLTable, Department0.

- Distinct will not show repeating fields.


(ShowColumns will show repeating column). Please take note).


Hope this help.


TQ and have a nice day.


Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!


Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (55,119)