cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JR-BejeweledOne
Super User
Super User

Collection from SharePoint List containing People Picker

I have a list of developers along with their assigned managers.   Because this is used to compare to the Office365Users.MyProfileV2() for various access throughout the app, these are People Picker columns.

 

Each developer is a single line that contains their role (title column) and their Manager(People Picker).

 

I need to create a collection containing the displayNames of the developer and the manager along with the role.   I have tried everything I can think of the bring them into the collection but so far nothing is working.

 

Thanks in advance for the assist........................



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.
1 ACCEPTED SOLUTION

Accepted Solutions

I figured it out.  I am not sure why it wasn't working on Friday, as I did try this then.   Occasionally if I have been working in an app for awhile, strange things start to happen or not happen as the case may be and if I save and exit and don't come back for awhile it all works.

 

ForAll(Developers_1, Collect(DevColl, {Developer: Developer.DisplayName, Manager: Manager.DisplayName, Role: Title}))

 



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

View solution in original post

3 REPLIES 3
rubin_boer
Super User
Super User

hi @JR-BejeweledOne do you get the role from the office connector? 

 

With developer and manager being person columns you could do ClearCollect(colDevs,AddColumns(ShowColumns(YourList,"developer","manager"),"role",Office365Users.UserProfileV2(ThisRecord.developer.Email).jobTitle))

 

unless i am missing what you trying to achieve?

 

Hope it helps

No,the role is specific to the app and not an 'official' property, so it's not available in the Office connector.   The only place it is listed is in the SharePoint list.   Seems that closing out of Power Apps for the weekend and coming back in gave me my collection, but I got the record values for the person columns when I really just need the display names.



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

I figured it out.  I am not sure why it wasn't working on Friday, as I did try this then.   Occasionally if I have been working in an app for awhile, strange things start to happen or not happen as the case may be and if I save and exit and don't come back for awhile it all works.

 

ForAll(Developers_1, Collect(DevColl, {Developer: Developer.DisplayName, Manager: Manager.DisplayName, Role: Title}))

 



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

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,497)