Power Platform Community Forum Thread Details

I have what I believe to be a simple scenario, but I can't find how to achieve it. I have a sharepoint list, where one of the columns is a "People or Group" field. I want to show the displaynames of the items in a dropdown in my canvas power app.

The sharepoint list Project Managers might contain for example:

Title	Mgr
Finance	John Johnson
Marketing	Jane Jackson
Sales	Juliet Peters

I want to create a dropdown in my canvas power app with the values John Johnson, Jane Jackson and Juliet Peters.

When I use the datasource 'Project Managers' as the Items field of the dropdown, I can't select Mgr as the Value field, it isn't available (actually, I need the Mgr.Displayname).

I tried a workaround by creating a collection in the onStart, but haven't found the right selection to make to fill up the collection with the displaynames of the Mgr fields, and keep hitting the same limitations.

Stephane

Categories:

Building Power Apps