cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bouillons
Helper V
Helper V

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:

TitleMgr
FinanceJohn Johnson
MarketingJane 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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
MarvinBangert
Super User
Super User

Hi @bouillons 

please try ForAll('Project Managers',Mgr) as "Items" and "DisplayName" as your Value.

 

Best regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

View solution in original post

1 REPLY 1
MarvinBangert
Super User
Super User

Hi @bouillons 

please try ForAll('Project Managers',Mgr) as "Items" and "DisplayName" as your Value.

 

Best regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (21,058)