How to show people or group column of a sharepoint list in a dropdown ?
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:
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.