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
